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

  • 140 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
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

  • 140 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.
I'm still not getting it.  Are these many people all adding separate records or all editing the same record.
Photo of Brian

Brian

  • 140 Points 100 badge 2x thumb
Yes many people adding separate records.
Are these records all Children of a common Parent record?
Photo of Brian

Brian

  • 140 Points 100 badge 2x thumb
No each is its own record in the main database.
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

  • 140 Points 100 badge 2x thumb
Yes no relationship with any other tables.
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.