I have a calculated expression that add the current date/time to a field when a record is captured in Field Maps. However, if I update any existing record via Field Maps the calculated expression runs again, which means the original date/time the record was captured is lost.
I expected that the calculated expression would only run when creating new records, not when updating existing records.
Does anyone know if there is a workaround to this?
Solved! Go to Solution.
Thanks @RodellZorilla, I found another similar post after asking the question:
The solution in the above post uses the IsEmpty function in conjunction with $editcontext.editType to check if the record is being updated or inserted.
Thanks @RodellZorilla, I found another similar post after asking the question:
The solution in the above post uses the IsEmpty function in conjunction with $editcontext.editType to check if the record is being updated or inserted.