My app’s URL: https://busy-pencil-6754.glideapp.io/
Support Link: Glide
I have two bugs that I’m running into where I get different results between the editor and the published version. It’s hard to explain, so if something isn’t clear, I can try to create a video when I have time.
So in my app, I have a sheet that keeps a rolling history. Basically it’s 20 rows with a date, and based on the date and a couple of other criteria, I determine a Key value for the next row that should be populated. In my app, I have a couple of inline lists that act as buttons. In certain cases (such as a user clicking on the Equals button or any of the Math Operation buttons), it’s supposed to update the next available History row. I have a single relation linking to the Key value in the History sheet. As far as writing the history rows through a Set Column action, through a single relation, everything is working as expected. Rows get updated. But I’m running into a couple of odd situations.
- First is something I’m observing in the Glide editor. I have a handful of columns that are brought from one sheet into another via Single Value columns. When a certain button is pressed, those single value column values are supposed to be passed through a single relation into the History sheet. There are a couple of scenarios where those single value columns may be empty on the original sheet so they don’t contain a value (I assume null). I have reason to believe that empty single column values do not pass any values, or overwrite any values, when used in a Set column action. What appears to be happening is that it updates the correct row, but if the column that I’m using to set a column value is empty, then it doesn’t overwrite whatever was in that column before. I could probably perform another action that first clears the value, but I would expect that if I had set the action to fill a column with a value, it should overwrite it. Even if the source value is empty (null).
This is what was entered
This is the overwritten row in the History. Circled values should have been overwritten with the blank (null) value.
This is the action that updated the row. Circled values were empty, but didn’t overwrite old values in the sheet.
I haven’t been able to observe this same behavior in the published app yet. Seems to only be in the editor at the moment.
- The second issue I have is really weird and only happens in the published app. In particular, this seems to be happening when I do math with exponents. The math is fine, but it’s the way it’s saving to that history sheet. So to quickly summarize, I have math stored in several different temporary columns. It’s something like this: LeftValue MathOperation RightVaue LeftExponent RightExponent. Each part of an equation is stored in separate columns. These separate columns are then written to separate column in the History sheet. An exponent is stored in separate columns based on the left and right parts of an exponent. What I seem to be observing is that the two exponent values that are written to the sheet, are always from the previous calculation.
Here you’ll see a simple exponent calculation:
When I press the equal button, it writes to a history row. The screen shot doesn’t show it, but when I pressed the equal button, it displayed a notification of the value in the Right Exponent column, which was a ‘2’. So far so good.
Then I do a second exponent calculation.
When I press the equal button, the notification indicates that there is a 4 in the right part of the exponent, but that same value has now written a 2 from the previous calculation into the history row. The red marks indicate the values of the left and right part of an exponent that are stored in the history. It shows the correct formula and everything else appears correct, but for some reason, those two exponent column values are always behind one calculation.
This issue does not happen in the glide editor. This only seems to be happening in the published app. Both observed within chrome on windows and android.