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
Question
update a field when selecting another field
This topic has been closed for replies.
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
When the record is saved
and [DME] has changed
Change [Sent Date] to the current date
+18Curious to know if you know the reason why this cannot be done using a formula? Or point me at the text.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.