Is there any known method of updating a column type for an app that has had sync errors?
The (irresponsible) user of the app has made 65 new entries and updates to existing rows after the sync was not successful.
I have tried:
- Changing the ENUM column to be a text column
- Adding the “expected value” as an ENUM
- Clicking the required boxes for allow other values (etc.)
- Syncing repeatedly to see if that it can register the column value change
Obviously, without being able to Sync, it can’t get the new column type and thus can’t clear the Enum error (even after converted to text)
At this stage, it is looking like the data will need to be re-entered or updated, which will require me going through the Sync list on the iPad and hoping that I can get most of this completed.
I know that this is probably a futile exercise, however I thought I would see if anybody had any tips or solutions.
EDIT: I do have the “Change log” ready in the format that AppSheet displays (I assume it’s like a semi-JSON output?)