Important information

You will need to use the keyword «list» to use the following validation rules and to create an external drop-down list.

When creating an external drop-down list, make sure you do it in the correct format.

Validation rules available

Updated by [Excel_File_Name]

Allows to list items from a column in the external list that has the exact same name as the title of the field or column.

  • The items will be listed as they are in the external list
  • The list field will contain a Search field that will allow you to filter long lists faster

Fills grid with [Excel_File_Name]_

Allows to fill a grid with items from an external list formatted as a matrix into the columns with the exact same titles as the external list.

  • The underscore (_) after the Excel file name is important and allows you to target the right column in the matrix
  • The items will be listed as they are in the external list
  • It is not possible to create rowgroups with this validation rule
Did this answer your question?