Picker

1. General information

• The picker is a dialog box that displays a view table with database records whose values ?? can be copied or pasted into the currently open edit form. The picker is typically used to copy entire database records or to pass the value of a foreign key (ForeignKey).
• The link to the picker dialog box with the view table and database records is a magnifying glass icon, displayed on the edit form to the right of the control to which the picker is assigned.
• The picker is available for the following types of controls:
  • TextBox
  • TextArea
  • RichTextBox
  • ComboBox
  • ListBox
  • MultiListBox
  • Radio
  • CheckBox
  • ForeignKey
  • File
  • Image
  • DatePicker
• The picker also provides an AJAX-based autocomplete feature, which starts suggesting database records as soon as the user begins typing a value into the text field in the edit form. For AJAX autocomplete to work, searching for values entered in the edit form must be enabled.
• The picker is configured in a separate dialog. A link to this dialog is represented by a magnifying - glass icon located in the lower-left corner of the control settings dialog to which the picker is assigned.

2. “General” tab

2.1.1. Tooltip

• The tooltip determines the help text that appears when you hover over the picker icon in the edit form.

2.1.2. Data source

• The data source defines the data displayed in the viewer's view table. This data is the result of a database query, which is evaluated when opening the picker window or when starting to whisper values directly into the edit form.
• Data source settings are made in the graphical designer of database queries.

2.1.3. Records per page

• For clarity, the look-up table uses the paging of the displayed records. This is useful in situations where the view table is retrieving large amounts of data.
• Records per page determines the maximum number of records that appear on one page. You can easily switch between pages using the tools that each view table contains in its footer.

2.1.4. Options

• Search for the value entered in the Edit form
  • For the controls TextBox, TextArea, RichTextBox, and ForeignKey
  • Checking this box determines whether the value entered in the Edit form should be found in the pickup view table and whether the edit form should offer an ajax picker.
• Optimized search
  • For all edit form controls with picker options
  • Optimized search means that each column of the picker's view table uses its own text box to enter a search term or phrase.
  • A normal (non-optimized) search means that one common text field is used to enter a search term, in which it is possible to list all search terms, and these are then searched in all columns of the view table at once.
• Show search results only
  • For all edit form controls with picker options
  • Checking this box determines whether the picker's view table should display records only when a search term or phrase is entered.
• Replace the value entered in the edit form
  • For the controls TextBox, TextArea, RichTextBox, and MultiListBox
  • Checking this field determines whether the transfer of the field value from the picker view table to the edit form should replace the value or add it to the end.
• Allow creating new records
  • For all edit form controls with picker options
  • Checking this box determines whether a button for entering a new record of the same agenda, which is used as a data source in the view table, will be displayed below the pickup view table.
• Allow opening records
  • For all edit form controls with picker options
  • Checking this box determines whether it should be possible to open individual records from the picker's view table and display the detail of a specific database record in the picker's dialog box directly in its edit form.
• Allow multiple records to be selected at once
  • For all edit form controls with picker options
  • Checking this box allows you to select multiple records in the pickup at once. Individual records are selected in the picker by checking the checkbox located on each row of the viewer's view table in the first column. In this way, however, it is possible to select only the column “(ID)”, ie. primary key. The selected records are transferred to the edit form as individual primary key values separated by a semicolon.

2.1.5. Assignment table

• Columns
  • The column settings determine which column of the view table in the picker will be copied, which control in the edit form.
  • Picked columns – those that have a source and destination set – are automatically displayed in the picker's view table in the order in which they appear in the assignment table.
  • The columns in the viewer's view table can be hidden by selecting the “Hide” command from the drop-down list located to the right of the “Destination” drop-down list.
  • For columns in the picker's view table, it is possible to activate the search by selecting the “Activate search” command from the drop-down list located to the right of the “Destination” drop-down list.
  • If no search column is selected, the search is automatically activated for all columns of the pickup view table, where this is allowed in terms of the general view table lookup settings defined in the control's properties.

3. “Help” tab

• On the “Help” tab, it is possible to set a list of all other columns to be displayed in the picker's view table, even though none of these columns are peaked.

4. “Activate search” tab

• On the “Activate search” tab it is possible to set a list of all other columns in which the search is to be activated.

5. “Other” tab

• Template name
  • Picker settings can be saved to a template so that they can be easily copied when setting up the picker of another control that retrieves data from the same data source.

6. “Save”, “Reset assignment table” and “Hide – all at once” buttons

• “Save” button – Save changes to the picker settings.
• “Reset assignment table” button – Removes all current assignments between the source and the target across all rows of the assignment table. The values in the Destination and Options columns are reset to an unassigned state.
• “Hide – all at once” button – Sets the Hide flag on all rows of the assignment table.