Creating and Editing Field Values in the Entity

The purpose of this article is to provide information on creating and editing fields and custom field values in the Entity. 

Create and Edit Field/Custom Fields in the Entity

1. Choose the Entity for which the field value has to be created.
2. In the screen that appears, select the + icon on the right side to create a new field. 

3. For map processing, you can either select the Billing address or shipping address from the tab Address Mapping. The default is the shipping address. All the fields related to the shipping address (Shipping country, shipping state, shipping city, etc.,) will be included in the mandatory fields. Select whichever is applicable to you, and click confirm then save. 

4. In the screen that pops up, start filling up the following for Source information:
   1. Type : From the drop-down select the connection type as Salesforce
   2. Name: From the drop-down select the connection name - The name of the database that the tenant is connected to will be listed.
   3. Table: Select the appropriate table name from which data needs to be retrieved. (For Accounts - table name is Accounts, For people table name is people and so on)
   4. Column: Select the Column name that needs to be added from the drop-down menu.If you want to add a custom field, the field name has to be entered manually. The custom object column name will end with object name__c. If you are adding a field from another object then it should be formatted like ObjectName__r.Field API name. If it's a custom object then it would be ObjectName__c.Field API Name.
   5. Data Type: The data type will be automatically populated after the column is chosen.
   6. Known Column Type: This is an optional field. And it usually displays the non-mandatory fields of the entity.

5. Fill in this information, click confirm, and hit save.
6. It will take a few minutes to configure the field and once the page gets refreshed, search for the field and click on the edit icon of the new field. 
7. Select the Basic information tab, and add any more information that you want for the particular field here.
   1. Field: The name of the field comes from the Source connection
   2. Data Type: The data type is how the field is represented and it is pre-filled with the details given in the Source connection.
   3. Aggregation: If the data type is a string, then Aggregation is COUNT, if the data type is decimal/integer then it is SUM. It is pre-filled data. 
   4. Label: It is the value displayed in the grid and it is pre-filled once the field value is entered.
   5. Category: The user can categorize the field by giving a name here.
   6. Format: From the drop-down user can select the format in which he wants the field value to be displayed. 
   7. Conditions: If the user prefers to highlight any particular field with a particular value then input appropriate values for the Conditional operator, Conditional value, and Conditional CSS

Multiple values is not allowed in the Conditional value field. Please enter a single value.

The format for conditional CSS is "color":"red" , "backgroundcolor":"blue"

1. Allow Update: When this box is checked, there will be an impact on Auto rerun rules whenever there is an update in this field.
2. Currency: When this box is checked, all the fields that have currency as a format will be displayed in USD or the currency value chosen by the Corporate in Manage currencies in Salesforce.

1. Mandatory: The multicurrency flag needs to be enabled in Salesforce for the standard package to import all the field values in the preferred currency format.
2. If the field type value is currency, Fullcast standard package will automatically recognize that the multicurrency flag is enabled.
3. If the field value is decimal or double, and not currency but the user wants it to be displayed as currency, they can do it by updating the Field update --> Basic Information details in the entities and fields category and add currency to the format. Also note, if the field is not a double or decimal this will not work and the job may fail if the field format was filled with value currency

Allow Header Filtering: Checking this box enables the user to filter the records by searching a particular value in the header.

Hierarchy Participation: Hierarchy create/edit fields drop-down is decided using this check box option. 

Allow Grid Total: The user can choose this option if there is a need to know the total value for that field. Click Confirm and save.

1. The data quality tab shows a report on the quality of data and plans that are being considered based on the following three criteria.
2. Completeness: Helps to highlight whether the field is empty or null. If you choose to allow the NULL and empty values, the data score value will be calculated accordingly.
3. Uniqueness: The data score here helps to identify the uniqueness of the records. When you click on the "Values has to be unique", it will calculate a score by finding the number of non-unique data available.
4. Accuracy: The accuracy of the data is calculated by giving criteria. The data score is calculated after finding the number of records that satisfy the specified criteria. After setting all the values, click confirm and save. 

After setting up the fields it is necessary to run the jobs. To know more on Import/Export jobs, click on the link.