I’ve apparently reached a 100,000 row limit w...

[Robert_Lerner]

I’ve apparently reached a 100,000 row limit which I presume is a Google sheet limitation and not an AppSheet limitation. Is switching my data provider to Excel a viable option under both premium and public plans? Thank you.

[Aleksi_Alkio]

Instead of using spreadsheet as a source, you should start to think using database like MySQL.

[Robert_Lerner]

@Aleksi_Alkio Will do Aleksi - Thanks for a great suggestion.

[Robert_Lerner]

@Aleksi_Alkio Will do Aleksi - Thanks for a great suggestion.

[JPAlpano]

There are some cases where subscribing to a database server will be overkill or not a practical cost.
What if you only have 100,020 rows? You need SQL because of the 20 extra rows?

Hope you can check on my feature request and support by voting if it makes sense to you.

Combining Multiple Tables based on Google Sheet as one list/table (Append)

Use Case :
A table based on a Google Sheet with less than 150,000 rows.

Limitations encountered :
Appsheet can only connect to a Google Sheet with 100,000 rows or less

Available Workaround :
Split the Google Sheet into two worksheets, making sure each worksheet doesn’t have more than 100,000 rows.

• Import the two worksheets as separate tables
• Use each worksheet as data partitions

Problems with the available workarounds
Users will need full access to the list, and switching between tables or partitions by using USERSETTINGS() or table expressions puts some limitations on some use cases where the tables are used as source for adding items to a child table using ref_rows (sub-form).