AgileApps Support Wiki Pre Release

Difference between revisions of "Multi Value Lookup"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 16: Line 16:
# In the Junction Object, visit the field that does a Lookup to the object that contains the records you want to sort.
# In the Junction Object, visit the field that does a Lookup to the object that contains the records you want to sort.
# Under [[Lookup#Record_Filtering|Record Filtering]], make selections for the '''Sort by''' field and the '''Sort Order'''.
# Under [[Lookup#Record_Filtering|Record Filtering]], make selections for the '''Sort by''' field and the '''Sort Order'''.
# Under [[Lookup#Record_Filtering|Record Filtering]] section, filters can be configured in Filtering Criteria.
Note:
1. This filter criteria value supports only static values like 123, 1,2,3, created by equals '56ca4a5cdc1d49a9ba044cb28ea7f021'.
2. Post selection JavaScript is not supported here


''Learn more:'' [[Object Relationships]]
''Learn more:'' [[Object Relationships]]

Revision as of 04:17, 5 August 2021

GearIcon.png > Customization > Objects > {object} > Forms > Elements

A Multi-Value Lookup element appears in the list of elements for a form whenever the object is in a many-to-many relationship with some other object.

For example, the Orders object is in a many-to-many relationship with Tags, by virtue of the junction table between them. So a field called Tags is automatically generated in the element list for the Orders object Form (and vice versa).

From the element list, the field can be dragged into a section of the form, at which point the field type will be displayed: Multi Value Lookup.

Using a Multi Value Lookup

A Multi Value Lookup element is identified by the stacked boxes icon: MultiValueLookupIcon.png. For this field, the GUI gives you a checkbox next to each record, so you select as many of the records as you want.

Sorting and filtering a Multi Value Lookup

To control the order in which records appear in the display list:

  1. Visit the Junction Object that lies between the ends of the many-to-many relationship.
  2. In the Junction Object, visit the field that does a Lookup to the object that contains the records you want to sort.
  3. Under Record Filtering, make selections for the Sort by field and the Sort Order.
  4. Under Record Filtering section, filters can be configured in Filtering Criteria.

Note: 1. This filter criteria value supports only static values like 123, 1,2,3, created by equals '56ca4a5cdc1d49a9ba044cb28ea7f021'. 2. Post selection JavaScript is not supported here

Learn more: Object Relationships