Delta sync timestamp column name

[Ali_Sabir]

Which column does Appsheet use for Delta sync as there is very little information available on this feature?  If I add a column of type timestamp with default value or Now(), will it work or do I need SQL to have a default value CURRENT_TIMESTAMP? If you have multiple columns with date/time, how does it know which one to use? 

And does this feature only work on the AppSheet DB or does it work with Google Cloud SQL?

Thanks

[WillowMobileSys]

---

@Ali_Sabir wrote:

Which column does Appsheet use for Delta sync as there is very little information available on this feature?

---

If you are referring to the update setting named "Delta Sync" under the Performance tab (see image below), there isn't any columns within our data tables that are involved.

As I understand the feature, when the Sync button is tapped, it will load only those rows that have changed since the last Sync.  How the feature tracks those rows is not known to us.  There are data attributes on each row that AppSheet maintains for its internal services.  If the Delta Sync is time-based (e.g. - rows changed since last Sync time), the services would be using its internal timestamp that is immutable by users or App Developers.

I hope this helps!

[Marc_Dillon]

I believe it relies on the Google Sheet last edit timestamps, and it isn't able to do anything with SQL databases.