It is a challenge when it comes to that, but with proper documenations in every view / slice / action / help keep things on track , but indeed it happens that you wonder what have you done here and there and why its this way and what does this do for example…
Yes, I recall now too that others have posted comments on that point and even screenshots of an AppSheet error referencing a 100K row maximum. The most recent of those screenshots that I find is from 3/2021 and the most recent comment from 3/2022. I did some rudimentary testing in 8/2022 and didn’t encounter any error except when newly adding a table with >100K rows to an app.
@lizlynch , if AppSheet either does or does not enforce a row count limit when adding a table to an app or when adding a row from an app to an existing table, it would be helpful to explicitly document that in Limits on data size - AppSheet Help.