Hi,
I have a script to pull data from my project management software into a google sheet, where it is then displayed along with a heap of other stuff in App Sheet.
I want to be able to add a new task to the project management software from app sheet.
Ideally I would like a form in App Sheet, which then does an api call to my project management software to submit the new task, call a function in google app script to sync and pull the new task into the sheet, then force AppSheet to do a reload.
the second part is possible, and from what ive read the last part is possible too, however im unsure about the first. From what I can see a form can only save to a table?
My best guess is to have a seperate table eg temp tasks, have the form enter the data into that table, on save do the api call, trigger the google app script function, do the reload. seems a bit inefficient so was just wondering if there was a way to skip the save to a temp table step and go straight from a form to an api call.
Any help or suggestions would be great! thank you!
LinkedIn
Twitter
