The following presents a list and short definition of the over 400 field parameters used in RecTrac. This list is in alphabetical order. Click a letter in the table below to skip to the field parameters that begin with it, or scroll down as needed.
A | B | C | D | E | F |
G | H | I | L | M | N |
O | P | Q | R | S | T |
U | V | W | Y | ||
If you have additional questions about Advanced Field Parameters, please contact Vermont Systems Customer Service by phone at 887-883-8757 or generate a Support Case through the Customer portal of the Vermont Systems web site using your Customer ID and password.
A
AddInterface - List of interfaces that this field applies to. Used primarily on the Generic_Fields screen field to limit what screen they show on. If set to RecTrac the field name this field parameter is assigned to will ONLY work on a screen that has the RecTrac interface type.
AddRecordType - List of record types that this field applies to. Used primarily on the Generic_Fields screen field to limit what screen they show on. If set to Maintenance the field name this field parameter is assigned to will ONLY work on a screen that has the Maintenance record type.
AddRestriction - Set the number of instances of the field may appear on the screen (used primarily for non-input fields like tabs, groups, info-boxes, etc.). 0 = Unlimited. All fields in the Database should be set to 1.
AddScreenCheck - Set a procedure name (minus the .p) that runs in order to check if the field should be added to the screen or not. Check ScreenMaintenance.p for more info on input parameters.
AddScreenName - Set a list of screen names that the field applies to. Used primarily on the Generic_Fields screen field to limit what screen they show on. For Example: If set to SAHouseholdUpdate, then the field name this field parameter is assigned to will ONLY show up as available on that screen.
AddScreenSkipOrder - Set a flag value for whether additional copies of the field may be created with incremented names (i.e. myfield, myfield1, myfield2, etc.).
AddToGroupHeader - Set a flag value for whether to move this button field to group header.
AllowEditing - Set a flag value for whether to allow inline editing on this field, if used on DataGrid, this setting applies to all child fields.
AllowedRows - Define a list of CSS classes that a row must have in order to be selected. For example, Change|Delete will only allow rows with a CSS Class of change or delete on them. Note: in order to get classes onto a row you will need to create a custom column called DT_RowClass that runs a procedure and fills it with a space delimited list of classes.
AllowFilter - Flag value for whether a DataGrid or DataGrid Column may be filtered.
AllowGrouping - Flag value to determine whether a DataGrid or DataGrid Column may be grouped.
AllowProfiles - Flag value to allow profiles to be used in a DataGrid. When turned off it will NOT allow any profiling and some features that are in the profile menu will NOT be available.
AllowReorder - Flag value to determine whether a DataGrid or DataGrid Column may be reordered.
AllowRequiredOverride - Flag value to turn off caching for this field when used in a DataGrid. When set to Yes will NEVER use the DataGrid cache for this column. This means it will always build the HTML for the filter AND the edit field that is used in the datagrid on the UI side.
AllowResizing - Flag value for whether DataGrid or DataGrid Column may be resized.
AllowSelecting - Flag value for whether a DataGrid allows selections.
AllowSort - Flag value for whether a DataGrid or DataGrid Column may be sorted.
AllowVisibility - Flag value for whether a DataGrid or DataGrid Column is visible.
AlwaysChangeData - Flag value, when set to Yes the field it is attached to will ALWAYS make process the EnableFields, ShowFields, DisableFields, HideFields even when the field itself is disabled. Note that if this is on and the field it is attached to is disabled, then none of those parameters will be set when the page loads.
AlwaysRebuildDatagridField - Flag value to prevent caching of DataGrid field, such that it is rebuilt every time it is displayed.
AutoCollapse - Flag value to automatically collapse group in WebTrac on page load of search.html. This field parameters works in conjunction with the Collapse field parameter.
- Do not collapse on Search Collapse=Show and AutoCollapse=No
- Collapse only on Normal Search Collapse=Show and AutoCollapse=Yes
- Collapse on Auto Search and Normal Search Collapse=Hide and AutoCollapse=Yes
AutoCompleteColumnStatus - Allows an autocomplete (Picklist) to have a specific column status that does not interfere with the DataGrid or the field itself. Anything value other than Visible will hide the column.
AutoCompleteColumnWidth - Setting to control the width of this field when used as an autocomplete (Picklist) column
Note: This setting does not interfere with the DataGrid column width.
AutoCompleteHeight - Setting to control the height of the AutoComplete dropdown container when this field is used as an autocomplete (Picklist) column.
AutoCompleteMaxRecords - Max limit number of records in AutoComplete dropdown table.
AutoCompleteWidth - Setting to control width of an AutoComplete dropdown container.
AutoOpen - Flag value for a Menu Item to open automatically upon login.
AutoSearch - Flag value for WebTrac to determine whether to automatically search for results on load of search.html.
AvailableLabel - Label to display for an available item in WebTracGraphical.
B
Bandaid - Flag value to designate that this field's value will currently be stored in the MiscInformation column of the corresponding DB table. This is used only on new fields added in between DB update releases.
BottomHeader - Flag setting to display a bottom header at the bottom of a Group field
BreakColumns - Flag setting for a Group field, used in conjunction with the Columns field parameter. This will place a break after every <X> (Columns number) fields. This effectively will eliminate any issues with fields not being on the proper row in some browsers but also has the drawback that the LineWidth field parameter doesn't always work.
ButtonDBTypes - Setting to restrict availability of a Button field to a list of Database Types.
ButtonFunction - Limit availability of a Menu Button field to a particular function (Inquiry,Management,Processing,Report).
ButtonGroup - List of Button fields to be part of a ButtonGroup field, which displays a context menu of the listed buttons, linked in a dropdown menu.
ButtonIcon - Specify a jQuery UI icon image to be used on a Button field. In the edit program there is a list of these icons, and if you visit http://jqueryui.com/themeroller/ then you can see all of them visually. Note that the names listed there start with ui-icon- which should be removed from the name used on this field param value.
ButtonImage - An image on the web server (located in Images directory) to use on a Menu Button field.
Note: This is for MENU buttons ONLY!
ButtonModule - Set a list of modules where a Button field may be displayed. It will not appear in any other modules than those in the list. If the list value is empty, the default behavior is to display the button in all modules.
Note: This setting is also is used to set the CSS class on the menu button for the color.
ButtonNoText - Flag setting to add CSS class ui-btn-icon-notext to a Button field, which prevents the button from displaying a text label.
ButtonOpenLocation - Sets a URL on a Button field to open a new browser tab and go to this location.
ButtonParams - Sets a query string to run to startup a program.
Note: This is for MENU buttons ONLY!
ButtonPermissions - Flag value on a Button field. When set to Yes it checks the user permissions to decide if the button should be enabled or disabled.
ButtonProgram - Setting for a Menu Button field to designate a routine in WebTrac or Mobile RecTrac be be run. The value of this field parameter must be an existing file name with an extension of .html (the value does not include the file extension).
C
CalcTimeSince - Setting for a Fillin input field to automatically set an amount of time value (i.e. 18 years) based upon time expired since the date value set in a chosen Date field (i.e. SAPersonPrimary_Birthday).
CalculateColumn - Set a list of table_field names on a DataGrid that you want to add up. Each column (table_field) is added separately. This is a list of columns you want to calculate (sum) together in a DataGrid. For Example: SADetail_FeeAmount would calculate the total amount of fees in the shopping cart and show in the footer of the DataGrid.
CalculateColumnOptions - Setting used in conjunction with CalculateColumn on a DataGrid. Set list of options for the calculation of each column. The list MUST match the number of entries of CalculateColumn.
- SUM - Adds up all of the rows in a column.
- AVERAGE - Adds up the rows in a column and divides by the number of rows getting an average.
- MAX - Determines the highest value in the column
CalculateFields - Set a list of field names that will be used in the calculation for a numeric field type. The order of the fields are important as the number (place) in the list corresponds to the variable in the formula. See the CalculateFormula parameter for the formula it uses to do the calculations.
- CalculateFields - table_field1,table_field2,table_field3
- CalcualteFormula: ($1*$2)-$3
- This will multiply the values of table_field1 and table_field2 and then subtract table_field3
CalculateFormula - Setting used in conjunction with CalculateFields on a numeric field type. Set a formula to use in calculating this field using variables ($n) as the field entry in theCalculateFieldsparameter. For Example: ($1*$2*$3)-$4 is the formula for calculating fees with the fee prompts.
- CalculateFields - table_field1,table_field2,table_field3
- CalcualteFormula: ($1*$2)-$3
- This will multiply the values of table_field1 and table_field2 and then subtract table_field3.
CalendarColorBlocks - Flag setting to set whether to display events in a Calendar field within colored blocks that are randomly assigned. It does keep similar blocks the same color.
CalendarControls - Set a list of date navigation controls to show for a Calendar field.
CapitalizeValue - Flag setting to determine whether this field should be capitalized when it is saved to the database.
ChartLinkID - Setting for a Menu Button to designate a Chart for it to be associated with.
ClearLine - Flag setting to clear the previous line and puts this new field/input onto a new line without affecting any widths or column spacing.
ClearOnSubmit - Flag setting to clear a Fillin Input field after submitting a request.
Click.AddParams - Query String of additional parameters to send along to the server when this Button field is clicked. This parameter only gets used in the business logic to add additional parameters to a Button instead of having to find and update the Click.Data parameter itself. GUIHTML.p merges both this parameter and the Click.Data parameter together when building the button.
- For Example - Action=Start
- Click.Data: Routine=Maintenance&Action=UpdateRecord
- When GUIHTML.p gets run the new query string will be: Routine=Maintenance&Action=Start
Click.Ajax - Flag setting on Button field, Mobile RecTrac only. When this Button field is clicked, it runs through AJAX and will show a popup of the returned screen.
Click.Cancel - Flag setting for a Button field. When set to Yes the button will not process the validation and allow the page to be submitted.
Click.Close - Setting for Button field to set it to close the parent window when clicked. When set to Yes the button will close the dialog window. This is mainly used for Picklists and popup dialog windows.
- Yes - Uses parent panel/window close action.
- Continue - Runs Click.Data, Click.Submit processes and closes window in JavaScript.
- NoProcess - Closes window in JavaScrip Only.
- No - Does nothing
Click.Data - Query string setting on a Button field listing data that will be passed to the server when the button is clicked. This can override any values that are on the screen as well if using the Click.Submit. parameter. For Example: Routine=Maintenance&Action=UpdateRecord.
Click.DataGrid - Set a list of DataGrid field names to get values from when this Button field is clicked. If you do not want to have to list out names you can use <<ALL>>for all DataGrids on the screen or <<VISIBLE>> for only the DataGrids that are actually visible on the screen (no DataGrids hidden on other tabs will be used).
Click.DataGridOptions - Setting used in conjunction with Click.DataGrid on a Button field. Define a list of DataGrid field parameters to override (the list must only include parameters set in Click.DataGrid).
- For Example: TotalSelect=1&SelectName=LinkRecordID&AllowRow=Change|Delete
- When the button is clicked the DataGrid(s) that these parameters are attached to will require only 1 selection and will pass the selected row value as LinkRecordID instead of the SelectName value.
Click.Hardware - When set to a set of hardware commands it will run these commands sent to VIC when the button is clicked. Can also be an integer which matches up to SetData named Click.Data<Number>. This allows for multiple processes to happen when the button is clicked.
Click.HardwareSubmit - Flag setting for Button field, used in conjunction with Click.Hardware. When it is set to Yes, all of the screen values will be sent to VIC along with the Click.Hardware URL data.
Click.InputCharacter - Designate a character that should be output in the last focus field whenever the button is clicked (commonly used for number pads). Also, special operations such as clearing the entire field value can be set with special values enclosed inside < > (i.e. <CLEAR>, <TAB>, etc.).
Click.Notification - Set a Button field click event to initiate a series of polling requests to the server (once every second) for as many seconds as defined by this field parameter value. When set to 0 the duration will use the Static Parameter field value for Notification Duration.Once the button is clicked, it will check for notifications every second for as long as this field parameter is set. For example, if you run a report we want to check every second for 1 minute to see if the report is done. After that 1 minute (60 seconds) it will revert to checking for notifications ever X seconds (based on another Static Parameter field).
Click.NoValidate - Flag setting to indicate that this Button field should NOT do any validation if submitting a form. This ONLY applies when Click.Submit is used.
Click.Open - Setting for Button field to specify how to display the response to a click event. When set to Window it will open the request in a window, when set to Tab it will open up a new tab and when blank will use the current tab, Partial opens the window embedded inside the current window.
Click.Picklist - Flag setting for a Button field, when clicked and this parameter is set to Yes and the button is part of a Picklist and a DataGrid, the value from the DataGrid will be placed in the Picklist.
Click.Redirect - Set a URL to redirect the user to when this Button field is clicked (opens a new tab in the browser).
Click.Return - When clicked, the button should open a NEW sub session and when that sub session finishes (by clicking a select button for instance) it will return values that will then run this query string.
Click.Scheduler - Set a list of SuperGrid fields whose values are submitted at when this Button field is clicked. If you do not want to have to list out names you can use <<ALL>> for all SuperGrids on the screen or <<VISIBLE>> for only the SuperGrids that are actually visible on the screen (no SuperGrids hidden on other tabs will be used).
Click.Submit - Set a Screen name you want to submit (Screen name being the form name) and any values within that screen when this Button field is clicked.
Note: You can use <<PARENT>> which will submit the parent form that this Button is in (all screens have a parent form wrapped around it).
Click.Tab - Set a Button field to move focus to a different tab when clicked. When set to a + it will increment to the next tab (if this is the last tab it will rotate back to the first tab) or when a - will decrement to the previous tab (if this is the first tab it goes rotates to the last tab).
Click.WaitForDataGrids - Set a Button field type to pause its execution of the click event until a named DataGrid is finished saving.
ClickOnEnter - Designate a button to programmatically issue a click event when the enter key is pressed while focus is on this input field.
Collapse - Sets Group field visibility and whether there should be a hide/show icon when there is a header.
- None - No collapsing
- Hide - Default to hidden showing header and icon. When the header is clicked it will open.
- Show - Default to visible showing the header and icon. When the header is clicked it will collapse.
ColorFormat - The color format to use for the color picker. Either RGB or RGBA.
Cols - Set the number of columns in an Editor field. This is based on a character count per row. For Example: If set to 50, then 50 characters will be on a single line before the next row.
Note: This parameter is not used if this is an HTML Enabled editor. In that event, the Height is used.
Columns - Set the number of columns that a Group field should show for fields and labels. Up to seven (7) columns can be set in a Group.
ColumnDescription - Set on FieldTable to specify whether to display the short or long description of an ARSection.
ColumnEditingOn - Flag setting on a DataGrid to determine if editing is allowed on its columns. CME - This parameter is pretty much a duplicate of AllowEditing
ColumnInMore - For WebTrac. When this is turned on, the column will show up in the more dropdown to the right in desktop or will be listed at the bottom section in mobile. This mobile part is a work in progress at the moment. Example: ARWebSearch->Tab1->Group4->Output_Table->Share).
ColumnLabel - The label for a DataGrid column when this field is in a DataGrid. If this field is blank it will use the FieldLabel parameter instead for the column label in the DataGrid.
ColumnLabels - Sets the list of column labels on a FieldTable in WebTrac.
ColumnNumber - Assigns a column number a Group field to be used in cases when the parent Tab has multiple columns set (ColumnWidths).
ColumnStatus - Determines if this input field should be shown, hidden or completely left off when it is used in a DataGrid. If set to DataOnly, then the column will not display but the value will be sent with a request.
ColumnWidth - Set the width of the column when this input field is used in a DataGrid. When blank it will auto-set the width based off the number of visible columns / the width of the DataGrid.
ColumnWidths - Set the number of columns in a Tab and set the widths for each column. This is a pipe delimited list of up to 5 different percentages that add up to 100% to set the columns for a Tab. For Example: 50%|25%|25% would be three (3) columns with those percentages for each of the columns. Column 1 would be 50% of the screen width.
ComboBoxAutoFocus - Flag setting to automatically put focus on this ComboBox field on load.
ComboBoxDisableTyping - Flag setting to disable typing on a ComboBox field.
ComboBoxMinHeight - Set the minimum height style of a ComboBox field to a number of pixels (this is the dropdown height).
ComboBoxRolodex - Flag setting to indicate that this ComboBox field should be displayed as a Rolodex Field.
ContainerOnly - Flag setting on a Group field to control how its border is displayed. If set to "Yes" (checkbox enabled), the Group will not have a border, margin or padding; it will simply act as a container to be used to hold the items in it. Useful when you need to group fields together but do not want the styling of a Group.
CriteriaQuery - Define the equality criteria for this field when it is used as part of the criteria for a report. For fields with names ending in _Equals, the criteria should be DBFieldName EQ '<field_name>', for fields with names ending in _Begin the criteria should be DBFieldName GE '<field_name>', and for fields with names ending in _End, the criteria should be DBFieldName LE '<field_name>'. This is used for REPORTS only and is part of the Report criteria query for this field when a report is run. Use <TABLE_FIELD> to replace info from the URL.
- Examples: _Equals/_ComboBox Fields: ARActivity.ActivityCode EQ '<ARActivity_ActivityCode_Equals>'
- _Begin Range Field: ARActivity.ActivityCode GE ARActivity_ActivityCode_Begin>'
- _End Range Field: ARActivity.ActivityCode LE '<ARActivity_ActivityCode_End>'
CriteriaQueryBegins - Define the 'begins with' character matching criteria for this field when it is used as part of the criteria for a report. This should only be used fields with names ending in _Equals, and the criteria should be: DBFieldName BEGINS '<field_name>'. For Example: ARActivity.ActivityCode BEGINS '<ARActivity_ActivityCode_Equals>'
CriteriaQueryCalculated - This is used for REPORTS only and is part of the Report criteria query for this field when a report is run. This field param has values of 'Yes/No' and is used in conjunction with the other CriteriaQuery fields. This parameter indicates whether the CriteriaQuery for this field needs a calculated value before it can be evaluated.
For Example: A customer may want to use Total Due or Household Balance as criteria for a report but these fields do not exist in the database. The following field params would need to exist for the SADetail_TotalDue_Begin and SADetail_TotalDue_End field screendefs:
- CriteriaQueryCalculated: Yes
- CriteriaQuery: <Calc-SADetail_TotalDue> GE <SADetail_TotalDue_Begin> | <Calc-SADetail_TotalDue> LE <SADetail_TotalDue_End>
In the CriteriaQuery field param the value for comparison against the screen value should be 'Calc-' followed by entries 1 and 2 of the Criteria Screen FieldName.
Records with the CriteriaQueryCalculated set to 'Yes' will not be added to the initial results query. It will get run against the result set of the initial query instead and kick out any results that do not satisfy the CriteriaQuery.
CriteriaQueryContains - Define the 'contains' character matching criteria for this field when it is used as part of the criteria for a report. This should only be used fields with names ending in _Equals, and the criteria should be: DBFieldName CONTAINS '<field_name>'. Example: ARActivity.ActivityCode CONTAINS '<ARActivity_ActivityCode_Equals>'
CriteriaQueryEnds - Define the 'ends with' character matching criteria for this field when it is used as part of the criteria for a report. This should only be used fields with names ending in _Equals, and the criteria should be: DBFieldName MATCHES '*<field_name>'. Note that an asterisk comes before the field_name to act as a wild card. For Example: ARActivity.ActivityCode MATCHES '*<ARActivity_ActivityCode_Equals>'.
CriteriaQueryLookup - Define 'lookup' matching criteria (results will include any values matching the list of values this field has selected) for this field when it is used as part of the criteria for a report. This should only be used on fields ending in _DataGrid or _ComboBox. The format is: Lookup(DBFieldName,'<field_value>') gt 0. For Example: LOOKUP(SAFEE.FeeCategory,'<SAFEE_FeeCategory_DataGrid>') GT 0
CriteriaQueryMatches - Define the exact character matching criteria for this field when it is used as part of the criteria for a report. This should only be used fields with names ending in _Equals, and the criteria should be: DBFieldName MATCHES '<field_name>'.
CriteriaQueryModule - Sets a module which limits the use of a query filter to records within the given module when this field is used as part of the criteria for a report.
Note: This only applies to multifetch queries.
CriteriaQueryOutput - Additional criteria which will applied to a calculated field, currently used by bottom line reports.
CriteriaQueryPrimaryFieldName - Used for DateTimeFillin fields which have CriteriaQueryPrimaryRank value. This setting determines which DB field name will be used as the date value.
CriteriaQueryPrimaryRank - Specify a ranking for this date field when determining which date field to use as an index.
CriteriaQueryProcedure - Set a delegate procedure to run as a means of applying complex criteria for this input field. Used in conjunction with CriteriaQueryProcedureInp, which defines the input fields which are passed to the delegate procedure. The procedure must be a Progress file (.p) which is located in /Business/.
CriteriaQueryProcedureInp - Used in conjunction with CriteriaQueryProcedure. Define a list of parameters to be passed to the procedure specified by CriteriaQueryProcedure. The list must have an equal number of values (delimited by &) to the number of input parameters in the procedure named in CriteriaQueryProcedure for this field. Field names may be used as input parameters in this list, and are denoted by being enclosed inside <>, i.e. <LSTeam_FeeCode_ComboBox_MatchOption>.
CriteriaQuerySkipIfBlank - Flag setting to prevent this field from applying its CriteriaQuery to a report when its value is left blank. When set to 'Yes'; if the screen value of the field is left blank, no CriteriaQuery will be added to the report for this field. When set to 'No' the CriteriaQuery will be added for this field using a blank value.
CSSClass - All a custom CSS class to be added to a field, requires the CSS Class to be in the app.css or custom.css.
CSSStyle - Set custom CSS Styles to be added to this field. Must be in CSS format such as property:value;property:value. For Example: Padding:0; will set the padding of the element to 0.
Note: Changing this may have adverse reactions on the page as each widget has a base set of styles to set them to be consistent.
CustomHelp - Extra help information for a field/screendef. Note: this should be only updated by the customer at this point as the Help field parameter is what VSI will set.
D
DataFormat - Set a custom data format for how to display this field. Currently used for integer or decimal values. This setting also determines the decimal length for a field as well. CME - This is the Progress Data Format when stringing a Progress value.
DataGridAutoFilter - Flag to set whether a DataGrid will automatically filter results when a column filter value is edited. This value is set to Yes on the default widget DataGrid. When set to 'No' it will prompt the user to filter the DataGrid.
DataGridColorKey - Appends a color mapping key to a DataGrid to show the user how to interpret the color coding scheme in the DataGrid.
Note: This requires the CSS classes to be in the theme style sheet already to work properly.
DataGridErrorMessages - Set a list of custom error messages to display for particular DataGrid operations (i.e. change, clone, etc.).
DataGridHideOptionMenu - Flag setting on a DataGrid to hide the Options button (located at the top of the DataGrid).
DataGridHideOptionsSettings - Flag setting on a DataGrid to hide the Show Settings item in the "Options" ButtonGroup at the top of the DataGrid.
DataGridRefreshTimer - Setting on a DataGrid to make it refresh automatically after <x> seconds. The value of this field parameter is the number of seconds to wait to refresh. 0 = no fresh.
DataGridSelectFields - Set a list of FieldName=DataGridFieldName that should be updated when a record is selected in a DataGrid. For Example: If you wanted to update the field globalsales_pmexpiredate with the value of the pmexpiredate column in the DataGrid, then you would set the value of this field parameter to: globalsales_pmexpiredate=pmexpiredate.
DataGridShowAsToolTip - Flag setting on a DataGrid to cause any column in the DataGrid with overflowing text to show in a tooltip.
DatagridTimeout - Set the timeout in seconds on a DataGrid so that the query only will run for this amount of time. The value is an integer and if set to 0 is disabled. Code is in Fetch.p which uses a SetData to determine length it should run in seconds. For DataGrids this is set in FetchDatagrid.p.
Notes: This will break sorting if the DataGrid is NOT a search first DataGrid, as the query does not use any by statements in this case causing potential records to be missing and thus not sorted.
This parameter does NOT work for DataGrids that do not use FetchDatagrid or Fetch.p to fetch data.
DataSource - Set the Query String for the DataGrid to fetch its data.
Note: If the Routine, Action or SubAction are not specifically set in the DataSource, then it will default to the current Routine Action and SubAction (FetchDataGrid) values.
DataSourceFields - Used in conjunction with the DataSource field parameter and sets a list of field_name values to append to the Query String defined in the DataSource field parameter.
For Example: DataSource: Routine=Maintenacne&Action=Start&SubAction=FetchDataGrid DataSourceFields: table_field1,table_field2,table_field3.
The Table_Field1 value is 1, Table_field2 value is 'Test' and Table_Field3 value is '0.' The new DataSource that the DataGrid will use to fetch data with is as follows:Routine=Maintenacne&Action=Start&SubAction=FetchDataGrid&table_field1=1&table_field2=test&table_field3=0.
DataSourceProperty - Set the JSON property name that a DataGrid reads from the response for the data to populate the DataGrid. This property should have all of the data from fetch or whatever source.
Note: This is really just the GetData for the handle that is used to create the dynamic temp-table.
DataType - Designate a datatype for this field. This determines how the values are translated on the backend when going to the UI and how the backed translates what the UI sends.
DateSelect - Flag setting for a DateFillin field. When set to Yes it turns a normal DateFillin field to a date select allowing to choose current date, days from today, etc. Used a lot in reports.
DateTimeSelect - Flag setting for CharacterFillin field. When set to Yes it turns a normal CharacterFillin field to a date/time select allowing to choose current date/time, days from today, etc. Used a lot in reports.
DefaultAddRecordQuery - Defines query criteria to filter the list of default record options, which are presented when adding a new record on a maintenance screen.
DefaultSorting - Set a list of table_field names (columns) you want to start sorted when this DataGrid loads.
DefaultSortingDirection - Setting used in conjunction with DefaultSorting, which specifies which direction each sorted table_field name will be sorted by default. Default sorting directions for the default sorts either ASC or DESC. This list MUST match up to the DefaultSorting entry list.
DeferLoading - Flag setting on a DataGrid to not get data when the DataGrid is loaded into the page. This assumes that something else will retrieve the data such as some JavaScript.
DisableDoubleClick - Enable this data grid setting to prevent double-click actions from occurring on a data grid.
DisabledTimes - Specify a list of time ranges to disable for a TimeFillin field.
DisableFields - Define a list of values for this field, which if this field is set to, will disable a set of other fields on this screen. The format is a comma delimited list of value=field&field&field… pairs. When the value of the field equals one of the values, then it will go through all of the fields after the equals and DISABLE them while all other value fields will be ENABLED. The value must be exact including any spaces or special characters. The special keyword <<ALL>> can be used to disable a set of fields for any non-blank value.
For Example: Table_RecordType values are Option 1 and Option 2. When 'Option 1' is selected I want to DISABLE Table_Field1 and Table_Field3 but ENABLE Table_Field2. When 'Option 2' is selected I want to DISABLE Table_Field2 but ENABLE Table_Field1 and Table_Field3. The Parameter would look like this:
Option 1=Table_Field1&Table_Field3,Option 2=Table_Field2.
DisplayOption - Setting for WebTrac to control how a Table or Menu Item will be displayed. When used to determine how the table will be shown, option values are either Detail (header with description and text block) or Summary (just as a regular table). When used for a menu item, it determines if a menu item should be visible for a member (logged in user) or both a guest and a member.
DoNotMemorize - Sets in Processing/Reports to not memorize this field when the screen values are saved on a run of the process or report.
DoubleClickButton - Setting to programmatically trigger a click event on a Button field when a row on this DataGrid is double-clicked. This is useful for picklists so that the picklist button can be used and if it is not found it will fall down to the DoubleClickParams, which could run just the normal update Routine/Action. CME - The list is a hierarchy, so if the button doesn't exist it will go to the next one and then finally to the DoubleClickParams. The value should be a valid button field name on the screen the DataGrid is on.
DoubleClickParams - Set a Routine/Action/SubAction you want to run when double clicking on a record in a DataGrid.
DoubleClickSelectName - Setting to change the behavior of a double click event on a row of a DataGrid. Set an alternative GetData field name to have its ID sent instead of the SelectName SetData value. If it is not set, then it will use the SelectName value.
DropDownWidth - Sets the width (in pixels) for the drop down list on a ComboBox field.
E
EditParams - Set the query string to send to the server when editing a row in a DataGrid. This is normally the routine/action/subaction to run to save the value of a cell when in edit mode. Uses EditSelectName to send the Record ID as well along with the name of the field and the value of the field to save.
EditSelectName - Set the name in the name=value for the DataGrid row ID when editing a row. This gets send along with the EditParams and is the row ID.
EnableFields - Define a list of values for this fields, which if this field is set to, will enable a set of other fields on this screen. The format is a comma delimited list of value=field&field&field. When the value of the field equals one of the values, then it will go through all of the fields after the equals and ENABLE them while all other value fields will be DISABLED. The value must be exact including any spaces or special characters. The special keyword <<ALL>> can be used to enable a set of fields for any non-blank value.
For Example: Table_RecordType values are Option 1 and Option 2. When 'Option 1' is selected I want to ENABLE Table_Field1 and Table_Field3 but DISABLE Table_Field2. When 'Option 2' is selected I want to ENABLE Table_Field2 but DISABLE Table_Field1 and Table_Field3. The Parameter would look like this:
Option 1=Table_Field1&Table_Field3,Option 2=Table_Field2.
EncryptValue - Flag setting to determine if this field value should be encrypted when stored.
ErrorLabel - Shows the text in the paragraph of an InfoBox field as an error, used mainly for global sales.
Expand - Flag setting to enable the ability to expand/contract this Group by clicking an icon in the right corner of the header of this group. When expanded it will take up the entire size of the panel that the program is in and expand any other information in said group. When clicking the icon again it will go back to the normal size. It is required to have a header in order to use this because it needs the header for the icon.
ExternalLink - Flag value to determine if this Link field's HREF value is an external URL or part of the WebTrac framework. Basically, it will treat this Link as a Query String value unless this field parameter is set to Yes. In this case, it does not modify the URL.
F
FetchSelectField- This parameter is used in conjunction with FetchSelectURL and is used to determine what field to modify the options of when the value changes of the field this parameter is linked to. For Example: If this field parameter is linked to the type code in WebTrac search and when the value is changed, then it updates the SubType field with a set of options that are fetched using the FetchSelectURL.
FetchSelectURL- This parameter is used in conjunction with the FetchSelectField and is used to determine what URL to fetch options from when the value changes of the field this parameter is linked to. For Example: This if field parameter is linked to the type code in WebTrac search and when the value is changed, then it updates the SubType (FetchSelectField) field with a set of options that are fetched using this URL.
FieldAccepts- Used in Mobile RecTrac to set the accepts attribute for a file upload to set what file types are accepted to be uploaded.
FieldCheck- Designate a .P file to execute to check if this field should be on the screen or not when the screen is being built.
FieldDisabled- Setting to control whether this field is disabled depending on UIData values. the format is comma delimited list of name=value pairs that are checked against the UIData and if any of them pass the field is considered DISABLED. Each entry can have multiple name=value delimited by a & which all in that full entry must match.
For Example: Name1=value1&name2=value2,name3=value3&name4=value4Both name1 and name2 or name3 and name4 have to match in order for it to pass and consider the field DISABLED.
FieldEqualTo- Designate another field on the same screen that this input field value should be equal to. Used for validation.
FieldGridURL- Set a URL to fetch JSON data for a FieldGrid widget. The field grid widget is used for the placeholder logic in Reports. Basically a grid of columns and spaces where fields can go and a list of fields that can be dragged and dropped in to the grid.
FieldHidden- Setting to control whether this field is hidden, depending on UIData values. the format is comma delimited list of name=value pairs that are checked against the UIData and if any of them pass the field is considered HIDDEN. Each entry can have multiple name=value delimited by a & which all in that full entry must match.
For Example: Name1=value1&name2=value2,name3=value3&name4=value4Both name1 and name2 or name3 and name4 have to match in order for it to pass and consider the field HIDDEN.
FieldLabel - Set an alphanumeric text label of this field. When this field parameter is blank, the field does not display a label.
FieldMax - Set the maximum allowable number for a numeric input field.
FieldMin - Set the minimum allowable numeric value for a numeric field.
FieldName - Define the name of this field. Normally, the format of the name should follow a standard of <ScreenName>_<FieldType><FieldName> to help understand the purpose of the field.
FieldOptionList - Set the list of filtering by options available when this field is filtering in a DataGrid. The labels for these options are defined in FieldOptionLabels, which must have the same number of values as this field parameter.
FieldRange - Set a range of acceptable numeric values for this field. The format for this parameter is LowerLimitValue,UpperLimitValue.
FieldRequired - Flag setting to designate this field as being required to hold some non-blank value for it to pass validation. When set to 'Yes,' it requires that a value be entered into this field.
Note: Only blank values are considered not valid, so if the field has a value in it, and if the field is required, then it will be accepted.
FieldRequiredMessage - Used in conjunction with FieldRequired to present an error message when a required field is left blank. This field parameter defines the message on screen when the value is blank for the field and validation for that field occurs.
FieldShow - Setting to control whether this field is visible, depending on UIData values. The format is comma-delimited list of name=value pairs that are checked against the UIData and if any of them pass, then the field is considered VISIBLE. Each entry can have multiple name=value delimited by a & which all in that full entry must match.
For Example: Name1=value1&name2=value2,name3=value3&name4=value4Both name1 and name2 or name3 and name4 have to match in order for it to pass and consider the field VISIBLE.
FieldStatus - Set the status of this field to be:
- Hidden - Not visible on screen.
- Disabled - Shown on screen but not updateable.
- Updateable - Shown on screen and can be updated.
FieldType - Sets the type of this field.
Note: The list of the valid fields are different based off the interface, but this parameter is used by all interfaces.
FieldValue - This setting is the value of this field either from the backend or the default value on an add.
FieldValuePersist - Flag setting for input field types, when set to "Yes" will save the value after a save and the next time an "add" occurs it will reuse the previously stored value. Mainly used for maintenance were on every add it has the previous record type.
FieldVisible - Flag setting to determine wheher the field should be hidden ('No') or shown by default on the screen. Works well in conjunction with ShowFields, as you may want the field hidden by default but use ShowFields to show it when it is needed.
FileName - Used to determine the file name and file path to a file either on the file system, web server, or BLOB entry. For Example: Tthis file name is used for the Image Widget file name which can be a BLOB file from the database, a file system file that gets BLOB'ed and sent to the UI, or the file name can be an image relative to the Image Path set in the InterfaceParameters.
FilterOptionDefault - Sets the default filtering by option when this input field is in a DataGrid and is being filtered.
FilterOptionLabels - Used in conjunction with FilterOptionList (both of these field parameter lists must have the same number of values, in the same order) to define the filtering by option labels available when filtering in a DataGrid.
FilterValue - Sets a default filter value for this field when a DataGrid is loaded into a page.
Note: This is NOT used when saving the previous state of the DataGrid to the user.
FixedPosition - Setting for a Group which allows a group to be fixed to the top or bottom of a panel. Valid options are:
- Top
- Bottom
- None - No effect
FocusField - Focus this field when the screen loads.
FocusCleanup - Flag setting for input fields. When set to 'Yes' it will clear the value of the field when focused. This is useful on fields that need to be cleaned up after having a popup show up, like in Global Sales name lookup.
FocusField - Set flag to place focus on this field when the screen is finished loading and when the panel is switched to as well.
FocusFieldOnce - Flag setting to place focus on this field when the screen is finished loading and only once.
FullLine - Is this field and label on a full line? Usually used in conjunction with the columns in the group. For Example: If you set the group to three (3) columns but you want a field to be across all 3, then you can set this field parameter to 'Yes.'
G
GetDataValue - Set a UIData GetData name to use its value instead of using the default value when adding this field to the screen.
GroupStacked - Flag setting to control whether this Menu Theme Button displays as stacked.
GroupTheme - Setting to control the Menu Theme in RecTrac.
H
Height - Set the height in pixels or percent of a DataGrid or Group.
Help - Set the help text that will show on the ToolTip when the "i" help icon is engaged and you mouse-hover of the field, or the "?" icon is pressed while this field is in focus.
HelpFieldLabel - Set the label of the field level help entry in the help screen to be something other than the FieldLabel value. This is useful when a field may not have a FieldLabel or it may not make sense out of context of the screen on which it is located.
HelpRedirect - Setting to change the screenname of the full screen help link that goes from the "?" icon in RecTrac to the full page help.html program.
HelpScreenName - Set the screenname of a menu item Button that is then used to build the table of contents in the full screen help.
HiddenFields - Define a list of values for this fields, which if this field is set to, will hide a set of other fields on this screen. The format is a comma-delimited list of value=field&field&field. When the value of the field equals one of the values it will go through all of the fields after the equals and HIDE them while all other value fields will be SHOWN. The value must be exact including any spaces or special characters. The special keyword <<ALL>> can be used to enable a set of fields for any non-blank value.
For Example: Table_RecordType values are Option 1 and Option 2. When 'Option 1' is selected I want to HIDE Table_Field1 and Table_Field3 but SHOW Table_Field2. When 'Option 2' is selected I want to HIDE Table_Field2 but SHOW Table_Field1 and Table_Field3. The Parameter would look like this:
Option 1=Table_Field1&Table_Field3,Option 2=Table_Field2.
HideFilters - Flag setting to hide the filters in this DataGrid by default. This does not remove them, but rather hides them. Using the icon shows them. Used to get more room in a DataGrid.
Href - Define the href attribute on this Link field. If the field parameter ExternalLink is set to 'Yes,' then this value will be treated as a full URL. Otherwise it will be parsed as a Query String value.
HTMLEnabled - Flag setting to allow HTML within a text Editor field.
HTMLEncodeValue - Flag setting for an input field, when set to 'Yes' it will run the html-encode2 function on the value output when run through fetch.p. This is useful when the value has brackets in it (<>) as those brackets are considered HTML code and do not show up in a DataGrid or on a screen. Basically it changes the "<" to "gt"; and ">" to "lt;."
I
InputType - Sets a Fillin Input field to either show or obfuscate its text value.
- Text - Field will display the text entered.
- Password - Field will obfuscate the text and display either pipes (|) or dots (•).
IsCreditCard - Flag setting for CharacterFillin or IntegerFillin field. When set to 'Yes,' the field is considered a credit card and will do some basic JavaScript credit card validation on the UI side. CME
Note: This is a legacy field, no longer used. VSI does not allow CC numbers to be entered on any VSI screen.
IsEmail - Flag setting for an EmailFillin (Preferred) field, when set to 'Yes,' the field is considered an email address and will do some basic JavaScript email address validation on the UI side.
IsTouch - Flag setting on a Tab, used to pass information to the JavaScript that all groups/buttons below it are layers in a Touch setup.
IsURL - Flag setting for a CharacterFillin, when set to 'Yes,' the field is considered a URL and will do some basic JavaScript URL validation on the UI side.
L
LabelAlignment - Set the alignment of the text in the label for this field (Left, Right, Center, or Default). Leaving the value blank will use Default, which is almost always LEFT.
LabelRight - Sets whether the label for this field should be on the right or left of the input field.
LabelWidth - Sets the width of the line in pixels or percent for the label on this field. The best option would be to use percents as most things are percentage as the screen size may differ and using pixels would cause this to be an issue. The line is a wrapper around the label and input field that naturally is a single line but when column grouping is enabled in a group it may be only 50% when two (2) columns are used or a different percentage based on the number of columns.
LineClass - Sets a class to be added on the line wrapper HTML that wraps a label and field in all products.
LineStyles - Sets custom CSS styles to be applied to the line wrapper HTML that wraps a label and fields in all products.
LineWidth - Sets the width of the line in pixels or percent for this input field. The best option would be to use percents as most things are percentage as the screen size may differ and using pixels would cause this to be an issue.
LinkedFieldParams - Sets a list of fieldnames that this field should also take its parameters from. Allows for DefaultWidgets to act as parent field types.
LinkFieldName - Setting on DataGrids and Picklists to determine the linked field in the query for that DataGrid or Picklist. This is the table_field of the child table. Required the LinkRecordID to be set in order to process.
LinkQueryFieldName - Used for linking queries by field name. For Example: [SAControlAccountHistory_HouseholdNumber]
LoadFile - Set a JavaScript or Style sheet to be loaded when this Tab field's page is loaded allowing for on demand access to files instead of loading it initially when the framework loads up. This should be a path/file relative to the JavaScript location for the webserver so something like models/MyModel.js would load 'JSPath + / + models/MyModels.js' as the path.
LoadModel - Set the name of a JavaScript subscription on the UI side which will be executed for this Tab. This basically allows for more advanced/custom JavaScript to be run when a screen is loaded.
Note: The value is case sensitive.
M
MaxDate - Set a maximum date which may be entered in a DateFillin field.
MaxLength - Set a maximum number of characters that may be entered in to a Fillin input field,
MaxSelected - Set the maximum number of selections that may be made on a multi select ComboBox.
MaxTime - Set a latest time value you want to show in the time picker. Should be in the format of HH:MMAM.
MinDate - Set a minimum date for a DateFillin field.
MinLength - Set a minimum length in characters for a Fillin type field.
MinTime - Set an earliest time value you want to show in a TimeFillin field. Should be in the format of HH:MMAM.
ModuleList - Define a list of Modules for which this field will appear. If the value of this field parameter is left blank, then this field will display in all modules. Currently, this setting works only for the SAFeeShort, SAFeeUpdate, SARuleShort, SARuleUpdate screens. These screens are used by every module for rules and fees management, but have many fields which are only pertinent for particular modules. By setting the ModuleList field parameter for these module specific fields, it can be ensured that they will only appear when they are important..
MonthLabels - Set the labels to display as the name of each month in a GUI Calendar.
MoveScreenCheck - Designate procedure name (minus the .p) that runs in order to check if this field should be moved or not. Check ScreenMaintenance.p for more info on input parameters.
MultiFetchQuery - Define the equality criteria for this field when it is used as the criteria to execute multiple queries (once per module) for a report. Typically, this ComboBox holds a list of modules, and those selected are excluded from the list of modules to run a separate query for. This query is used when only one module is selected, otherwise the query defined in MultiFetchQueryLookup is used when more than one module are selected. The criteria should be DBFieldName NE '<field_name>'.
MultiFetchQueryLookup - Define the equality criteria for this field when it is used as the criteria to execute multiple queries (once per module) for a report. Typically, this ComboBox holds a Multiselect list of modules, and those selected are excluded from the list of modules to run a separate query for. This query is used when multiple modules are selected, otherwise the query defined in MultiFetchQuery only one module is selected. The criteria should be Lookup(DBFieldName NE '<field_name>') EQ 0.
MultiFetchReport - Flag setting to indicate that this report Screen supports fetching records by module (multifetch query, performing a separate query for each module).
Multiple - Determines if multiple answers are allowed for this ComboBox field. If value of this field parameter is blank, only one answer will be allowed.
MultipleFields - This is a comma-delimited list of values from another field that when looped through will create additional fields on the screen. This allows for a single database field to have multiple fields on the UI side. Since the field is based off another field (like a record type) the record type can hide/show these multiple fields to get the illusion that there is only a single field with different values
For Example: Table_RecordType:
- When set to Option 1, it needs to change Table_Field1 to a currency fillin
- When set to Option 2, it needs to change Table_Field1 to a decimal fillin
The MultipleFields would be set to 'Option1,Option2' on Table_Field1. The LinkFieldName on Table_Field1 would be set to 'Table_RecordType'. The HideFields on Table_RecordType would be set to 'Option 1=Table_Field1_Option1,Option 2=Table_Field1_Option2'.
MultipleOrdered - Flag setting for a ComboBox, when set to 'Yes,' it will convert a normal multi select list to an ordered selection list. The new widget has two (2) areas: one for available options and the other one for selected options. The selected options can be ordered so, when saved, the order persists.
MultiSelectDates - Flag setting to transform a CharacterFillin field to be a multi-date select widget allowing multiple dates to be selected, which populate the CharacterFillin input text as a list of date values delimited by a commas (i.e. 10/11/2020,04/10/2020,12/12/2020).
N
NewLine - Used to wrap a field and label in a "line" wrapper. This allows for columns to be created. All fields are automatically part of a "NewLine," but buttons are not.
NewRoutine - Defines a Query String to execute when a request includes the parameter NewRoutine=ThisFieldName. Essentially, this is a way to programmatically initiate a second UI Operation (re-run RequestStart.p to startup a new Routine/Action/SubAction) upon completion of a UI Operation.
NoResultsLabel - Sets a default message for a FieldTable in WebTrac when no results are found. The message will appear where the field table would go.
NumberOfNights - Sets an integer value for a ComboBox field determining the "up to" value of how many nights a user may select.
NumberPicker - Defines a list of values that determine a range of allowable values for a NumPicker field, depending on the extension. Each entry has three (3) entries with an & seperating them. 1=Extension, 2=Min Value, 3=Max Value.
For Example: px&0&9999,%&0&100 would allow for 0-9999 when pixels are selected and 0-100 when percent is selected. This combines the number with the extension when being saved.
O
OnChangeEvent - When set, this allows a field (fillin, textarea, combobox, etc.) when changed to send a communication to the server to process something. The value of this field parameter should be the routine, action, subaction you want to run on the business logic side. For Example: SubAction=FieldChanged will run that particular subaction and the UI will pass all current values on the screen to the that particular sub action.
OnEnterClick - Flag setting on a Button field to cause this Button to automatically generate a click event when the ENTER button is pressed on this Screen.
OptionDelimiter - Sets a character value that will act as the delimiter for the option list and option labels on a ComboBox field.
OptionLabels - Used in conjunction with OptionList. Sets the label value for each option in a ComboBox field.
OptionList - Used in conjunction with OptionLabels. Set a list of option values for a ComboBox field.
OptionListAll - Sets the first value on a ComboBox field to have a value of blank, with a label defined by the value of this field parameter. This has a number of benefits instead of updating the OptionList and OptionLabels field parameters.
- This option will ALWAYS be the first option in the list regardless of sorting of the Options.
- If the ComboBox lists are dynamically created, then it can be added as the default first option without any need to update code.
- When set with a required ComboBox, then it will require a value to be selected before continuing and the label and be something like "---Select a Value---."
OptionSort - Sets the sorting method for the items listed in a ComboBox field. This can be set to one of the following options:
- Label, Label-Asc, Label-Desc
- When set this way, it will order based off the OptionLabels values.
- When set as -asc or -desc, it will order based off Ascending or Descending label order.
- When set to Label will be in Ascending order by default.
- Value, Value-Asc, Value-Desc
- When set this way will order based off the OptionList values.
- When set as -asc or -desc will order based off Ascending or Descending value order.
- When set to Value will be in Ascending order by default.
- Order, Order-Asc, Order-Desc
- Order is the DEFAULT when no option is selected!
- When set this way will order based off the default order of the OptionLabels/OptionList values.
- When set as -asc or -desc will order based off Ascending or Descending order.
- When set to Order will be in Ascending order by default.
- This option is based off the FieldParameter value order, so it does NOTHING to the order when set to Order or Order-Asc.
OutputLinkOption - Settings to control which reports are available on a report Screen.
- ALL - Any reports which use the same base table as the Screen will appear in the list.
- DIRECT - Only the reports which have their RunFromScreenName value set to this Screen will appear in the list.
OutputProcedure - Designates the name of a procedure (.p file with extension included) to run to generate the data for this cell in a DataGrid.
OverrideParameters - Overrides certain UIData GetData values based upon other UIData GetData values. The format for this field parameter is two lists of name=value pairs delimited by ampersand (&). The two (2) lists are separated by a comma. The first list of name=value pairs are the criteria which must all be met in order to apply the override values listed in the second list. This allows for field parameters to be overridden when specific data is passed in on a request.
- For Example: UIData: MultiSelect=Yes
- OverrideParameters: MultiSelect=Yes&TotalSelect=0,RequiredSelect=0
When MultiSelect=Yes is passed into this program and say a DataGrid with the OverrideParameters setting like above is found it will replace the TotalSelect and RequiredSelect parameters to those in that list.
P
PermissionOverrideField - Sets the field name of the field in the Permissions profile to check against to determine whether this field should be allowed or not.
PermissionOverrideParams - Defines a query string of parameters to send to the server to check the field against. If this is set and the field is 'ViewOnly' or 'Disabled,' then it will REQUIRE permissions override by a user.
PermissionsOverrideValue - Flag setting to turn the Permissions Override 'Off' on an input field. This is used in conjunction with PermissionOverrideParams and is, by default, blank but can be set in the code to 'No,' which will stop the override logic from showing on the UI. This does nothing if PermissionOverrideParams is not set.
PicklistAutoFocus - Flag setting for a PicklistFillin field. When set to 'Yes,' it will auto-focus on the first autocomplete record in the Picklist autocomplete dropdown.
PicklistAutoMinChars - Sets the number of characters needed to be entered on a PicklistFillin field before an autocomplete can be requested from the server.
PicklistAutoURL - Defines the query string to send to the server for an autocomplete drop down to populate. Query String should be Routine/Action/SubAction and also the table_field for the VSIDataSub to get to determine the query.
Q
Query Procedure - Used in conjunction with DefaultAddRecordQuery to define a procedure (located in Business/) which will output the DefaultAddRecordQuery value for this field.
R
ReportDetailFontAlign - Determines whether the Report Detail Record will print Left, Center, or Right Aligned within its column on a REPORT.
Note: IntegerFillin, DecimalFillin, and CurrencyFillin field types will always align Left, even if this value is set to a different alignment.
ReportDetailFontColor - Sets the color which the detail records will print in for this field on a REPORT.
ReportDetailFontFamily - Sets the font which the detail records will print in for this field on a REPORT.
ReportDetailFontSize - Sets the font size, in points, that the detail records will print in for this field on a REPORT.
ReportDetailImage - Flag setting to specify that this image's field value is the name of a blob file which holds the image data.
ReportDetailIndent - Sets the percentage width of the column to indent the printed text for this field's value.
Note: This field param is used only if the field alignment is set to 'Left.'
ReportDetailLabel - Sets the label of the column for this field when this field is used in a report. REPORT ONLY.
ReportDetailLineNumber - Sets the line number (row) for this particular record that this field should output to. REPORT ONLY.
ReportDetailLongRow - When this field is linked to a default VSIReportOutput record, and this field parameter is set to 'Yes,' it will require the field to take up a full row. Users should receive a message indicating this when adding a field with this param value of 'Yes' to a report. Any existing fields in the row will be removed from the report.
ReportDetailLongRowProcedure - Setting used in conjunction with ReportDetailLongRow. It will be considered only if ReportDetailLongRow is set to 'Yes.' Designates a delegate procedure (full .p file name) to handle the special formatting, which will be needed for constructing a PDF document with the given field taking up a full line.
ReportDetailPrintConsecutive - Formatting setting to determine whether a detail field should print if the value for the current row is the same as the previous row.
For Example: Running a Household Visit Report you would probably only want to print the Household Information once for every change in the Household.
ReportDetailQuestionListIndividual - Select a question whose answer will be printed in a report. This setting only applies only to the fields SADetail_QuestionAnswer1 thru SADetail_QuestionAnswer15. This field param will be displayed in Report Output Maintenance as a Picklist of Master Question Records. This is a single select Picklist and requires an answer.
ReportDetailQuestionListMultiple - Select a set of questions whose answers will be displayed in a report. This setting only applies only to the fields TableName_QuestionTextMultiple and TableName_QuestionAnswerMultiple. This field param will be displayed in Report Output Maintenance as a Picklist of Master Question Records. This is a multi select picklist and requires an answer.
ReportDetailRecordCount - Setting to make the subtotal to only count unique values when ReportDetailSubTotal is set to something other than NA. When it is set to FIRST, it counts the first unique value of this field rather than ALL. REPORT ONLY.
ReportDetailSubTotal - Placed on an input field to determine whether this field should be sub totaled (set to NA if not) and how it should be sub totaled. Options are Sum, Count, and Average. REPORT ONLY.
ReportDetailSubTotalBy - Used in conjunction with ReportDetailSubTotal. This is a list of sorted table_field names. The list of available fields are those that are set to output on the screen AND have a sort order. REPORT ONLY.
ReportDetailSubTotalPrimarySort - Applies to Summary outputs only. Specify that this field's subtotal values will sort the report such that those subtotal sections are sorted by subtotal value.
ReportDetailSubTotalPrimarySortDirection - Used in conjunction with a field set to 'Yes' for ReportDetailSubTotalPrimarySort. Determines whether sort direction will be ascending or descending.
ReportDetailText - For default widget text field, sets a static text value which will print in this field for every report where it is used in the report detail.
ReportDetailUnique - For every field with this flag set to 'Yes,' those fields collectively form a unique key where any duplicate rows with those same values will be skipped. REPORT ONLY.
ReportDetailWidth - The percentage width of the column when this field is used as a detail field in a report. REPORT ONLY.
ReportDetailWrapText - Determines whether this field's value should be wrapped to the next line or trimmed when it is too large to fit in the detail column on a REPORT. Values are 'Yes/No.' Default value is always 'No,' which will Trim the value and display only what will fit in the column. Setting this value to 'Yes' has a noticeable impact on report speed. Reports with Wrap Text will take longer than reports without.
ReportFavoriteTables - List of tables for which this field should show up as a favorite (it will appear at the top of the list of available fields with a star next to it).
ReportHeaderFontAlign - Determines whether the Report Page Header will print Left, Center, or Right Aligned within its column on a REPORT.
ReportHeaderFontColor - Determines the color the Page Header records will print in for this field on a REPORT.
ReportHeaderFontFamily - Determines the font the Page Header records will print in for this field on a REPORT.
ReportHeaderFontSize - Determines the font size in points the Page Header records will print in for this field on a REPORT.
ReportHeaderIndent - Sets the percentage width of the column to indent the printed text for this field's value when used in a Page Header.
ReportHeaderLabel - Sets the label for this field when used in a page header when this field is used in a report. REPORT ONLY.
ReportHeaderLineNumber - Sets the line number (row) for this particular record that this field should output to when in the page header. REPORT ONLY.
ReportHeaderText - For default widget text field, sets a static text value which will print in this field for every report where it is used in the page header.
ReportHeaderWidth - Sets the percentage width of the column when this field is used as a page header field in a report. REPORT ONLY.
ReportHeaderWrapText - Determines whether a field's value should be wrapped to the next line or trimmed when it is too large to fit in the header column on a REPORT. Values are 'Yes/No.' Default value is always 'No,'which will Trim the value and display only what will fit in the column. Setting this value to 'Yes' has a noticeable impact on report speed. Reports with Wrap Text will take longer than reports without.
ReportOutput - Report Output is not a real field parameter. It just displays in screen maintenance as an uneditable informational field to communicate the report header's description value.
ReportOutputHelp - Defines report specific help text which displays when hovering over an this field when it is available.
ReportSortDirection - Sets the sort direction on a field which has a record type of reportsort.
ReportSortFontColor - Determines the text color of the Subtotal values which will print for this field on a REPORT.
ReportSortFontFamily - Determines the font of the Subtotal for this field when used in a REPORT.
ReportSortFontSize - Determines the font size of the Subtotal for this field when used in a REPORT.
ReportSortNewPage - Flag value to cause a page break on pdf output for every instance where this field's value changes. This is applied only when this field has a sort order on it. REPORT ONLY.
ReportSortPrintColumnHeader - Determines whether the Detail Column Header should print on change in value of this field when sorted.
ReportSortPrintLines - Determines the number of horizontal lines to print on change in value of this field when sorted. Value is an integer; default value is '0.' If printing lines would cause the report to move to a new page then lines are not printed.
ReportSortPrintSortHeader - Determines whether the Sort Header should print on change in value of this field when sorted. Value is logical Yes/No and default is always 'No.' Typically a customer would set this on their Primary or Secondary sort if they are using Sort Headers. It is not advised to place set this value to 'Yes' on a sort that comes prior to any field that included in the Sort Header.
For Example: Sorting a report by Activity Category, Type, SubType, ActivityCodeSort Header has Type Description and SubType Description. Printing the Sort Header on the Type sort would not make sense since the SubType could change before the next SortHeader prints and the SubType description is part of the SortHeader.
ReportSortSkipLines - Determines the number of lines to skip on change in value of this field when sorted. Value is an integer; default value is 0. If skipping lines would cause the report to move to a new page the report simply moves to the next page and does not skip any additional lines.
ReportSortSubTotalLabel - The label of the Subtotal for this sort field when it is used in a report. The special string <SortValue> may be used to make the label display the value of the sort field.
ReportSubHeaderFontAlign - Determines whether the Report Sort Header Records will print Left, Center, or Right Aligned within its column on a REPORT.
ReportSubHeaderFontColor - Determines the color the sort header records will print in for this field on a REPORT.
ReportSubHeaderFontFamily - Determines the font the sort header records will print in for this field on a REPORT.
ReportSubHeaderFontSize - Determines the font size in points the sort header records will print in for this field on a REPORT.
ReportSubHeaderIndent - Sets the percentage width of the column to indent when used in a sort header.
ReportSubHeaderLabel - Sets the label of the sort header when this field is used in a report. REPORT ONLY.
ReportSubHeaderLineNumber - Sets the line number (row) for this particular record that this field should output to when in the sort header. REPORT ONLY.
ReportSubHeaderText - For default widget text field, sets a static text value which will print in this field for every report where it is used in the sort header.
ReportSubHeaderWidth - Sets the percentage width of the column when this field is used as a sort header field in a report. REPORT ONLY.
ReportSubHeaderWrapText - Determines if a fields value should be wrapped to the next line or trimmed when it is too large to fit in the sort header column on a REPORT. Values are: Yes/No
Default value is always NO which will Trim the value and display only what will fit in the column. Setting this value to 'Yes' has a noticeable impact on report speed. Reports with Wrap Text will take longer than reports without.
ReportTotalBy - Defines a Field Name by which this field, when used as a total field, should use to determine the total values.
ReportTotalByLabel - Used in conjunction with ReportTotalBy, set the label for the TotalBy column when this field is being totaled by the value of another field. REPORT ONLY.
ReportTotalByOption - Defines how the ReportTotalBy field will be grouped. Options include:
- NA - No grouping, total all records.
- Total By Value - Total for each same value.
- Day of Week - Total per day of week.
- Month - Total per month.
- Year - Total per year.
Note: Day of Week, Month, Year may be used only if the TotalBy field is a date field. REPORT ONLY.
ReportTotalFontAlign - Determines whether the Report Total Record will print Left, Center, or Right Aligned within its column on a REPORT.
Note: If Right alignment is set, then only the value column will be aligned Right.
ReportTotalFontColor - Determines the color the report total records will print in for this field on a REPORT.
ReportTotalFontFamily - Determines the font the report total records will print in for this field on a REPORT.
ReportTotalFontSize - Determines the font size in points to print in for this field when it is used as a report total record on a REPORT.
ReportTotalLabel - Sets the label of the Total field for this field when it is used in a report. REPORT ONLY.
ReportTotalLineNumber - Sets the line number (row) for this particular record that this field should output to when in the report totals. REPORT ONLY.
ReportTotalOption - Defines the method by which this field is calculated when this field is set as a Total Field. Options include: Sum, Count, Unique Count, Average, High, Low, Median, and Range. REPORT ONLY.
ReportTotalOptionOperator - Used in conjunction with the ReportTotalOptionVariable and ReportTotalOptionVariableField field params to filter by criteria on a record before including it in the report total. This is the operator that will be used to compare the database value to the variable value.
For Example: On a Trial Balance Report you may have a Total Due field. If in the Report Total area you want to get a count of the patrons who have a Total Due greater than or equal to $ 100.00,then you would link the following field params to the ReportTotal record: ReportTotalLabel = Households With Min $100 BalanceReportTotalOptionOperator = GEReportTotalOptionVariable = 100.
ReportTotalOptionVariable - Used in conjunction with the ReportTotalOptionOperator field param to filter by criteria on a record before including it in the report total. This is the value that will be used to compare with the database value.
For Example: On a Trial Balance Report you may have a Total Due field. If in the Report Total area you want to get a count of the patrons who have a Total Due greater than or equal to $ 100.00, then you would link the following field params to the ReportTotal record: ReportTotalLabel = Households With Min $100 BalanceReportTotalOptionOperator = GEReportTotalOptionVariable = 100.
ReportTotalOptionVariableField - Used in conjunction with the ReportTotalOptionVariable and ReportTotalOptionOperator field params to filter by criteria on a record before including it in the report total. This is the value that will be used to define the table field that will be compared with the ReportTotalOptionVariable value.
For Example: On a Trial Balance Report you may have a Total Due field If in the Report Total area you want to get a count of the patrons who have a Total Due greater than or equal to $ 100.00, then you would link the following field params to the ReportTotal record: ReportTotalLabel = Households With Min $100 BalanceReportTotalOptionOperator = GEReportTotalOptionVariable = 100.
ReportTotalWidth - Sets the percentage width of the column when this field is used as a total field in a report.
Note: This field param will only be applied if there is no TotalBy field param value set on the report. REPORT ONLY.
RequiredSelect - Defines a number representing how many rows are required to be selected for this DataGrid when it is submitted. 0 = None, 1+ means that number of rows. This parameter is the default for the DataGrid but each Button can override this parameter on the UI side when clicked based off of the Click.Datagrid setting.
Note: This field parameter is a duplicate of field parameter RequireSelect, both work the same.
RequiredSelectOption - Sets a logical operator in conjunction with the RequireSelect value to set rules for how many selected rows, such as greater than 1, less than or equal to 5, etc. If not set, then the default is Equality.
RequireFields - Sets a list of value=field&field&field. When the value of the field equals one of the values it will go through all of the fields after the equals and REQUIRE them while all other value fields will be UNREQUIRED.
For Example: Table_RecordType values are Option 1 and Option 2. When 'Option 1' is selected I want to REQUIRE Table_Field1 and Table_Field3 but UNREQUIRE Table_Field2. When 'Option 2' is selected I want to REQUIRE Table_Field2 but UNREQUIRE Table_Field1 and Table_Field3. The Parameter would look like this:
Option 1=Table_Field1&Table_Field3,Option 2=Table_Field2.
RequireSelect - Defines a number representing how many rows are required to be selected for this DataGrid when it is submitted. 0 = None, 1+ means that number of rows. This parameter is the default for the DataGrid but each Button can override this parameter on the UI side when clicked based off of the Click.Datagrid setting.
Note: Field parameter RequiredSelect is a duplicate of this field parameter, both work the same.
ResultsCountByPrimaryCode - Can be enabled or disabled. When enabled, the search will base the count, totals, ResultsPerPage, etc. off of the primary Code. When off, it will do what it normally does. For example, ARWebSearch -> Tab1 -> Group4 -> Output_Table. If enabled, it would base off the activity code. If disabled, it would count every section in counts, totals, ResultsPerPage, etc.)..
ResultsLabel - Sets the label that is used as the header of the table in WebTrac for the results.
ResultsLabelPosition - Set where the header will display either above, below, or both for this WebTrac Table.
ResultsMax - Determines how many records to return for paging in the WebTrac Table of results.
ResultsPaging - Determines whether the paging for a WebTrac Table should be a number list or just arrows for Previous, Next, First and Last.
ResultsPerPage - Determines how many records to show per page of a WebTrac Table of results.
ResultsShowingLabel - Sets the label that appears at the top of the WebTrac Table of results which shows what the current start and end result are. Uses codes <StartResult> and <EndResult> to replace with real values.
ResultsTotalLabel - Sets the label that displays at the top of WebTrac Table of results which shows what the current total records are. Uses <TotalResults> as the code that is replaced with the total.
ReturnValue - Defines a list of ValueReturned=GetData Values which will get returned from the new screen which will be opened as a result of this button being clicked. When attached to a button this looks through this list in the ReturnValue procedure (maintenance.p) and returns the entry1=getdata(entry2) for each entry in this list.
RolodexMinHeight - Sets a minimum height for a Rolodex, so that it does not get too small and useless.
RolodexPopupCloseOnSelect - Set to true if the rolodex popup should close when an item is selected.
RolodexSearchable - Set to true to show a search bar.
RowGrouping - Place a table_fieldname on a DataGrid that matches up to a column that should have its values grouped together.
RowGroupingDirection - Sets the default direction of grouping sorting on this DataGrid. Either Asc for Ascending order or Desc for Descending order.
RowGroupingOpened - Flag setting to control whether groups within a DataGrid should be collapsed when the DataGrid is loaded. If set to 'No,' then the DataGrid will default to the groups collapsed when it loads.
Rows - Sets the number of rows by default in an Editor field. This is number of lines based on the size of the font going down.
Note: This is used only in a regular editor. Does not work for HTML Editor.
S
ScreenRequired - Flag setting. When set to 'Yes,' it will require the field to be on a screen and not allow it to be removed within Screen Maintenance.
ScreenTitle - When a screen is built, it looks through all of the fields with this parameter and gets the value of each of the fields on the screen in the order that they show up on the screen. Then uses those values to build the Panel Header or Panel Tab label (the value of this field parameter determines which of those two labels, if either, are affected by this field). Uses a dash - in between values. This is then appended to the end of the regular screen title.
For Example: Activity Update - 100000 would be the label for Activity Update as ARActivity_ActivityNumber field has this set.
SearchFirst - Determines how a DataGrid pulls data when it loads.
- Yes - Pulls a smaller section of data so the DataGrid loads faster. Uses the SearchFirstInitialMax value to determine number or records pulled. Additional records can then be loaded.
- No -Pull all data so the DataGrid loads more slowly. No need to pull additional records.
- Indexed -Sets the DataGrid so only indexed fields in the database are able to be sorted/filtered until all results have been fetched.
SearchFirstInitialMax - Sets the number of records to fetch upon loading this DataGrid. This is to be used in conjunction with the SearchFirst field parameter. This is basically just saying don't fetch more than <'x> records when doing a no filtered search first.. For Example if you enter '500,' then it will not fetch more than 500 records.
Note: If there are fewer records than the number entered, then it has no affect. The default value is 500.
SearchFirstInitialSelect - Flag setting. When set to 'Yes' it will fetch the selected results of the DataGrid on the first load instead of all records. This is used for memorized report DataGrids that have had values selected. Instead of getting the results where the selected values may not exist, this just fetches the selected so the user knows which ones are actually going to be used.
SearchOptionOrder - Setting used in WebTrac Search for the criteria fields that use system codes. This sets what order to show..
SearchOptionTable - Defines the table from where values which need to be fetched for criteria fields in WebTrac Search. This then runs WebSearchOptions.p where we do all of the option lists and labels.
SearchOptionType - Setting used in WebTrac Search for each of the criteria fields that need to fetch database values from SASystemCode and this is the Record Type of the SASystemCodes to fetch. This is run in WebSearchOptions.p.
SelectFieldName - This is used for the DataGrid when making a selection. This parameter is the field to used to determine the value of a row. This works in conjunction with the SelectName field parameter when sending data to the back end when a button is clicked.
For Example: Datagrid data of: table_id = 1234, table_description = 'Description,' etc. SelectFieldName = table_id and the SelectName = RecordIDWhen a button is clicked the name=value pair sent to the server would be RecordID=1234.
SelectName - Defines the name in the name=value pair for the DataGrid row ID when using the DataGrid to select a row to pass to the server. For Example RecordID=123456.
SendValue - Flag value. When this is set to 'Yes,' this field will ALWAYS send its value back to the server. This is needed because when a field is disabled it does not send the value back to the server. To override this behavior this parameter must be set to 'Yes.'
ShowFields - Defines a list of values for this field, which if this field is set to, will show a set of other fields on this screen. The format is a comma-delimited list of value=field&field&field. When the value of the field equals one of the values it will go through all of the fields after the equals and SHOW them while all other value fields will be HIDDEN. The value must be exact including any spaces or special characters. The special keyword <<ALL>> can be used to enable a set of fields for any non-blank value.
For Example: Table_RecordType values are Option 1 and Option 2. When 'Option 1' is selected I want to SHOW Table_Field1 and Table_Field3 but HIDE Table_Field2. When 'Option 2' is selected I want to SHOW Table_Field2 but HIDE Table_Field1 and Table_Field3. The Parameter would look like this:
Option 1=Table_Field1&Table_Field3,Option 2=Table_Field2.
ShowFooter - Flag setting to show the footer header row at the bottom of a Table or DataGrid.
ShowOuterCalendar - Flag value. When set to 'Yes,' it will create an additional row and column on the top and left of the calendar that buttons can be added for week/weedkday processing. This is used for the Day Care calendar in RecTrac to add the week and weekday selection buttons.
ShowToolbar - Flag setting to Shows/Hide the header (with buttons) of the DataGrid. If not showing, then it will hide the whole header and all the buttons.
Size - Sets the size in character count that show by default in an input field. This is used by default when no width is set on the field itself and should normally be set rather than the width.
SkipDatagridCache - Flag setting to force the DataGrid to not use cache and build the DataGrid every time it is created.
SkipSavingCurrentProfile - Flag value. When set to 'Yes' or 'True,' it will not save the current profile to the SubSession. This will keep the DataGrid from loading a previous profile that may not be needed.
For Example: I set a filter on a column and then proceed to the next screen. After finishing on that new screen I go back to the DataGrid screen. When this OFF, the filter will still be there. With this ON, it will be back to the normal settings. This is helpful on screens, such as Household Lookup were a name might be entered into a filter but when going back to that same Household Lookup screen you don't want that same filter applied.
StartOnWeekday - Sets which day of the week to display first on each row within a GUI Calendar.
StripHTML - Flag setting to remove all HTML tags from the text within a DataGrid column.
T
TabIn - Indent an input field to the right by up to five (5) levels (50px per level).
TabIndex - When tabbing through all of the fields on a screen this number determines the order. The tab index should be incremented by one for the next field(s).
TemplatesOnToolbar - Flag setting. When set to 'Yes,' it allows showing of the Templates button in the DataGrid header allowing quick access to DataGrid templates.
TableCollapse - For WebTrac. It has options "None, Hide," and "Show." Setting it to hide or show should turn on the table collapse. When it's on, you can click the table header (In this case arwebsearch activity heading) and it will expand or collapse the activity to show the table (In this case sections). Example: ARWebSearch->Tab1->Group4->Output_Table)
TempTableOptionList - Up to four (4) entries in a comma-delimited list that determine the temp table to use, the value field, the label field, and optionally to define the delimiter for the list (default is comma).
For Example: TTFetch,xValue,xLabel will create OptionList and OptionLabels based on the TTFetch temp table handle (created using SetDataHandle) using the xValue field for the OptionList and the xLabel field for the OptionLabels.
TextAlignment - Sets the text alignment on an input field. Leaving the value blank will fallback to the field default setting, which is normally LEFT except for Currency/Decimal/Integer which is RIGHT.
TimeInterval - Sets the interval (in minutes) for a TimeFillin field. Defaults to 15 minutes showing every 15 minutes from the start to end time.
TimeSelect - Flag setting. When set to 'Yes,' will turn a CharacterFillin to a time select field allowing for time intervals or fixed times to be selected. Mainly used in Reports.
TitleDescription - Sets which description field value (long or short) to use for the title of a detail record in WebTrac.
Tooltip - Sets the tooltip text value for this field when mouse-hovering over it.
TooltipField - Set a Table Field Name from which to retrieve the tooltip value for this field from the database. This is used in conjunction with the PicklistTipURL to pull a field from a record to the UI for display purposes.
TotalSelect - Sets the number of rows in a DataGrid available to be selected. -1 = None, 0 = Unlimited (multi-select), 1=Single Row, 2+=Singe row or more. This parameter is a global DataGrid parameter and can be overridden by a button click by using the Click.DatagridOptions paramater.
TouchScreen - Set on a TAB and determines whether this tab and all groups under it should be considered a touch screen grouping. This will hide all the groups except for the first group unless the TouchScreenDefault field parameter is set with a group to show initially.
U
UnavailableLabel - Sets the text for the label that will display for an unavailable item in WebTracGraphical.
UnRequireFields - Sets a list of value=field&field&field. When the value of the field equals one of the values, it will go through all of the fields after the equals and UNREQUIRE them while all other value fields will be REQUIRED.
For Example: Table_RecordType values are Option 1 and Option 2. When 'Option 1' is selected I want to UNREQUIRE Table_Field1 and Table_Field3 but REQUIRE Table_Field2. When 'Option 2' is selected I want to UNREQUIRE Table_Field2 but REQUIRE Table_Field1 and Table_Field3. The Parameter would look like this:
Option 1=Table_Field1&Table_Field3,Option 2=Table_Field2.
UploadAllowedExtensions - Comma-delimited list that defines the allowed file extensions to be used during the uploading of a file using the file upload widget. For Example: jpg,gif,png.
UploadLocation - Sets the location which is put at the beginning of a file being uploaded via the upload widget. This will be the location that the file will eventually end up in the BLOB record.
UploadRestrictExtensions - Defines a list of file extensions to limit the file upload widget with. This is the opposite of the UploadAllowExtensions in case you want to exclude a few different types instead of needing to know all file extensions to allow.
UploadURL - Sets a query string which specifies what action to call when this File Upload field uploads a file.
V
Validation - When set to 'Yes,' the validation happens both on the UI side and on the save of the record. When set to 'OnSave,' the validation happens ONLY on save. 'No' or <blank> means no validations occur.
ValidationDataType - This is used when validating and saving a picklist field that has data substitution enabled. For Example: Your database field is an ID (int64) but you do a data substitution to convert it to a character value when it goes to the UI. When saving, it tries to validate the character value as an int64 value which is WRONG; it should validate it as a character, so this overrides the datatype to the proper Character datatype.
ValidationProcedure - Designates a validation procedure to handle the validation of this field. This gets used for both the UI and the OnSave portions. Note that during a UI validation you ONLY have access to the single value of the field were as during the OnSave you have access to all values which will make it different in how the validation procedure works.
ValidationReturnField - This should be the same table as the PicklistField parameter but the field should be the field want the value of returned for data substitution reasons. If this is left blank, then it will always return to current field value instead of doing a substitution.
ValidationURL - Sets a query string of extra name=value pairs to send to the server during a UI side validation.
ValidCharacters - Defines a set of allowable characters to be entered in this field. Two values are provided, where the first is the name of a predefined group of characters (alpha, numeric, alphanumeric, alphaSpaces, numericSpaces, alphanumericSpaces), and the second is a set of specific characters which are also allowed in addition to the predefined set.
VariableFieldProcedure - Designates a procedure to be called to set the value of this field. The procedure named must have an input-output param of a character value, an input parameter of datatype and an output parameter of a logical value (a flag to signal if procedure was successful). This is used in conjunction with VariableFieldValue.
VariableFieldValue - This is a value that is used in conjunction with VariableFieldProcedure to convert to a specific progress value. For Example: TODAY or CURRENTTIME would get the current date or time. This is all based on the procedure to run.
W
WeekDayLabels - Defines a list of labels to assign to each day in a GUI Calendar.
Width - Sets the width of this field in pixels or percent.
WrapLine - Flag setting. If set to 'Yes,' the group will wrap the contents of the group with a line and all fields with a line. This is only used when you want multiple fields on a single line without using columns. In other words it isn't used often.
Y
Year - Sets the default year on the calendar in RecTrac (Day Care).
YearEnd - Determines the number of years after the current year to show in a ComboBox, which is set to show a list of years.
YearEnd - Determines the number of years before the current year to show in a ComboBox, which is set to show a list of years.