update a field when selecting another field

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
in my table "clients" I have a field (DME, Field ID 174) that is a dropdown box.


When any change is made in that field I want to automatically update a date field (Sent Date, Field ID 202) to the current date and time.

I can't figure out how to do that
Photo of Al

Al

  • 0 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
If updates are exclusively being done on a form and not in Grid edit, then you can use a form Rule.



When the record is saved

and [DME] has changed

Change [Sent Date] to the current date
Photo of Jim Harrison

Jim Harrison

  • 1,856 Points 1k badge 2x thumb
Curious to know if you know the reason why this cannot be done using a formula? Or point me at the text. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
A formula can use the field [Date Modified] Bit would not know what field was modified.