System Update Broke App

[Joshua_Giles]

Last night there was a system update and now my app that’s been working without change for 2 years is broken:

What do I do?

[MultiTech]

What is the error?

[Joshua_Giles]

@MultiTech_Visions

There seems to be multiple errors that are coming up… but I’m not sure what was changed by the system update?

[MultiTech]

Looks like it’s complaining about your column names.

It says it can’t find certain columns - if you look at the end of each of the errors, the last sentence of each tells you the column it’s having problems with.

[MultiTech]

Additionally, it might be wise to remove the special characters you’ve got inside your column names - this is a no-no in certain circumstances.

Column Names best practices (different languages) Questions

everything Steve said. Also, if your goal is to eventually run your app against a SQL database as opposed to excel or Google sheets, I recommend not using characters like #, ', &, % etc. And even attempt to avoid spaces in your column names. This is not a hard requirement but rather a suggestion. Personally, I am a fan of CamelCase field names like AccountFirstName or BuyerLastKnownAddress. You can then use Appsheet’s “display name” override in the column grid editor.

[Steve]

Please contact support@appsheet.com for help with this.