Best Practice for Tables with a lot of parameters

Adrian_Enz · 03-28-2019 01:45 AM

Hello all,

I’ve been using AppSheet for almost two years. I’m pretty comfortable with it and built around 10 apps.

I do now have a new task, to create an app that requiers to capture a lot of data. In one table I almost have 150 columns to capture data. My problem is, that the AppSheet development platform gets really slow, when I load in tables that have that much column.

What would be a better way to store that much data, or is this the only way?

Thanks a lot in advance.

Greetings
Adrian

gebrema

Hello Adrian,

We also built apps with a lot of data, we use the following practices for storing as little data as possible:

Try to normalize the data as much as possible / makes sense (example)
if you have a lot repeating columns (e.g. [Picture 1] [Picture 2] [Picture 3]) try to make that a separate sheet and link together using Appsheets UniqueID() or some other key. https://help.appsheet.com/data/references/references-between-tables
Check if you all your columns are necessary, if you have a column with data that you can easily figure out using a virtual column or looking it up in a different table, you can remove that column from your sheet.

I hope these tips help,

Greetings
Jan