How to update internal table values

NoriAbe · 01-09-2022 05:25 AM

Currently my application works triggered by time-based scheduling. My application does not use tablet or mobile application. So those application never trigger table value synchronization for my system.

Unfortunately sometimes table value is NOT correctly updated before the time-based triggering. As a result of that unexpected change happens in my Google spreadsheet. What I want to know is sync-ing method. I’m wondering I can apply sync-ing all tables once a certain event happens. Could you teach me how to sync all tables.

Marc_Dillon

Can you elaborate here, I’m not sure what you’re saying. What exactly are you trying to do, and what is the issue that you’re facing?

NoriAbe

I realized my performance analyzer tells like this.

Improves section says “Sync delay”. What’s this?

Marc_Dillon

…is the time it takes to sync your app.

NoriAbe

I says “delay”. So delay seems not to be a good thing. It seems I can improve the flow if I sove the “Sync delay”. What’s this?

NoriAbe

If I use Automation Monitor function I can see the variables at each step. Here is the steps.

Note : Please enlarge the image.

At the first step, labeled as “1”, Trigger date is wrong. This causes problems. Correct dates are indicated as red. These dates are in the Google Spreadsheet, but are not correctly imported to AppSheet. So I want to import and update these values before starting these steps.