Skip to content

Data Form

Screenshot

The Data Form component quickly converts View State Parameter inputs from a Data Source query into user-configurable inputs for the dashboard. All that is required for the Data Form component is the Data Source.

Screenshot

Basics

Screenshot

Data Source
See Data sources
Validation Analytic

Links to a validation analytic which determines valid input values.

Screenshot

Create the validation analytic in Kx Control. For example:

Screenshot

Define the data parameter (Type: Dict).

Screenshot

Then Push the analytic to selected instance(s) of the connection group.

Screenshot

Submit Button Text
Text description for Button
Expand Dict Parameters

Screenshot

When checked, a Data Source using dictionary-type View State Parameter/s, will expand out the dictionary inputs.

Force Execute on Submit

When checked, will always execute the Data Source query, even if the input parameters are unchanged.

Tip

It can be used as a simple button control to run a query on the dashboard, e.g. by hiding all the input parameters associated with the data source query so only the button appears in the UI.

Show Reset
Float Reset

The Reset button returns View State Parameter to the default values. Float Reset positions the Reset button independently of the input variables.

Screenshot

Show Submit
Float Submit

Includes a Submit button which allows a range of View State Parameters to be updated before applying the values to the connected Data Source. Float Submit position the Submit button independent of the input variables.

No Submit button?

If there is no Submit button, each change of a View State Parameter will be applied to the connected Data Source. Use a Submit button if multiple inputs are required before sourcing from the database. Submit buttons should be used if connecting to very large data sets.

Viewstate Parameters

Screenshot

Display Name
Descriptive term for the input
Hide Parameter
When checked, hides the input: prevents user updates
Tooltip
Include a short text description for the Data Form input
Parameter Type

Type of the input for the Data Source View State Parameters: a user-input box or a dropdown

Screenshot

Screenshot

Data Source

Define dropdown list using a data query

Example: ([]sym:asc exec distinct sym from database)

Use Data Source
Check box to use aforementioned Data Source to populate the dropdown
Multi Select
Multi Select supports multiple item select in dropdown; the total number of selected items is given in Show Row Count
Show Search
Allow for search of dropdown items
Field Summary Threshold

Number of multi-select items permitted before a numeric summary is presented

Screenshot

Tooltip Summary
Number of multi-select items listed in tooltip before numeric summary of remainder is applied.
'Select All' Value

The 'Select All' Value is the value passed to the dropdown view state parameter when all items are selected in a multi-select; for example, set to All.

Note

Ensure the backend is configured to expect the All value rather than the full list. The default view state parameter can also be set to All to ensure all items are selected on load.

Data Source Mapping

Value
When a data source is used to populate a dropdown, Value will automatically be assigned.
Text
When a data source is used to populate a dropdown, Text will automatically be assigned.
Items
If a Data Source is not used, assign Value and Text entries for dropdown; add rows as required.

Action

Actions

Style, Margins, Format

Screenshot

Screenshot

Advanced CSS
Advanced CSS
Field Width
Field Padding
Form Margin
Define input box parameters. Values defined in pixels; e.g. "0px 10px 0px 0px"
Inline Block
Stacks Data Form controls into a single column.
Screenshot
Label Alignment
Label Padding
Label Positions
Label Widths
Parameters of input box labels. Padding defined in pixels; e.g. "0px 10px 0px 0px". Label Width in pixels ("10px") when Label Alignment is set to Left, and percentage ("10%") when Label Alignment is set to Top
Reset Margin
Styling and position of Reset button. Margin defined in pixels; e.g. "0px 10px 0px 0px"
Submit Margin
Styling and position of Submit button. Margin defined in pixels; e.g. "0px 10px 0px 0px"
Vertical Spacing
Vertical spacing of Data Form controls when stacked. Vertical spacing defined in pixels; e.g. "20px"

Style for common settings