Data table doesn't match any more the columns in Gsheet

[Mathieudkt]

Hello,

Since today, I have a problem on one data table in appsheet.

It seems that columns (and all attributes: formula, naming, initial value...) have changed. In my case on column has changed naming and more than 20 are missing (compare to my Gsheet).

I already tried to:

- restore and old and conform version: doesn't work

- regenerate schema from Gsheet: doesn't work

- Modify the column changed (naming and attibutes) : does work but for only this one and impossible to take back the others. And If I tried one the 2 previous actions it goes back to the changed column.

Please help me to find a solution, it completely blocks my production activity

For information: everything was working well this morning and yesterday. And no modification has been made on the app.

Thanks

[Gustavo_Eduardo]

When you change column names in your database and regenerate the structure, AppSheet deletes the configuration you set in the editor.
Tip: Go to your app's versions and find the version right before you changed the column name. Verify the structure in the editor of that version and then transfer it to the database so that it's exactly as it was before (there's also a version history for Google Sheets); you could consult that as well.
Once the database is corrected, restore the version prior to the error.
Afterwards, when you want to correct names, the ideal way is to change them on both sides, and on both sides – both in the database and in the editor – they should be the same.
I hope this helps you.