Trigger checked checkbox to uncheck when opening an existing record

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
Hello!,

I am working on a project management application within a Tasks table. There is a List-User field in there named 'Assignees' - users that are assigned to complete the task.

There is a notification set up to send these users an email when a task that has their username in the Assignees field has been added or modified.

Users have requested that they have the choice of whether or not to send the notification. I added a 'Send Notification' checkbox and used that as a filter on my notification. That worked fine. However, I would like for this checkbox to somehow 'uncheck' after the record has been saved or open, so that the next time the Task is updated, the user can click it again if they want to send the notification. 

There is a form rule option to uncheck the box upon Saving, but the notification doesn't trigger if this rule is turned on. Any ideas how to make the checkbox start freshly unchecked upon editing a record? 
Photo of Heather Bryant

Heather Bryant

  • 994 Points 500 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Would it work for you to instead have a button for the user to push to send out a Notification?  
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Another options is to change the notification settings to it triggers when that checkbox changes, and remove the part of having it checked.  Then you can change the name to "Toggle Notification".  So if they check or uncheck it, it will send, but all other times there will be no action.
Photo of Terri Glaze

Terri Glaze

  • 80 Points 75 badge 2x thumb
Try the new QBase Actions to remove the value after saving.