Dynamic Audit Check List
I would like to create a dynamic audit check list. The conditions are as follows. All audit questions are in Yes, No & N/A format All product line audits share the same group of general audit qu...
Forum Discussion
It sounds like you attempted to do this all in one table and use form rules to show and hide questions. That, as you discovered is a losing game and will require a Quick Base Admin type person to make changes.
The low tech solution here is to have a relationship where 1 Audit has many questions. You would set up a series of Standard Template Audits which would hold the correct child records (the audit questions) fort each type of Audit.
They use the native feature accessible in the Application Management area to create a button to import a set of children into your current audit. You will end up making 1 button per different type of audit.
Then on the Audit header record you will have a drop down for Audit Type and then just have form rules to show the correct import button.
here is some help info
https://help.quickbase.com/user-assistance/copy_master_detail.html
The low tech solution here is to have a relationship where 1 Audit has many questions. You would set up a series of Standard Template Audits which would hold the correct child records (the audit questions) fort each type of Audit.
They use the native feature accessible in the Application Management area to create a button to import a set of children into your current audit. You will end up making 1 button per different type of audit.
Then on the Audit header record you will have a drop down for Audit Type and then just have form rules to show the correct import button.
here is some help info
https://help.quickbase.com/user-assistance/copy_master_detail.html