Forum Discussion
MichaelTamoush
Qrew Captain
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
------------------------------
BlakeHarrison
4 years agoQrew Captain
Mike -
By workflows, I'm referring more to individual business processes / departments. As an example, I have a client that buys mineral rights. They originally had a single application that managed all functions within the company. After working like this for a year or two they found that the single app approach wasn't scalable and adding new functions often caused problems in unpredictable ways. That app still exists in a legacy capacity, but we have moved many functions into individual applications dedicated to: Sales, Personnel, Commissions, Corporate Planning, etc. They even have a completely separate application they use for planning and managing their Quick Base development. Many of their applications have some commonality, such as Employees and Customers and this information is pulled in via Sync tables.
On another note, your comment about running out of Form Rules on one of your forms tells me that you probably should consider breaking up that main form into multiple forms. Each user Role can have a different form for View, Edit, and Add and I would encourage you to take advantage of this feature. This will allow you to have fewer Form Rules on each form and ensure that they always work properly. Splitting these up, while it sounds like you'll just have more forms to manage, can actually make it easier and give you the opportunity to provide a better user experience tailored to a specific role.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
By workflows, I'm referring more to individual business processes / departments. As an example, I have a client that buys mineral rights. They originally had a single application that managed all functions within the company. After working like this for a year or two they found that the single app approach wasn't scalable and adding new functions often caused problems in unpredictable ways. That app still exists in a legacy capacity, but we have moved many functions into individual applications dedicated to: Sales, Personnel, Commissions, Corporate Planning, etc. They even have a completely separate application they use for planning and managing their Quick Base development. Many of their applications have some commonality, such as Employees and Customers and this information is pulled in via Sync tables.
On another note, your comment about running out of Form Rules on one of your forms tells me that you probably should consider breaking up that main form into multiple forms. Each user Role can have a different form for View, Edit, and Add and I would encourage you to take advantage of this feature. This will allow you to have fewer Form Rules on each form and ensure that they always work properly. Splitting these up, while it sounds like you'll just have more forms to manage, can actually make it easier and give you the opportunity to provide a better user experience tailored to a specific role.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------