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

3 Replies

Related Content

Same reference field, different selections within the form

Dropdown list depends on another field selection

Bulk create child records from selection list

Change a record in one table when another table's record updates

Updating predecessors in a pipeline

Recent Discussions

Question about relationships

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.