I’m stumped by something. Maybe I’ve screwed something up, but I don’t think I have.
I’m using Excel as the data source.
Collecting data on existing people (using “Edit Form”) and new people (using “Add Form”). The “Edit Form” and the “Add Form” are mostly set up the same, other than the obvious difference.
In both the “Edit Form” and the “Add Form”, the user collects several pieces of data that writes to specific data columns, and then I’ve set it that up so that “On Submit” there is a “Set Column Values” with additional data (mostly the user’s name and the current date) being written to other data columns.
Describe the bug:
In the “Edit Form”, where it is writing to existing data rows, this works just fine, and everything is processed within seconds.
In the “Add Form”, something isn’t working properly.
The user collected data and the “Set Column Values” data both immediately write to the Glide table. No problem there.
And then a few seconds later, the user collected data will sync with the Excel file. Good there.
But the “Set Column Values” data doesn’t show up in the Excel file within seconds, like it should (and like it does with the “Edit Form”).
It will eventually sync to the Excel file, but after a bunch of experiments with test data, I still can’t figure out when or what triggers that to happen.
For example, the user may add NewPerson1, and NewPerson2, and NewPerson3. When they add NewPerson1, the “Set Column Values” data doesn’t show up. Then maybe when they add NewPerson2, the “Set Column Values” data doesn’t show up. Then maybe when they add NewPerson3, the “Set Column Values” data for NewPerson1 and NewPerson2 will show up, but not for NewPerson3.
I can’t figure out the pattern. My best guess (and I’m not confident in this), is that there are two scenarios for it to finally sync.
First scenario requires two things. 1. About two or three minutes to go by, and also 2. Another submission, such as an “Edit Form” or “Add Form” to be submitted.
Second scenario requires ten to twenty minutes to go by, and then the data will update on its own.
Pressing the ‘sync’ data buttons, either in Glide or in the Excel file, does not help.
Is this a bug that needs to be fixed with the Excel syncing, or am I doing something wrong? Thanks.