Conditional Auto-Enter that doesn't update a field during import?
I'm looking for a way to conditionally prevent the auto-enter calculation to occur on a given field during record import. I want the auto-enter calculation to occur during import on all fields except one. So I can't simply uncheck the box during import that causes the auto-enter calculations to be performed. Is there any way to conditionally set the auto-enter calculation.
The situation is that I have a field containing the accountname of the user who last updated a record. (updated_by). During this import I am logged in as the dba user and I don't want all of these records to be marked as last updated by the dba accountname. I want that field to remain as it was when it was exported.
The current auto-enter calculation on this field is simply : Get( AccountName)
Any ideas anyone?
Never mind. I got it. in the auto-enter calculation on the field: IF(Get(AccountName)="admin",tracker.updated_by,Get(AccountName))
So if the accountname is "admin" it uses the current value of the field to update itself otherwise it uses the Get(AccountName) function to update the field