How can I count how many times a checkbox field has been checked?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a form with multiple checkboxes fields.  I would like to know when a particluar field gets checked 20 times.  When a particular field gets checked 20 times I would like to set up a notification email to alert me.  How would I do this?


Thanks

Photo of Brian

Brian

  • 120 Points 100 badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
I'm not understanding - how can 1 field get "checked" 20 times. Is someone else unchecking them?  Or are you asking how to count how many of the multiple checkbox fields are checked?
Photo of Brian

Brian

  • 120 Points 100 badge 2x thumb
So I send the form link out to many people.  They can then check the box they want.  So a field could get checked 20 times by 20 different users, but once per submission.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
I'm still not getting it.  Are these many people all adding separate records or all editing the same record.
Photo of Brian

Brian

  • 120 Points 100 badge 2x thumb
Yes many people adding separate records.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Are these records all Children of a common Parent record?
Photo of Brian

Brian

  • 120 Points 100 badge 2x thumb
No each is its own record in the main database.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
I understand that they are all separate records. But are you saying that there is not a relationship between this table and any other tables?
Photo of Brian

Brian

  • 120 Points 100 badge 2x thumb
Yes no relationship with any other tables.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
You can make a new table with just 1 record in it. call it perhaps "Total Checkboxes"  No fields, but create one record.  That record will be [Record ID#] of 1.

Then make a formula numeric field on your Details table with a formula of 1.

Then make a relationship where 1 Total Checkboxes has many Detail record and use that formula field as the right hand side of the relationship.

Then make a summary field on the left side of the relationship to count the # of record where a certain checkbox is checked.

Look that up down to the details table.



lastly make an email Notification that when the record is added or edited and the # of checkboxed records = 20, fire the Notification.