Multiple Checklists

Question

I am creating an audit application.&nbsp; There are 5 checklist dependent on what you are auditing to (welding, safety, coating, etc.).&nbsp; &nbsp;Also, there are categories for checklist.&nbsp; For example welding there is application, documentation, training categories.&nbsp; I have created a checklist template which list all of the questions and the correlating checklist (type field).&nbsp; Then I made a checklist table.&nbsp; I want the user to select which checklist they will be using and then to be able to fill it out with the categories.&nbsp;&nbsp;I'm not sure how complicated this will get and wondering if it would be better to just have five separate tables for each checklist.&nbsp;&nbsp;Another side note.&nbsp; If any of the questions are answered as "Low", "Medium", or "High", it will need to trigger a corrective action to be completed.&nbsp; This piece has already been completed but it will need to trigger Table CAR Manager.------------------------------Sarah Burres------------------------------

markshnier__you · Answer

The Low tech solution here is to make 5 Template Audit records. each would have their correct child checklists.
Then use the built in wizard on the Settings for the app, then App management page and locate

Copy master & detail records.

That will allow you to create button buttons which will import respectively the 5 children records from those 5 templates onto your new audit record.

So one approach is to offer the user those 5 buttons to choose from and then once the click to add the children, then have a form rule hide the buttons. You could also have the user select from a drop down of the Audit type and then have form rules to show the correct button.

You will need to set Permissions so that the regular users can't mess with your template Audit records or their children checklists.

There are also fancier solutions probably beyond the scope of what I can guide you though on this forum to have the Audit records created with children based on their type, but my suggest here could be quite good enough for your needs. Post back if you get stuck or have questions.

https://help.quickbase.com/user-assistance/create_copy_import_button.html

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

donlarson · Answer

Sarah,Here is one potential architecture.

When a Record is Added to the Audit Table you want to create records in the Check List Table and related them to the Master List whereRelated Audit Type from the Audit =&nbsp; Related Audit Type in the Master List&nbsp; &nbsp;ANDRelated List Status = ActiveThis way you will get all your questions from the Master List in your Check List for the Audit .&nbsp; &nbsp;New questions in the Master List or changing the List Status will automatically make the future Check Lists compliant.Now you just need a tool that will search the Master List for the data you need and write it all.&nbsp;&nbsp;I recommend that you look at Triggers from Juiced Technologieshttps://www.juicedtech.com/triggersI have all my clients use them and find it to be indispensable.------------------------------Don LarsonPaasporterWestlake OH------------------------------

Forum Discussion

Multiple Checklists

Related Content

Questions & Checklist setup

Trying to Create a Attendance Checklist

Using Grid Edit to Edit Multiple Records at Once

Building Checklists

Edit Multiple Records at Once with Grid Edit