Define Auto-population Properties for a Field
You can use auto-population properties to automatically fill in a field value based on defined conditions.
For example, when a user selects a value for the Status field, another field can be automatically populated with the descriptive text of the Status. Or, when a value is provided in one field (Approve Reason), another field (example: Approve Date Time) can be automatically populated with the date/time and the name of the user who made the change.
Use these methods to auto-populate a field:
You can automatically fill in the field's value when another field's value changes. This allows additional values to be retrieved from a validation table when a value is selected for one field.
To auto-populate when a change is made to a table:
- From the Validation/Auto-Populate page, select the Auto-populate check box.
- From the Populate when there is a change in table drop-down list, select a Business Object that, when changed, will trigger auto-populating the field.
- From the Fielddrop-down list, select a field from the selected Business Object that, when changed, will trigger auto-populating the field (the trigger field).
Typically, the selected Business Object is the same as the one containing the field being auto-populated, but it can also be a Business Object that has a 1-1 relationship with the Business Object containing the field being auto-populated.
- Select one of these Populate with options:
Option Description Field from <validation table> lookup table Select this option to populate the field with a value from a field in the table used to validate the selected trigger field. Then, select a Field in the drop-down list.
This option is only available if the selected trigger field is validated from a table.
Value Select this option to auto-populate the field with a defined value. Then, provide a value. Select the Legal Values button for a list of valid values (only available if the field is validated). Field Select this option to auto-populate the field with a value from another field in the Business Object. Then, select a field in the drop-down list. Function Select this option to auto-populate the field using a System Function. Then, select a System Function in the drop-down list. Stored Value Select this roption to auto-populate the field using a Stored Value. Then, select a most recently used (MRU) Stored Value in the drop-down list, or select the ellipses to open the Stored Value Manager, where you can select an existing Stored Value or create a new one. Expression Select this option to auto-populate the field using an Expression. You can use either a stored expression or a custom expression. Business Object ID Select this option to auto-populate the field using the Business Object ID. This option is only available if the selected trigger field is validated using a Business Object name. Action Name Select this option to auto-populate the field using the Action Name. This option is only available if the field holds an Action Name (the hold property is set to Action Name in the field's general properties). Attribute Select this option to auto-populate the field using the selected attribute. This option is only available if the trigger field is set up to Validate against User/Customer.
- Select the Only populate if Field is empty check box to only populate the field if it does not contain a value.
You can use group maps to map values in fields to members of a group object. This allows the system to select the appropriate group member within a relationship. For example, a Specifics ID Field could use a Specifics group map that would populate the field with the ID of a Specifics group member (example: Hardware Specifics or Software Specifics), and then show the appropriate Specifics form in the Business Object.
To auto-populate using a group map: