Configure Row Type sin GSheet

[MateusStock]

First time here!

When I start a new data table from GSheet, it will read columns and data to set up the table and columns in AppSheet. Is there a way I can already configure the type on the Gsheet as I’m creating the columns?

If I can already make my Google Sheet indicating what type of column it is, saves me time on the reconfiguration of the table.

Thanks,

[LeventK · Accepted solution]

Provided you fill a couple of (4-5 not more) dummy data to your columns and set the column types from Format menu, when you create an app from that sheet, AppSheet predicts and assigns the column types automatically. After that you can change the ones that you see as not fitting. The build-up even automatically creates REF columns between 2 tables if one of the sheet names are matching with a column name in the other one.

[MateusStock]

Can you point me to where I can find that documentation on the REF to other tables? Right now I’m manually setting the columns but if I could do via column names would be even better.

[LeventK]

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

[Steve]

help.appsheet.com

Making an "AppSheet-Friendly" Spreadsheet

How to optimize your spreadsheet design so that it works better with AppSheet