How to update column type without losing Un-Synced Data

Hi everybody,

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?)

Solved Solved
0 5 490
1 ACCEPTED SOLUTION

Put the App in recovery more (Manage โ†’ Deploy). But be aware there is a risk you could loose some data. Weโ€™ve had this before loose signatures and pictures. So might be worth getting them to do screen shots of anything really important.

Simply put it in recovery mode, save, get them to sync, then turn recovery mode off and see what you have

View solution in original post

5 REPLIES 5

Put the App in recovery more (Manage โ†’ Deploy). But be aware there is a risk you could loose some data. Weโ€™ve had this before loose signatures and pictures. So might be worth getting them to do screen shots of anything really important.

Simply put it in recovery mode, save, get them to sync, then turn recovery mode off and see what you have

@1minManager , Iโ€™m curious to hear more about your experiences with using the โ€œrecovery modeโ€. When exactly do you turn it on, what results do you get from turning it on? Iโ€™ve experimented with it a few times, but it just never seemed to do anything.

So we had an issue yesterday like the above. User hadnโ€™t synced since we added a few new columns. The data came in but strangely the 3 signature images where missing. We know the user created them as each of them is timestamped and GPSstamped. So recovery mode is not perfect but its better than having to click โ€œreset changesโ€ and delete all the sync updates

Interesting, thanks.

Hey @1minManager

I canโ€™t believe that I overlooked this so easily. I actually went down the path of exporting and converting to JSON and then had a brain snap moment of โ€œjust enable recovery mode!โ€

I thought I removed this thread, but Iโ€™ve just checked back and seen that there are responses.

It was a lot easier than the original path I started on.

Top Labels in this Space