Google Calendar Sync

[CJMFS]

Hello AppSheet Team,

I had a question regarding connecting the AppSheet to a shared google calendar. I have a google sheet that have converted to an app on AppSheet that our company sends out to our customers for them to answer. One of the questions they answer is a "Preferred Date" in which they would enter a date to do the service. My question is based on that date that our customer submits, is there a way to have that date connect and create an event on a shared google calendar?

Thanks, 

[Suvrutt_Gurjar]

Are the customers adding whatever their record details with  "Preferred Date" through AppSheet app?

If, so yes, yes generally you should be able to do so using the action type "Add a new row to another table using  values from this row".

When the customers add record, you could invoke the above e action on their form save.

[CJMFS]

Yes the customer is able to add whatever date they want to add. So then my next question is how to connect a table and a google calendar?

[Suvrutt_Gurjar · Accepted solution]

Please take a look at the following post on the action I mentioned.

https://www.googlecloudcommunity.com/gc/Announcements/New-Action-Add-a-Row-to-a-table/m-p/273668

Please take a look at the below article to understand actions in general.

https://help.appsheet.com/en/articles/953637-actions-the-essentials#external-open-a-file

Your action in general will look like below

In the example below , whenever a new order is added to the Orders table, a new row is added to the "primary" table which is a Google calendar table using values ( [order Date] which is [Preferred Date] in your case) , [Delivery Date]  to [End}etc. from "Orders" table.

You can invoke this action as an event action when the customers save their record.

https://help.appsheet.com/en/articles/1013286-view-events