PopupMenuField

Tags:

HistoryUpdated Mar 5, 2010 11:51 AM by wendy…

PopupMenuField sets a nominated field on the Parent table to the value selected from the Popup menu and optionally runs a script.

Syntax

PopupMenuField( valueListOptions ; fieldName {; script ; status ; bgColor})

Parameters

1	valueList*	The list of values in the Popup menu. See note below.
2	fieldName	The name of the field to receive the chosen value. This must be in quotes and be the full TableOccurrence::FieldName form.
3	script (opt)	Name of the script to run when the user selects a value.
4	status (opt)	Text or name of a field containing “enabled” (the default), “disabled”, or “hidden”, or a calc which returns one of those 3 values. When hidden, the popup menu disappears from view. When disabled, it does not run the script, but still sets the nominated field.
5	bgColor (opt)	Default is white, but you can specify the color: see “Background Color” in the “Basics” section.

Example

PopupMenuField (

"Details¶Contacts¶Enrolments¶Reserves¶Courses"; // Value List

"Test::MyField" ; // fieldName

"Choose People Tab Set" ; // script

"enabled" ; // status

"white"// bgColor

Notes

At present, the nominated field cannot be on a related table.

* The Value List can be:

a simple text list e.g. "Details¶Contacts¶Demographics"
a reference to a Value list e.g. ValueListItems ( “DemoFile” ; “Tab Choice” )
or, if you wish to differentiate what the user sees from the actual value, you can use the following syntax to pass back an ID equating to the literal value: "Values=John¶Mary¶Sam"&"IDs=524¶768¶231"