Discussions

Expand all | Collapse all

Log date change for multiple choice field

  • 1.  Log date change for multiple choice field

    Posted 03-17-2018 12:50
    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.


  • 2.  RE: Log date change for multiple choice field

    Posted 03-17-2018 12:56
    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.


  • 3.  RE: Log date change for multiple choice field

    Posted 03-17-2018 18:38
    Simple and easy. Thank you very much, it helped!