Reference Fields Restore Editor

Salesforce records often contain references to other records. For example:

• Contact records contain a reference to an Account in their AccountId field.
• Nearly all records contain a reference to the Salesforce user who owns the record in an OwnerId field.

The Reference Fields portion of the Restore Set Editor defines the action which should be taken if a record references another record that is neither:

• Already in Salesforce.
• Restored by another table rule.

This editor contains three columns for each reference field:

1. A checkbox which determines whether or not the reference field should be restored.
   1. If not checked the field will not be modified on an UPDATE and will take the default value on an INSERT.
2. The name of the reference field with a superscript indicating the Salesforce table to which it refers.
3. The action to take if the value of the reference field in CopyStorm points to a record not present in the target Salesforce.

The following screen shot lists the reference fields for the Account table in a default Salesforce instance:

For all reference fields EXCEPT those referencing the Salesforce User table, the following options will be available:

Reference field linking to the Salesforce User table have a different set of options. Common reference fields of this type include “OwnerId”, “CreatedById”, and “LastModifiedById”.

Salesforce User references are treated differently because Salesforce will not permit a record to be created with an owner that is an inactive Salesforce User.