update a field when selecting another field

Question

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

quickbasecoachd · Answer

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

jimharrison · Answer

Curious to know if you know the reason why this cannot be done using a formula? Or point me at the text.&nbsp;

quickbasecoachd · Answer

A formula can use the field [Date Modified] Bit would not know what field was modified.

Forum Discussion

update a field when selecting another field

Related Content

Nesting API Button Help (Add record and update another)

Moving Fields from One Table to Another

If Then Else formula with a multi select field.

Checkbox Fields Vs Multi-Select Fields for Tracking

Copy Single Table from One App to Another