I'm trying to setup a new Custom Object for our internal proposal process and I wish to have timestamps on the records that show when a record was submitted for approval, and when it was approved by the approver.
I have added a field update in the initial submission action in the Approval Process, on a datetime field I named "Submitted Date/Time". The formula right now is simply "NOW ()", and whenever a user submits the record for approval, the field is populated with date and time of submission. So far, all good.
However, if the approver rejects the record because something needs updating, and the user resubmits the same record for approval, the field Submitted Date/Time is updated to the date and time of resubmission, instead of keeping the date and time of the original submission.
Does anyone know how to build a formula that says that the field should be populated with NOW() only if there is no value in the field already?
Thank you so much!
답변 2개
Hi Emelie, Please change the field update formula to the below
IF(ISBLANK( Date_Time_Field__c), NOW(), Date_Time_Field__c )
Replace the Date Time field with the actual API name of the field.
