Change user in field who modified another field
I have a field called "Anticipated Purchase Date", which is a date field. When the date is entered, it will automatically update the field "Anticipated Purchase Date Entered by" (which is a user field and read only). I created a rule for this to happen. See pic.
the issue is that if someone decides to select a new date for "anticipated Purchase date" after the initial entry of a date, then the field "Anticipated purchase date entered by" will not update. It will be keep the initial user in there. How do i make it that when the "anticipated purchase date" is modified by a new user, the "purchase entered by" field changes to that user? Based on what i did, it will only change if i delete out the "Purchase date" and enter the date again, then the "Anticipated Purchase Date entered by" will change to the new user (because that is how the rule is set up). Thank you.
the issue is that if someone decides to select a new date for "anticipated Purchase date" after the initial entry of a date, then the field "Anticipated purchase date entered by" will not update. It will be keep the initial user in there. How do i make it that when the "anticipated purchase date" is modified by a new user, the "purchase entered by" field changes to that user? Based on what i did, it will only change if i delete out the "Purchase date" and enter the date again, then the "Anticipated Purchase Date entered by" will change to the new user (because that is how the rule is set up). Thank you.
