A table based on a Google Sheet with less than 150,000 rows.
Appsheet can only connect to a Google Sheet with 100,000 rows or less
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).
An ability where we can import the two worksheets separately, then an AppSheet feature where we can combine the two tables into one list which can be used as a source for a form.
It can be a new option in splice or whatever, as long as I can use the two tables together.
You can still impose a limitation to the total combined rows, maybe 300K rows (meaning upto three tables with 100K rows each)?
I don’t recommend that this feature will allow combining tables that reaches a million rows, or not even half a million rows. I agree that really huge datasets should be in a database server such as an SQL or a Google BigQuery, but the list is just 150,000 rows and is not expected to grow. Subscribing to a database server just because of the 50,000 rows over the limit will be overkill and is not a practical cost.