Calling Apps Script from AppSheet Automations

Learn how to call Apps Script functions from AppSheet Automations!

Product: Google Workspace
#GoogleWorkspace

[man_vs_life]

It's really nice to see Appscript being integrated. Is it the end of the onChange event-trigger "hack"? (I currently use an Action button to assign a column a trigger value to run a script).

The biggest issue of sorts I would still have is that there doesn't seem to be any way for Appscript to communicate back to Appsheet, e.g. to notify that a script has finished running or failed or whatever; and that changes made to a spreadsheet via Appscript (or manually) are only updated immediately if the App is manually re-synched.

Anyway, a step forward. Thank you folks.

[PinpointTravelerBookings]

Why doesn't this work for an appsscript that is bound to a google sheet? That seems to be a pretty big miss

[AutomationWithSholz]

Wow ! Appsheet's getting dangerous now..
I wish they'd improve in their marketing though, such a valuable tool not too known in the market space

[smac]

Why can't I just run a script from an action directly?

[emilioortega]

Anyone knows how to show to the App Sheet user the results of the App Script return?

[heliosgames]

Question for you, I have a row which has a title and list of references to another table, im trying to send that list to appscript but it always appears as none, I've tried to dereference is using [list][Column] but that also returns null.. how would I do such a thing?

[alejomoreno]

Hello, thanks for the tutorials, now I have a challenge to make an app in one of its functionalities is to have a screen to scan barcodes continuously that at the same time records and automatically reopens the camera to read the next code. This is possible?
Thank you

[aiymankhan]

You made it right on time. I was looking for this feature!