How can i update a single record from google sheets with a switch?

[TIMAI2]

Yes, that is the general idea. The script uses the record index and tests the first item. You may want to change this to test your ID number.

You may also get some ideas from here:

Google Sheets For AppInventor (replicant!)

Based on the work of Tommy Heng, a google apps script version of the proposed built-in MIT Google Sheets component. Can be considered as a primer on how to use google apps script to do all (?) the things people want to do with google sheets....Includes a barebones aia project (with script file) for developers. [GSFA2] [GSFA1] [image]