This is a weird issue ive found.
Basically I have a fairly complex app running as a CRM with many virtual columns and quite a few tables. This has of course made the app slow and bulk actions are almost so slow, it’s not worth doing.
After a little googling I found a community thread about a similar issue and one solution was to build a separate app just for making bulk changes as it’ll sync faster.
I made the second app referencing the same table and set it up to appear similar. All was good until I noticed around 1000 rows are missing. Syncing up the apps seems to make no difference, it seems the new app is always around 1000 rows behind. Any ideas?
What is the ‘same table’? Is it a folder as a datasource, Appsheet DB, GSheets/Excel, SQL DB?
Sorry for not being clear. They are both pointing to the same google sheet.
Using the EXACT same Google Sheet as the datasource…Check!
There is difference between “missing” rows and rows that are “behind”. Which is it? Are you saying the rows are slow to update into the second app? If so, how slow? E.g. if you wait long enough, without any new activity, will ALL the rows be present in BOTH apps?
Please elaborate on your “bulk entry” process. How many rows are inserted and how are you doing it? With actions? With automation? With API calls?
Without knowing more about your apps, the problem could alo be with Security Filters. Do you have Security Filters in place?
Hey, Sorry again, Clarity is obviously not my strong suit here. I’ll answer your questions as you’ve asked them
Missing or behind… Seems the answer is missing. regardless of time the apps never have the same number of records.
Slow to update? No, the update across both apps seems to be fast enough for the changes I can make. Not slow to update, simply the lack of 1000+ records. This is more an issue of the first app having a lot of virtual columns so its syncing time is too long for a bulk action. the second app has zero virtual columns and is simply there to mass change aspects of the records such as status. My meaning behind “Bulk Entry” is bulk actions. Having an action set up and selecting rows to perform that action on. My app is large with thousands of data relationships at this point, it has well outgrown where it is, explaining everything wouldn’t ever really be possible, but this issue seems more to do with how the table is being read by appsheet, less about the setup of what I’m doing. Security filters are not used…
I am kind of wondering what verification process you are using to determine the missing rows? Do you have both apps open and the GSheet and scroll to the bottom to look at the last entry? Do you have a counter in the apps and compare to total rows in GSheet? Keep in mind that when you delete rows Appsheet deletes the contents of a row so there is a blank row in GSheets. On a side note, formulas in GSheets can affect sync times in Appsheet, not that this necessarily applies in your case, but noteworthy. Have you considered that the amount of data you are dealing with has outgrown GSheets as a database and is there a possibility that you are hitting some limits implied on GSheets? I don’t know for a fact, but it could even have to do with consecutive API calls to GSheets. I know this doesn’t address your question, but maybe it eventually helps with a solution.