Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Adding new records using Appsheet API and _ComputedKey

 

Hello everyone!

information:

  1. I have two data sources:
    MySQL database connected to the appsheet application
  2. Google Sheet updated once a day with script (not connected with appsheet in any way)

case:

Google Sheet is an externally powered source for MySQL updates. I check if computedkey repeats itself in Google Sheet and MySQL database. If so, it updates the information in the MySQL database using Google Apps Script and Appsheet API. If there is a computedkey that exists in Google Sheet but not in MySQL then I want to add this record.

question:

Is this possible?

0 1 82
1 REPLY 1

Sounds possible to me.

Top Labels in this Space