Is it possible to automatically change a field (status from inactive to active) when a record is modified?

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

I have two fields 

1. Task Notes, which is a text field that tracks changes.  

2. Task status field that is a multiple choice of active/inactive.  

If the task notes is modified I would like the Task Status field to automatically change to active.

Is this possible?

Photo of cheryl

cheryl

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
Try a Form Rule

When the record is saved
And the following conditions are true

The field [Task Notes] has changed

Change the value in the field [Task Status] to Active
Photo of cheryl

cheryl

  • 0 Points
Work Perfectly, thanks
Photo of Jonathan Heuer

Jonathan Heuer

  • 350 Points 250 badge 2x thumb
I have been using webhooks instead of form rules for automatic changes like this. The virtues of webhooks is that they will work regardless of how the change is made, including via grid edit or some other form. Highly recommended, and won't break if you change your form down the road.