Hi Appsheet Community,
I have an app on a mySQL database with about 25,000 rows. In order to make the app quicker, and to remove data that I don’t really need, I used the User Settings to create a date range, then set the security filter to only show rows that the date range was set to. Recently I haven’t been able to widen the date range without getting this error.
Unable to fetch app definition.
Error:Request cancelled: took too long to process: Computing a formula/n
Two questions…
Is there a better way to filter the data?
How do I figure out what formula is giving the issues when the date range is wider than say 5 months?
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |