Save Time Entering Data into CRM by Mapping Fields between Records

It’s been said that a database is only as good at the data in it. A good way to insure good data is to reduce the amount of data entry by your users and to insure the correct data is entered. A way to accomplish this is through the mapping of fields from parent records to related, child records.

The key to making the mapping work is that the users need to create the new, child record from the parent record. For example, if you have an Opportunity record open, you would then select Quote from the left navigation and then click the ‘Add New Quote’ button from the ribbon when it changes.

To setup the mapping, do the following:

1. Get to ‘Customizations’.  One way to do this is to go to ‘Settings’, ‘Customizations’, and then choose ‘Customize the System’.
   
   
   
   
2. Select arrow to the left of the parent entity to expose the sub-menu items. In our example, that is the Opportunity.
   
   
   
   
   
3. Once there, go to the Opportunity entity and click on the ‘1:N Relationships’.
   
   
   
   
4. Next click on ‘Mappings’ and then the ‘New’ button.
   
   
   
   
   
   
5. Lastly, choose the source and target fields, click ‘OK’ and you’re done.
   
   
   
   
   
   

• An important note here is that the field types must be same on both entities if you want to map fields
• The AttributeMetadata type must match.
• The length of the target field cannot be shorter than the source field.
• The format must match.
• The target field must not be used in another mapping.
• The will work if only you create child record from parent record, through subgrid or an associated view.
• The target field must be a field in which a user can enter data.
• Address ID values cannot be mapped.
• It wont inherit the fields mapping define before(possible with Plugin)