Hi! I’m new here and working on my first app. I came here by way of google sheets. The app design and hook-ups to data fields, etc. all went well. However, the app never seems to actually update the data. When I edit data in the app and sync, it tells me it’s “saving changes”, but then when the page refreshes, the data has reverted back to the prior values and my changes never happen. The data table is not set to “read only”; it has update, add, and delete enabled on it.
UPDATE It seems I can add data, but I cannot edit or delete data.
The app’s audit log seems to think the update is happening successfully, but the data never changes. Any ideas?
wrightmf:
The app’s audit log seems to think the update is happening successfully, but the data never changes. Any ideas?
Can you tell us a little more about the app, what steps you are following to Edit and if you have any Automation processes implemented?
1 Like
I’ve tried editing a few different ways. I’ve tried a system-produced edit form to edit column values for a given row. I’ve tried “quick edit” fields on a card view. In both cases, I select the field, modify a value, and click the sync button that has a red dot on it. It tells me it’s “saving changes” and “syncing the app” but then it brings me right back to the same data from before the change. I’ve also tried deleting an entire row from the app. None of those actions have any effect at all on the source data in google sheets. I can’t tell anything useful from the audit log. The audit log shows the change succeeding and when I click on the details of the change, it shows the new value I entered when I made the change. But then no change is ever made to the source data and no error is ever provided.
I CAN add an entirely new row of data from the app and the new data is pushed to google sheets, so I know things aren’t completely broken. However, any attempt to modify or remove existing data fails without error.
I have no automation processes enabled.
Also, I read this answer and none of these conditions are true for my app. I do press Sync after editing. No errors are reported. Audit history shows success. There are no empty rows in my sheet (I mean, other than at the end of the data set). I’m not using RowNumber as the key. I have no filters set on the sheet. And the revision history in Google Sheets only shows the addition of the new row (the only change I can actually get to trigger) but no modifications or deletions.
And what about the formatting rules? Conditional formatting?
Are they cleared?
I didn’t have any conditional formatting, but I solved the problem. I’m not exactly sure which action I took solved the problem, but here’s what I did.
-
To simplify the table format (since complex table formats seem to cause issues), I cleaned up the headings. I had two heading rows (think heading and subheading) with the top row including some merged columns to create some column categories. I suspect this was the issue. I removed the category heading row that included merged columns, and pared it down to just a single heading row.
-
I added another unique identifier column and set it as key, just in case appsheet was getting thrown by the key column I was using (it was a URL).
-
I allowed appsheet to restructure the table from the source.
-
Profit.
3 Likes
