Impossible to create a google calendar event after appsheet created a new row on a table

[vramirez80]

Hi all, how are you?

I.m making an appointment app that creates an appointment in a table, after that a script in appscript was created to create a google calendar event based in the specific appointment but the event is never created from that way, if  the appointment is created manually (I mean if I past the complete row in the sheet) then the script is executed, apparently it has to do with the way that appsheet creates new appointment, at least that is what google gemini says to me. 

Can someone help me with an advice on how to do it without using automations?.

For now I created an action that creates the calendar event from the specific appointment when I press it.

Thanks in advance for the help

[Steve]

It sounds like you want to create a Google Calendar event according to some data captured in a row of another table of your app. This should be readily possible using just AppSheet with no need for App Script.

1. Connect your Google Calendar as a data source for your AppSheet account.

2. Add the desired calendar as a table to your app.

3. Create a bot on the table that receives the appointment (not the calendar table) that responds to adds.

4. In the bot's process, add a step that performs a data change action that adds a row to the calendar table using the data from the added appointment row.

[Steve · Accepted solution]

If you don't want to use a bot, do this instead:

1. Same as above: connect your Google Calendar as a data source for your AppSheet account.

2. Same as above: add the desired calendar as a table to your app.

3. Create an action on the appointment table that adds a row to the calendar table using the data from the appointment row.

4. Set the action from (3) as the Row Saved event action on the form view used to add rows to the the appointment table.

[vramirez80]

Thanks a lot, problem solved with the second method to avoid automations. 

Npw that you gave me the solution comes to my mind the idea of execute several actions on row saved