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


  • 0 Points

Posted 3 years ago

  • 0
  • 1
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,926 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. 
A formula can use the field [Date Modified] Bit would not know what field was modified.