Anyone having trouble with big tables when adding, deleting rows or running multiple actions in fast repetition?
Here’s a few issues I’m running into:
-
Whenever I’m deleting a row using a delete action, about 15% of the time the row will be deleted but will still be displayed in the app. Trying to delete it again does nothing. Only way to stop displaying it is restarting the app.
-
I’m also running actions and it looks like the background data sync speed isn’t perfect. For example I have an app with kits and items in each kits. Every time a create a kit it gets named sequentially kit 1, kit 2, kit 3, etc. The issue is whenever I create another kit too fast, the data hasn’t synced and it gets named the same as the previous kit so sometimes I end up with two kits with the same number. This applies to almost any actions running on big tables. Whenever I’m running a second action too fast after another, I’ll get data sync problems like this.
I’ve played around a bit with wait conditions but it doesn’t seem to help. Any ideas to workaround this?
Have you tried using the Reload Query action in tandem with what you have?
I’ve never used anything else then glide tables and big tables so I didn’t know about this action. It says it reloads queries on SQL databases, will it work on Glide Big tables?
Yes, it does work on Big Tables.
I just tried using this reload query step in one of my actions and I’m still getting data sync issues.
Here you can see I added multiple rows quite fast using add row action. I tried placing the reload query action before, after and both before and after the add row action in the workflow but I’m still getting sync issues. It’s like it’s not syncing fast enough between each added rows and I’m getting the same numbers from time to time.
1 Like
I tried setting up a boolean value to true before the action steps and setting it back to false when steps are done so as to block the users from adding or editing rows while the action is firing. When setting to true it works but when setting back to false I get this action step error: Data has not loaded: Destination row. Have you ever seen this?
It’s just setting to “this row” right? I haven’t seen that before.
@NoCodeAndy Have you ever seen that?