Create a Button that works in mobile in Google Sheets 

What a kind comment. Thank you so much!

Thanks for the comment!

Excellent! Hope it was helpful

Thank you for commenting!

Thank you!

Thank you for commenting! Regards!

Thank you!

Thanks!

Thank you so much! Regards!

Please let me see your code to see if we can find the mistake Regards!

Thanks for commenting!

Excelente!

Thank you! Any specific error?

You cannot trigger the event via the button on a mobile device! That is why he proposed the workaround with the onEdit(e) function which works perfectly.

Thank you!

Hello! Were you able to solve it? Regards!

same question

You probably need an else if for every other button, where you check if a different combination of sheet name/cell is active, and then you run a different function inside the else if

Mmmm Very interesting I´m not sure how to do it There is a trigger onSelectionChange Maybe we could try that but it may make the sheet really "heavy" Kind Regards

Ahh, I think it's because my function imports data from another file - looks like onEdit cannot access other files? Is there a workaround?

@@jonnybolton4659 Hi, I was experiencing the same issue. I had the exact same code as the video but when I wrote my own function it didn't work. I had my cell A1 notation written between single quotation marks like this 'I4', I was so frustrated that just to try I changed them for double quotation marks because I used those in my own function and it worked that way. So my advice is that you check that you are using the same quotation marks (either single or double) in both your original function and your onEdit one. I really hope you manage to make it work. Good luck

Thanks. That wasn't the issue though it was because my function was trying to access other files in the Drive. The onEdit trigger doesn't allow this to happen but you can do this with "Installable triggers", I spent all afternoon going down that rabbit hole!

Hello! I´m glad you figured it out on your own, and apollogies for not getting back earlier. You are right There are 2 kinds of triggers in GAS: manual and installable manual are the functions you write such as onEdit or onOpen These are great because they remain in the file if you make any copies However their big limitation is that they cannot connect to services (They can not send an email, creat an event, or connect to another spreadsheet) This is when the second type of triggers come by. These are called installable triggers. As its name suggests, you need to install them on the "Triggers" menu in your GAS Editor. When you install them or create them they will sak for the permission, thus you won´t need it again The bad part is that they only exist on that file, that means that if you ever do a copy you need to be careful because the triggers will be erased and you need to create them again Hope I shed an additional light Regards!

@@practicalsheets thanks so much! One thing I did notice was when running the sheet in two different accounts, it always accessed the _owners_ files and not the _users_ do you know of a simple fix for this?

You probably need an else if for every other button, where you check if a different combination of sheet name/cell is active, and then you run a different function inside the else if

Hello! You should have only one onEdit And them imside this onEdit you may include all of the functions you want to execute Regards!

Creating the checkboxes is not difficult. The question is what function do you want to execute with each box Kind Regards

If you want, you could share the code Kind Regards

Hello! Thanks for the interest You may download all templates in the patreon page practicalsheets.com/patreon Kind Regards

Unfortunately no Regards!

@@practicalsheets Thank you. It does work using Desktop mode, but it's super cumbersome.

@@LostOrStolen You are right. It's horrible!

Did you manage? Regards!

I also have the same issue, the checkbox worked with the counter function, but then when I use my own function it doesn't work, even though the button (and keyboard shortcut) both work

Did you get an answer for that?

@@jeanaimegakwerere8591 yeah. See my other comment

I don´t think it is possible to do a menu in Mobile, but I may be wrong Regards!

Thank you!

For this type of function you need to have an "installable" trigger onEdit wont work because it needs to acces the Spreadsheet service These are the steps 1. Change the name of onEdit function to any name you want, for example function thingsToDoOnEdit(){} 2. In the GAS Editor, at your left go to "Triggers" (A clock icon) 3. CLick the "Add trigger" button 4. Choose your function 5. On "type of event" choose "On edit" 6. Click save 7. enjoy Let me know if it works Regards!

OF course. LEt me know your problem Regards!

As far as I know, custom dialogs won´t work in mobile Regards!

Double check that you included the exact name of the function without parenthesis in your button Kind Regards

@@practicalsheets REALLY very grateful for your help and knowledge. Here's what I have If copies and pastes to last row and then clears the data. function NRunCheckBox() { const ss = SpreadsheetApp.getActiveSpreadsheet(); //Collect the Players const sourceSheet = ss.getSheetByName("Game"); const sourceRange = sourceSheet.getRange ('B2:I2'); const sourceVals = sourceRange.getValues().flat(); const sourceSheet2 = ss.getSheetByName("Game"); const sourceRange2 = sourceSheet2.getRange ('B12:I12'); const sourceVals2 = sourceRange2.getValues().flat();//added // Append the data const destinationSheet = ss.getSheetByName("History"); destinationSheet.appendRow(sourceVals); const destinationSheet2 = ss.getSheetByName("History"); destinationSheet2.appendRow(sourceVals2); var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('B2:I11').activate(); spreadsheet.setCurrentCell(spreadsheet.getRange('I11')); spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true}); }; function onEdit () { let activeCell = SpreadsheetApp.getActiveSpreadsheet ().getActiveCell() let reference = activeCell.getA1Notation() let sheetName = activeCell.getSheet().getName() let activeValue = activeCell.getValue() if (reference == "D20" && sheetName == "Game" && activeValue == true) { NRunCheckBox() ; activeCell. setValue(false); } }

@@practicalsheets I found something interesting. So the script works with the button but not the checkbox. The checkbox is actually executing the previous script I had. Even though I gave the button a different name and am using the same name as the button in the onedit statement.

I GOT IT WORKING!! Yay thank you again. I had saved it as a macro and that was the problem. Changed it to a script. Now all I need is to get the date to append to the data range line.

@@alicenigl5862 Hello! Do you by any chance have 2 onedits? Regards!

You solved it with that?

Hello! Nice comment! As a rule of thumb, I try to avoid Google Sheets in cell phone, and prefer to use AppSheet or build a webapp Kind Regards