I have created a script for a rather simple spreadsheet that is tracking PO's for a small company. A couple different people have been granted permission to issue them, but these people are very often in the field and not in an area conducive to desktop use. The script I wrote simply adds a new line at the top of the data table, inserts the date and inserts the PO # in the new row (so that the newest data is always at the top). This was great until I tried to show them how to do it on their phones, and the button I made would not activate the script. My research has informed me that the functionality is not in the mobile version of Sheets. I did see some posts indicating possible workarounds with triggers; unfortunately, I have not been able to make any work.

Does anyone have any thoughts that could help me?

  • 2
    You really ought to describe the methods you've already tried, otherwise any solutions will probably suggest the same ones, and then everyone's time is wasted. – ale Feb 22 '18 at 1:01
  • Could you use a Google Form instead to capture the data? It would get put into a spreadsheet (new rows at the bottom). – OnenOnlyWalter Feb 22 '18 at 1:43
  • Since this question is about using scripts on a mobile app instead of a web app it looks to be off-topic on this site. – Rubén Feb 22 '18 at 2:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.