sync two tables using appsheet

[San_Tou]

I have using a MYSQL database, and a Google Calendar as data source for an app in Appsheet

I would like to create a two way sync between the Google Calendar entries and a table in MYSQL

e.g.

when a record is created/amended/deleted in the table, it will add/amend/delete a record of the same details in Google Calendar

when a record is created/amended/deleted in Google Calendar, it will add/amend/delete a record of the same details in the table.

I am trying to use the Bot, but I am struggling with

1. how can I copy the value of a field in the Google Calendar table, to a field in the mysql table?

Your help would be much appreciated.

[jyothis_m · Accepted solution]

You can copy values from one tabel to another using the Data Action - add  row to another table using values from this row. 

then you can run this action by using the BOT whenever any table is updated. 

Action 

 

[jyothis_m · Accepted solution]

You can copy values from one tabel to another using the Data Action - add  row to another table using values from this row. 

then you can run this action by using the BOT whenever any table is updated. 

Action 

 

[Steve · Accepted solution]

To keep the two tables sync'd without any user interaction, you would need to use a scheduled bot. AppSheet is not designed as a tool to keep tables synchronized.