Apps, Performance, and Best Practice
I prefer to have a very limited number of apps, as management can be come quite labor intensive, and I tend to find cross app relationships with some limitations or inconveniences versus staying with...
Forum Discussion
Austin - when speaking about app size for sandbox, does that include file attachments? If so, I'm dead in the water because we track assets (equipment) and have roughly 20,000 assets, each with about 5 pictures.....or 85 gigs worth of attachments. Without attachments, my apps are tiny.
Blake - when you mention workflows, what exactly are you referring to? Automations etc?
Mark - thanks for the tips. My largest table only ha maybe 20,000 records. I can see some tables growing but it will be many years I imagine until I even reach 100k in one table.
I have a couple massive (I think? I have no frame of reference) tables of 500+ fields. So far so good, except my main table I ran out of Dynamic Form rules, so i will have to take some time to clean that up and rethink some of the fundamental design to alleviate that issue.
I like to keep my user roles small, also for ease of management, but still need 6-8 roles. Which multiplied over three apps already starts to wear on the management.
Sounds like this can really have a list of pro's and cons each way.
------------------------------
Mike Tamoush
------------------------------
Blake - when you mention workflows, what exactly are you referring to? Automations etc?
Mark - thanks for the tips. My largest table only ha maybe 20,000 records. I can see some tables growing but it will be many years I imagine until I even reach 100k in one table.
I have a couple massive (I think? I have no frame of reference) tables of 500+ fields. So far so good, except my main table I ran out of Dynamic Form rules, so i will have to take some time to clean that up and rethink some of the fundamental design to alleviate that issue.
I like to keep my user roles small, also for ease of management, but still need 6-8 roles. Which multiplied over three apps already starts to wear on the management.
Sounds like this can really have a list of pro's and cons each way.
------------------------------
Mike Tamoush
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendMike, on the roles issues, note that you can have users in multiple roles. That can help so you don't need to feel that you need extra roles for users who cross some boundaries.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I had no idea you could assign to multiple roles! Do you simply just add a second instance of the user in the app?
------------------------------
Mike Tamoush
------------------------------- MarkShnier__YouYes, a user can be in multiple rules and you just add them to the app multiple times. Of course a user just counts as a user so you don't pay twice for the user.Now if the user is in multiple Roles they will get the most permissions possible based on all the Roles they were in.However, If they are in multiple roles they cannot get the most dashboards possible :) They still can only land on one dashboard and see one set of tables (in case you hide some tables by Role UI).
When you look at the list of Roles you can drag and drop them up and down. The Roles which are highest up in the list will take priority as to which dashboard a user will land in. ie they will land on the dashboard based on the highest Role they are in based on that drag n drop.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------