I have one app that keeps having this issue where AppSheet is trying to push 'Value ‘{"Url":"","LinkText":""}’ into a Yes/No column.
I don’t have a URL link anyhere near that column, already regenerated all the schemas, and all the users are updated to the latest app version so the columns should be correct. Even after setting to recovery mode and allowing the sync, this comes back a few days later with no changes to the app data structure.
If your source sheet has unused or deleted rows, remove all of them. Sort the sheet based on a column (i like to use Created DateTime columns), This will place all unused rows to the bottom. Then select and delete all the unused rows. Maybe one of the rows has some left over entry in it? It so, AppSheet will try t load it as a data row.
The Google Sheets ideally should define all columns as Text. If they are not, try setting all the source sheet columns to Text and see if that resolves the problem.
I have a table with 10 columns. Google Sheet columns are set to text. AppSheet columns are set according to the data type [‘Text’, ‘Decimal’, ‘Yes/No’ …] I have a row with data: (e.g. Row 17) [Bob, 2.45, TRUE …] User on appsheet edits column 2 to 4.54 Appsheet sends the data to Google Sheet as an ‘Edit Row’ execution. But then sends it as [Bob, 4.54, {"Url":"","LinkText":""} … ]
This throws and error on the AppSheet system. because it seems like AppSheet is sending the row with the columns all mixed up, and they are trying to push a text ‘{"Url":"","LinkText":""}’’ to a Yes/No column.
But why? I suspect it is some weird bug/error on AppSheet side.
I have a column with a formula for a url link, and it is pushing to Column 3(yes/no column) instead of Column 10(url column)
Update: I hope I solved the problem by re-ordering the columns on my slice table and clicking save, just to force AppSheet to re-read the column orders. I also removed the URL Link formula on Column 10, and used ‘initial value - URL Link’ instead.
You might be right. You are not offering specifics that would help precisely identify the problem.
The exception/error you provided implies that the error is happening when data is being LOADED into the app, not written to the sheet. This is indicated by “cannot be converted to type ‘Yes/No’” which is an AppSheet side column type. So I was suggesting some simple things that might fix bad data being loaded into the app.
This is highly unlikely. It might be that the error is mis-representing the actual column where the problem is occurring.
How do you know these two things? You should be able to see this in the sheet if these were true. I would focus attention on the column with the URL AND any other column that may use that URL column.
Can you show us the table and its column configurations? Can you show us the data in the sheet?
If I know the details, I will see if I can replicate the issue.
Lastly, is there any possibility that the app is referencing an older version of the sheet? For instance did you copy it, duplicate it or move it? You can easily identify this by tapping the option “View Data Source” on your table. This should open the sheet and then confirm it is the sheet you expected.
Hopefully these images help you understand better. I blanked out some of the column data, as it is client data.
From the Analyzer Log: You can see the error coming after ‘Edit Row’ execution, where the app is trying to sync and write the data to the Sheet. It is blocking itself from writing to the sheet, because '{"Url":"","LinkText":""} ’ is not a valid ‘Yes/No’ data. It keeps trying to sync, and I get many of the same error.
2/3. From the Analyzer Log: This is the row data it is trying to push to the sheet. - It is trying to add '{"Url":"","LinkText":""} ’ to the ‘Appointment Sat’ Column. 4. Slice Table Column Order: See the ‘Appointment Sat’ Column. It’s hard to show all the columns, but this is the slice column order that the app is using to push the row data. - Note that slice table column order is different from the actual column order 5. This is my column data types. ‘Appointment Sat’ is a Yes/No column, and the url link column is a few columns below it.
No, highly unlikely. The sheet has never been copied or moved.I regenerated the table schema just incase, had all app users refresh to the latest version.
Multiple users were having this same error, but their local app version was old. I put the app in recovery mode, forced the syncs into ‘recovery data’ and returned it to normal. This solved it for all users except 1 user.
I have many apps running, and this the first time I’ve encountered this issue.
As mentioned above,
I re-ordered the Slice Table Columns and Saved
Removed the URL link Formula, and moved it to ‘Initial Value’ So far the issue has not recurred.
This sounds to me like the good old-fashioned User A is NOT using the latest version of an App that you changed the columns around on and then pushed the update out. That user’s app is still on the old version with a different schema and different bot versions…That’s where I’d start your checks.
