One checkbox to tick multiple checkbox

  • 0
  • 1
  • Question
  • Updated 4 days ago
  • Answered
  • (Edited)
Hi all, 

I'm currently working on a checklist and was wondering if i could implement a formula to tick all the checkbox (09) - (16) upon a tick in another checkbox (Master checkbox). This way it'll save time instead of ticking 90+ boxes whereas i can segregate it into sections and tick ~6 checkboxes instead. Any help is appreciated. 

Thanks.



Photo of Samuel Goh

Samuel Goh

  • 262 Points 250 badge 2x thumb

Posted 2 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
Have you tried using form rules?
Photo of Samuel Goh

Samuel Goh

  • 262 Points 250 badge 2x thumb
im not very sure how to use that function. would be nice to have some guidance or assistance. thanks
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,694 Points 20k badge 2x thumb
Here is a demo:



Check All Checkboxes ~ Edit Record 1
https://haversineconsulting.quickbase.com/db/bn7678vbv?a=er&rid=1

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=696

Notes:

(1) No extra fields were used for the two "All" checkboxes. Rather, two text fields were introduced into the form to indicate where the checkboxes should be inserted into the form using script. This approach saves you from clogging up your table with fields that don't carry any information.



(2) I sometimes cheat and don't wrap the module.js code in a closure or put in the detection logic that applied the code to the relevant page. You should do both of these things.

Photo of Samuel Goh

Samuel Goh

  • 262 Points 250 badge 2x thumb
i've managed to solve it after meddling with the dynamic form rules. Thanks guys