update the row color based on the entered valueĬtBackground("#00ff00") //sets row color to greenĬell. If you don't see the Google apps launcher on the page, you might not be able to add that app to the App launcher. To place the shortcut on your phones home screen, tap Create Shortcut. If you wish to see the preview, tap Try this Shortcut. On the confirmation screen, youll have the option to edit the shortcut labels as well as the app icon. Tap Apps, and select an app of your choice. Below the app name, select Add a shortcut. On your device, launch the Shortcut Maker app. check that the edited cell is in the trigger column You can also add Google apps you use that don't appear in the 'More' section. get the edited value for the cell as a string Var colorRow = sheet.getRange(thisRow,thisCol,1,Cols) set a range variable for the entire row get the cell you edited and the associated column and row number function to update row color using entered text in a specified "trigger" column *you will need to add an onEdit trigger to your project You can use this to do anything that can be done on the sheet via scripting such as change values, set font weight, copy data, or even run other functions after checking the trigger text input. I've provided an example below for how to change row color based on trigger text in a designated "trigger" column. If you need something to process more quickly you may have to look for an alternate approach. The biggest downside to this approach is that it takes (at least for me) approximately 7 full seconds for the onEdit trigger to catch the change and perform the update. You can then set an onEdit event trigger in the project's triggers under "Resources" in the script editor for your hotkey function. One possible work around for this would be to dedicate a column for "trigger text", define different text based triggers for each action you're trying to perform, and then create a function that checks the value and performs an action based on the "trigger text".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |