There are five steps to create and display an entity for data collection:
- Create the entity object.
- Create entity-scoped fields.
- Refresh the Configurable Joins Library.
- Create an entity widget form to collect data. Add your Custom List Fields within the Edit Properties menu.
- Embed the entity widget form in the location where you intend to collect the data.
Step One: Creating the Entity
To create the entity object:
- From the main navigation, select Database.
- Under Records and Datasets, select Entities.
- Click Insert. A popup appears.
-
Configure the following settings:
- Status: Active
- Folder: Keep entities organized by placing them in a folder, or create a new one by selecting Other.
- Name: Give the entity a memorable, descriptive name.
- Scope Insert: Select the scope or scopes applicable to this entity. See the Entities Overview for more information.
- Click Save
Step Two: Creating the entity-scoped fields
When creating an entity, all data points that should be stored will require custom fields to store them.
Considerations before creating an entity-scoped field:
-
- Does this field need to store one value per entity entry, or multiple values?
- Does the field include a predetermined list of values, or does it collect free text?
- If storing multiple values, should new values be added to the field, or should the new values replace the previous ones?
- Is this value you are trying to store something unique per entity entry?
To create entity-scoped fields:
- From the main navigation, select Database.
- Under Records and Datasets, select Fields.
- Click Insert. A popup appears.
- Configure the following settings:
- Status: Active
- Scope Category: Related
- Scope: Select the new entity.
- Configure the remaining settings as necessary*.
- Click Save. Repeat for each field necessary for the entity.
*Click here for a complete listing of all setting descriptions.
Tip
Unique for Merging - Entities require a custom configuration to ensure that incoming entity data can match existing entity data. Wherever you collect this data, the unique for merging field should be included. Some examples of useful unique for merging fields include:
-
- GUID of the entity row
- A unique ID (e.g., from an external system)
- A Concatenate Field (e.g., data from two custom entity fields)
An entity-widget-scoped form can be used to collect entity data. Once configured, the entity widget-scoped form must then be added to either an application page-scoped form or a person page-scoped form.
Entity data can be collected on other types of forms by adding entity-scoped fields directly to the form or by using a replicate block.
Step Three: Refresh the Configurable Joins library
To refresh the Configurable Joins library:
- From the main navigation, select Database.
- Under Queries, click Refresh Configurable Joins Library.
Step Four: Creating an entity widget form
To create an entity widget form:
- From the main navigation, select Forms.
- Click New Form. A popup appears.
- Click New Form. Configure the following settings:
- Page Title: Add a name for the form.
- Status: Confirmed/Active
- Configure additional form settings as needed.
- Click Save.
- Select Edit Form.
- Select Edit Properties. A popup appears.
- Configure the following settings:
- Scope: Entity Widget
- Entity: Select the new entity.
- Custom List Fields: Click Export. Select the entity-scoped fields you created earlier. These exports define the columns that appear on forms on which this form is embedded (like application pages). Add filters and sorts as needed.
- Click Save
- Use the form builder palette to populate the form with the entity-scoped fields. These fields should represent the data that should be collected and stored for each entity entry. For example, Scholarship field, Scholarship account, Scholarship approved, and Scholarship amount.
Step Five: Embedding the entity widget form
(Option 1 - Preferred): Embed an Entity Widget
With the entity form created, embed the form's widget in a custom tab or inside a Slate application:
- Navigate to the desired form page in Forms.
- Edit the form and select "Widget Table."
- Configure each setting* as necessary.
- Click Save.
*Click here for a complete listing of all setting descriptions.
(Option 2 ): Mapping Individual Fields on a Form Without a Widget
- Add a field from the form palette.
- Select the Entity in the System Field drop-down, and the entity-scoped field in the second System Field drop-down.
- Configure each setting as necessary.
- Continue this for any other field associated with the entity that you wish to collect/display.
*Click here for a complete listing of all setting descriptions.