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.
Hello, thanks for asking. Currently all our system is based on Apps Script and Sheets, but I’d to migrate to AppSheet.
In our company we have some Google Slides Presentation Templates that user needs to use depending on the topic he is going to present to our leadership.
When he clicks a button to create presentation, the script automatically generate a copy of the template, modify the name, save in a specific folder and the copy opens to the user edit as he wants.
I didn’t see this response from 5 months ago or I would have offered this suggestion then.
You can create a trigger within the Google Script to run the script process based on a sheet change. I would tie a row in a sheet to an AppSheet button that toggles a value - say from false to true.
The script triggers on a sheet change and then inspects that the button value has been set to true. If so the script continues with its normal routine to create/copy and when completes, resets the button value to false.
If not, i.e. the button value is still false, then the script exits early without doing anything.
Appart from the script, I was interested to know if AppSheet is able to generate google slices based on a template like currently possible with Google Doc, Excel and Word documents.
We can't achieve this with Action alone, but now it's easy to achieve similar functionality with Apps Script integration.🤗 (I believe this thread is from before Apps Script integration was released)