I want to track the dates that have been entered into a specific field and log the date/time (and user) that the date was changed. How can i log edits to a formula text field without creating another text field in addition to the formula date field?
Primary field is: [Install Date]. This date changes periodically and we need to track it's lifecycle.
? User #1 changes [Install Date] from blank to May 9, 2016 - this change is made on May 2nd.
? User #1 changes [Install Date] from May 9, 2016 to May 10, 2016 - this change is made on May 8th.
? User #2 changes [Install Date] from May 10, 2016 to May 21, 2016 - this change is made on May 10th.
? User #1 comes back in and changes [Install Date] from May 21, 2016 to May 18, 2016 - this change is made on May 12th.
I'd like a text field that shows:
5/2/16 User #1 - New Install Date of 5/9/16.
5/8/16 User #1 - Install Date changed from 5/9/16 to 5/10/16
5/10/16 User #2 - Install Date changed from 5/10/16 to 5/21/16
5/12/16 User #1 - Install Date changed from 5/21/16 to 5/12/16
i know i can create a formula date field that "=[Install Date]" then create a form rule that changes the value in [AnotherNewField] to the value in the "=[Install Date]" formula date field and logs edits to the date field... But we need to duplicate this for a significant number of fields and would rather not create two new fields for each date field we have on the form.