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.
Option List
Allows you to link an option list to the choice cell. The choice options are created and formatted in the option list.
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).
Database Table
Allows you to link a j5 database column to the choice cell. Enter the Table Name, ID Column, and Label Column.
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.
