This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Does anyone know how to add tables with more than 100,000 records in Appsheet?
The file is a standalone Google Sheet with only 1 sheet, it has 156,000 records. I have already deleted empty cells, rows and columns but Appsheet keeps showing errors saying that it cannot add tables with more than 100,000 records.
First, Proper data design is key to getting off to a good start for an app with that much data. You should analyze the data to see if it should be split among several tables. For example, maybe only certain columns are filled for certain types of entry. This would indicate that the row list could be split - Type 1 entries into Table 1, Type 2 into Table 2, etc
If you can show an example of your data, maybe we can help with suggesting a data structure to spread out the rows. Without doing this you will likely face a very sluggish app and simply get frustrated.
If you feel that all the rows belong in a single table then try this...
1) Create the sheet with the desired columns. 2) Add that blank sheet as a table to the app BEFORE populating it. 3) Populate the sheet directly with the 156,000 rows. 4) Sync the app to see if that is handled - it may still be too much data.
If you still get errors due to the volume of data, at the very least you can add a Security Filter to reduce the number of rows that are loaded into the app at once. If you have a date column then I would start by limiting the rows to only the most recent months. This will at least get you started.
First, Proper data design is key to getting off to a good start for an app with that much data. You should analyze the data to see if it should be split among several tables. For example, maybe only certain columns are filled for certain types of entry. This would indicate that the row list could be split - Type 1 entries into Table 1, Type 2 into Table 2, etc
If you can show an example of your data, maybe we can help with suggesting a data structure to spread out the rows. Without doing this you will likely face a very sluggish app and simply get frustrated.
If you feel that all the rows belong in a single table then try this...
1) Create the sheet with the desired columns. 2) Add that blank sheet as a table to the app BEFORE populating it. 3) Populate the sheet directly with the 156,000 rows. 4) Sync the app to see if that is handled - it may still be too much data.
If you still get errors due to the volume of data, at the very least you can add a Security Filter to reduce the number of rows that are loaded into the app at once. If you have a date column then I would start by limiting the rows to only the most recent months. This will at least get you started.
Excellent solution!! I created a new clean table with the field names, added it to Appsheet and then pasted the records and it no longer showed an error. Thank you very much for your support @WillowMobileSys
LinkedIn
Twitter
