Why not both?
Appsheet has been a learning experience for me. Many things that may seem obvious to a long time user is not obvious for a newcomer.
Also saying something controversial might make the expert call out loud and clear, on counterpoints.
1. Separate apps:
First time I made the app I made a huge one. There was no disclaimer in all the thousands of pages i read that said anything about it.
2. Separation of data:
Refs were kind of known to me the first time around, but I didn’t know enough about it, or the reliability of Appsheet to dare split up the sheets.
3. Large historical datasets:
Great point. And something to consider.
How I use refs as a “security filter” and to save loading time
We have all our contracts divided into “task points” which is shared in a large sheet.
A lot of the columns are not needed for the workers doing the tasks, but they are needed for the administration. If I can send 10 columns instead of 40 to the common user, then refs are a great solution.
I wanted to have a contacts app between all employees that also showed their status.
I also want one place where the administration updates all information about the employees.
This was not possible for me in Premium without refs, because of GDPR.
We have 3 different departments, that needs different information. These can have their own refs added that noone else needs to see.