Question for the community: any recommendatio...

[Robert_Lerner]

Question for the community: any recommendations for a low-cost mysql host? Thanks.

[Simon_Robinson]

Any reason why it has to be MySQL?

[Robert_Lerner]

@Simon_Robinson Thanks Simon. My initial problem was a need for way more than 100,000 rows, and that was suggested as a possibility. But the fatal problem that has now emerged is the non-support of databases under new pricing for publisher pro.

[Simon_Robinson]

Depending on the number of columns, Google sheets will let you have 2M cells.

But you can also join sheets together in Appsheet.

[Robert_Lerner]

@Simon_Robinson Simon, that’s extremely interesting. The file now has about 3M cells, but I will play around and see if it can be reduced. Thanks a million.

[Robert_Lerner]

@Robert_Lerner Simon, it turns out that the problem is a hard 100,000 row limit with AppSheet - Google Sheet has no problem. Unfortunately, this otherwise really nice platform appears to no longer be usable for public-facing apps having fairly large files. A lot of wasted time on my part. Thanks again for trying to help.

[JPAlpano]

I have a similar issue, though my GoogleSheet is not as huge as 1M rows.

I submitted a feature request and hopefully it gets some traction.

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).