Log date change for multiple choice field

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
Hello,

I have a form and within there's Data Status field which is multiple choice field with 2 options: Data Incomplete and Data Accepted.
I would like to save separately the date when each of those 2 options is selected.
I created 2 date fields to log those changes: Date Data Accepted and Date Data Incomplete.

I need to log each date change of those 2 fields. When form is saved with Data Incomplete selected then log Date Modified. When form is saved with Data Accepted then log Date Modified BUT keep Data Incomplete date.

I play with following formula but it's not working as it lets me only save the last selected Data Status: If([Data Status]="Data Incomplete", [Date Modified])

Thank you.
Photo of Aleksandar Salapura

Aleksandar Salapura

  • 482 Points 250 badge 2x thumb

Posted 8 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
You should use two Dynamic form rules.


When the record is saved


When Data Status has changed to Data Complete


Action


Change Date Data Accepted to the current date.

Then copy that Rule but change it to work for the other Status.
(Edited)
Photo of Aleksandar Salapura

Aleksandar Salapura

  • 482 Points 250 badge 2x thumb
Simple and easy. Thank you very much, it helped!