How to make Appsheet auto regenerate schema or add this setting in the App?

[rybnz]

So, I've made an Appsheet from a googlesheet to capture our vehicle fleet expenses by using the app.

On the googlesheet, I've setup a sheet containing Expense Category, eg, Fuel, Consumable, Insurance, etc.

In the app, I've made a section called Expense Record, which allows user to add new expenses and choose the expense category from existing category setup in googlesheet.

I've also setup another section in the app for users to add or edit the Expense Categories, so they can add new categories as we go.

The problem is now, when we add a new item into the Expense category, eg, Service Fee.

This new expense category can be selected on Googlesheet, but it doesn't show in the app.

Unless, I manually click on regenerate schema in the app design interface, then it will appear in the app.

Now, is there a way to automate this procedure and to avoid doing this regenerate schema manually? As this is the single issue that's hindering our app getting utilised by our team.

Thank you for anyone who can share some lights

[dbaum · Accepted solution]

Confirm the column in the Expense Record table in AppSheet is a Ref type column to establish systematic References between tables - AppSheet Help. 

If that doesn't solve the issue, I suggest post screenshots of each AppSheet table's columns and your spreadsheet columns.

[rybnz]

Thank you for replying, I setup in text, I guess that would be why, I will rewrite my structures and have another try.

[rybnz]

Yes, it's working beau~~~tifully, thank you