This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Figured out the solution (not pretty though!) with the help of this
article:
https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-add-row-per-value-in-EnumList/m-p/357133
I have an appsheet app for taking meeting notes. The meeting notes are
stored as a field in the ASDB. When a new meeting is created, I want to
automatically add TODOs in the "To-dos" table in the same ASDB and was
looking to write an app script for t...
I got around this by writing an appscript function in the underlying
google sheet to convert the address field into city:function
ConvertToCity(address) { if (!address) { return null }; var response =
Maps.newGeocoder().geocode(address); var result =...