User Tools

Site Tools


Guide Section: An EASAP GUI

An INPUTBOX LIST represents a column that will appear in a DATA TABLE. The parameters and behavior is similar to the INPUTBOX in most respects, but exclude the parameters and Child objects that are invalid for INPUTBOX LIST.

Optional Parameters:
Input Type:Select the data type of the INPUTBOX. (Currency, Custom, DateTime, General, Number, Percentage, Text).
Default:Default value to be displayed
Range Reference:Select NAMED RANGE or existing RANGE REFERENCE to link value to cell in an Excel spreadsheet
Label Style:A reference to a USER INTERFACE STYLE that controls the visual appearance of the INPUTBOX's labels.
Input Style:A reference to a USER INTERFACE STYLE that controls the visual appearance of INPUTBOX's input area.
Alternate Style:The USER INTERFACE STYLE selected here will be applied to the second row in the DATA TABLE and every other even-numbered row below it.
Enable if:Logical expression, if TRUE then box enabled, if FALSE then box NOT enabled
Tool Tip: Text to be displayed as a tool tip
Decimal Places: The number of decimal places shown
Thousand Separator:Select whether to show a thousands separator, see INPUTBOX. (default→FALSE, TRUE)
Currency Symbol:Select the currency symbol. (default→$, £, , ¥)
Pattern:Select a format for storage and display of date and time
Tab Index:Establish an order of preference for <TAB> key navigation
<TAB> delivers focus to Tab Index:→1 then 2 and continues in ascending numerical order
After the highest set Tab Index: value, focus is delivered to Tab Index:→0
Tab Index:→-1 will completely exclude this object from <TAB> focus selection
By default→Tab Index:0
Characters:Width of INPUTBOX in characters
Show Date Button:When set to TRUE, a button will be displayed next to the object which allows selection from a calendar. Only available if Input Type: is 'DateTime' type. default→TRUE, FALSE
Number Format Code:Select the custom number format to show
Delimiter:Character to delimit object references in Label: and Default: above, when Input Type: is non-numeric. default→%.
Row Style from DOR:Enter a LIST reference that evaluates to a sequence of (semi-colon delimited, comma-separated CSS attributes that correspond to the sequence of INPUTBOX's in the DATA TABLE's INPUTBOX LIST. Allows for style changes according to the value of the INPUTBOX.

Row Style from DOR:

Row Style from DOR: provides a powerful alternative to Input Style: and Alternate Input Style: which both accept a pre-specified USER INTERFACE STYLE.

Instead of specifying a fixed USER INTERFACE STYLE, the Author may provide, for example, a REPEATED MAP or a simply any LIST that contains semi-colon delimited, custom CSS attributes for each INPUTBOX.

Below is an example using a REPEATED MAP to adjust the 'background-color:' CSS attribute:

  • REPEATED EXPAND red_green
    • Value: Red, Green
  • REPEATED EXPAND red_green_styles
    • Value: background-color:red;border:none, background-color:green;border:none
  • REPEATED MAP repeated_map1
    • List: inputbox_list1
    • Inputs: red_green
    • Outputs: red_green_styles
  • INPUTBOX LIST inputbox_list1
    • Default: Green, Red, Red
    • Row Style from DOR: repeated_map1

The above will create three INPUTBOX's with the default values of 'Green', 'Red' and 'Red', with the corresponding background colors. The colors will change according to the value of the INPUTBOX's.

Using blank entries in Row Style from DOR:

A <SPACE> is required to denote blank CSS-style for an element in a comma-separated list of CSS-style attributes.

Two adjacent commas without any space is a shorthand to adopt, for the current element, the prior element's CSS-style attributes.

Page Tools