Configuring Choice Field - j5 - 28.0 - Administration & Configuration - Hexagon

j5 IndustraForm Designer Help

Language
English
Product
j5
Search by Category
Administration & Configuration
j5 Version
2019

Choice is a Type of IndustraForm cell that enables the user to make a selection from a drop-down menu. The drop-down options are drawn from Custom List, Option List, Predefined Datastore, Database Table, or Import Formula.

Custom List

Allows you to manually add the choice options.

choice_custom

Option List

Allows you to link an option list to the choice cell. The choice options are created and formatted in the option list.

choice_dropdown

Predefined Datastore

Allows you to link a data store to the choice cell. By default, the available data stores are User List (all of the users created on your j5 System appear in the list) and User Rights Groups (all of the user rights groups available on your j5 System appear in the list, for example: Operator, Supervisor, Manager).

choice_predefined_options

Database Table

Allows you to link a j5 database column to the choice cell. Enter the Table Name, ID Column, and Label Column.

choice_databasetable

Import Formula

Allows you to import options for the choice cell. Enter a formula in the Options box.

When using the Database Table or Import Formula options, you need to authorize their SQL queries. To authorize SQL queries, open the Authorized SQL Queries configuration page on your j5 Web Client and click Authorize.

choice_importformula