Column settings allow for options to be set for individual columns that compose the Advanced Row Field.
Important: The field’s Display Type https://appfire.atlassian.net/wiki/spaces/PSJ/pages/540214621/General#Display-Type has a major influence of what needs to be set up in the Column List.
For the read-only fields, only two columns should be configured. One of them acts as primary key, while the other refers to the actual data displayed by the Select/Multiselect/Autocomplete field.
For the Generic fields, many more columns can be configured.
Physical Name
The name of the column in the database.
Label
The column name that will be displayed in Jira, if you decide to make it visible (details here https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15482145/General+settings+for+generic+fields#Hide-Column-Labels). It is used only for the generic Advanced Row Fields. The read-only fields are simple input fields which don’t display the label.
Type
The data type is used for data validations when executing INSERT/UPDATE scripts and, more importantly, for indexing. A text column can be indexed as a string and a number column as number so you can use the correct operators when searching with JQL.
The list of possible types include BOOLEAN, NUMBER, REAL, STRING, DATE, DATETIME and SEQUENCE (for PKs that are autogenerated numbers). The type of a column will determine the constraints that can be configured for it.
Default Value
The value that comes prefilled in the corresponding input of the Insert form.
PK
The column is the primary key in the connected database.
Searchable
Marking a column as searchable (value ‘Yes’ in the ‘Searchable’ select) adds it to the list of inputs that will be available to the user in the Search dialog. This allows for its value to be used in the SEARCH script (https://appfire.atlassian.net/wiki/spaces/PSJ/pages/543031310/Configuring+scripts+for+generic+fields#SEARCH).
There is also the option of searching using just one column, marked as ‘Autocomplete’. For the ‘Autocomplete’ column, there are some extra settings (like the minimum number of characters that will need to be entered to trigger the autocomplete) which you can access using the adjacent button:
If any column is marked as ‘Autocomplete’, the ‘Searchable’ flags for all other columns will be reset to ‘No’.
Required
This marks a column as required (via a * next to its label) when executing INSERT/UPDATE operations. The corresponding input must be filled prior to submitting the Insert/Update form, otherwise an error message will be shown.
Constraints
Settings that require the input data to match certain conditions prior to the user saving the values. See Constraints for more information about using constraints.