Skip to main content

Forms and filter

reloadFormPanel(panelid, args)​

where XXX is the form identifier (CON12) - reload the form content

var args = new Object();
args['INPUT_PARAM'] = 'EXAMPLE';

reloadFormPanel603(args);

getFormPanelLabel(panelid, attr)​

where XXX is the form identifier (CON12) and attr the name of the attribute which identifies a specific input field - returns the textof the input field label or button of the form panel

setFormPanelLabel(panelid, attr,value)​

where XXX is the form identifier (CON12) and attr the name of the attribute which identifies a specific input field - set the specified textin the input field label or button of the form panel

getFormPanelValue(panelid, attr)​

where XXX is the form identifier (CON12) and attr the name of the attribute which identifies a specific input field - returns the value currently set on the input field of the form panel

getFormPanelAddressValue(panelid, attr)​

where panelid is the form identifier (CON12) and attr the name of the attribute which identifies a specific input field, the input type must be an address autocomplete fields. - returns the selected address components string in JSON format

\{
"administrativeAreaLevel1": "Lazio",
"administrativeAreaLevel1Short": "Lazio",
"administrativeAreaLevel2": "Città Metropolitana di Roma",
"administrativeAreaLevel2Short": "RM",
"administrativeAreaLevel3": "Roma",
"administrativeAreaLevel3Short": "Roma",
"country": "Italia",
"countryShort": "IT",
"locality": "Roma",
"localityShort": "Roma",
"route": "Via del Corso",
"routeShort": "Via del Corso",
"streetnumber": "1",
"streetnumberShort": "1"
\}
var addressJSONString = getFormPanelAddressValue(4819,"txtAddress");
var addressMap = JSON.parse(addressJSONString);

setFormPanelValue(panelid, attr,value)​

where XXX is the form identifier (CON12) and attr the name of the attribute which identifies a specific input field - set the specified value in the input field of the form panel

setVisibleComponent(panelid, attr, visible)​

Set the visibility state for the input control belonging to the panel recognized by panelid, identified by the attribute name. The second argument can have the values "Y" or "N", used to set the visibility

setVisibleComponent(123, "controlName","Y");
or
setVisibleComponent(123, "controlName","N");

insertFormPanel(panelid)​

where XXX is the form identifier (CON12) - switch the form in insert mode

saveFormPanel(panelid)​

where XXX is the form identifier (CON12) -save the content of a form panel (which can be in insert or edit mode)

clearSearchFilterPanel(panelid)​

where XXX is the filter panel identifier (CON12) – clean the components of panel

applySearchFilterPanel(panelid)​

where XXX is the filter panel identifier (CON12) – apply the filter conditions of panel to linked grid

setEnabledPanelButton(panelid, buttonId, enable)​

Enable or disable the button in panel

Required arguments:

ArgumentDescription
XXXpanel identifier
buttonIdkey of button component
enableY/N for enable of disable

setFormPanelMaxLength(panelid, attr,value)​

Set the max length for an input text.

Required arguments:

ArgumentDescription
XXXpanel identifier (CON12)
attrthe name of the attribute which identifies a specific input field
valuethe max lenght for the text

setFormPanelPlaceholder(panelid,attr,placeholder)​

The placeholder attribute specifies a short hint that describes the expected value of an input field (e.g. a sample value or a short description of the expected format).
The short hint is displayed in the input field before the user enters a value.

Required arguments:

ArgumentDescription
panelidpanel identifier (COM12)
attrthe name of the attribute which identifies a specific input field
placeholderis the short hint that describes the expected value of an input field

setPanelOptionalParameter(panelid, parName, value)​

Set the optional parameter for panel grid or detail

Required arguments:

ArgumentDescription
XXXpanel identifier
parNamename of parameter
valuevalue to set for parName

getPanelOptionalParameter(panelid, parName)​

Return the value of optional parameter of panel grid or detail ()

Required arguments:

ArgumentDescription
XXXpanel identifier
parNamename of parameter

setFocusByAttribute(panelid, attr, selectAll)​

where XXX is the panel identifier (CON12) and attr the name of the attribute which identifies a specific input field – set the focus on the component

ArgumentDescription
attrfield attribute name
selectAllY/N (optional) - if Y select All
setFocusByAttribute1559("attributeName", "Y");

scrollPanelTo(panelid, x, y)​

where XXX is the panel identifier (CON12), if the panel is scrollable scroll (ex. web preview o grid) the panel to the x and y position specified.

scrollPanelTo559(0, 0); //scroll panel to top

shrinkPanel(panelid)​

Shrinks the panel vertically, removing any empty space after the last component.

ArgumentDescription
panelidpanel identifier (COM12)

Example:

shrinkPanel(123);

resetFormPanelControls(panelId)​

Reset all panel controls positions

setVisibleComponent(attr,visible)​

Set the visibility state for the input control belonging to the current form panel, identified by the attribute name. The second argument can have the values "Y" or "N", used to set the visibility

setVisibleComponent("controlName","Y");
or
setVisibleComponent("controlName","N");

setVisibleComponent(panelid, attr,visible)​

Set the visibility state for the input control belonging to the current form panel, identified by the attribute name. The second argument can have the values "Y" or "N", used to set the visibility

setVisibleComponent("controlName","Y");
or
setVisibleComponent("controlName","N");

forceValidation(attributeName)​

After setting a value to a lookup control, force the validation, by specifying the attribute name identifying the right lookup control.
Required parameters are:

ArgumentDescription
attributeNameattribute name identifying the lookup control where forcing the validation.

setFormPanelControlBackgroundColor(attributeName, hexBackgroundColor)​

Sets the background color of the component.
Required parameters are:

ArgumentDescription
attributeNameattribute name identifying the component.
hexBackgroundColorcolor code in hexadecimal (also with 8 characters for alpha)

before the 6.0.2 version this function name was: setBackgroundColorComponent

setFormPanelControlBackgroundColor(panelId, attributeName, hexBackgroundColor)​

Sets the background color of the component in panel.
Required parameters are:

ArgumentDescription
panelIdid of the panel
attributeNameattribute name identifying the component.
hexBackgroundColorcolor code in hexadecimal (also with 8 characters for alpha)

before the 6.0.2 version this function name was: setBackgroundColorComponent

setFormPanelControlForegroundColor(attributeName, hexForegroundColor)​

Sets the foreground color of the component in the current panel.
Required parameters are:

ArgumentDescription
attributeNameattribute name identifying the component.
hexForegroundColorcolor code in hexadecimal

before the 6.0.2 version this function name was: setForegroundColorComponent

setFormPanelControlForegroundColor(panelId, attributeName, hexForegroundColor)​

Sets the foreground color of the component in panel.
Required parameters are:

ArgumentDescription
panelIdid of the panel
attributeNameattribute name identifying the component.
hexForegroundColorcolor code in hexadecimal

before the 6.0.2 version this function name was: setForegroundColorComponent

pull() ​

Get data from each input control and refresh the value object behind the form/editable panel.

checkMandatoryControls()​

Check the current panel (form or editable panel) for mandatory input controls not filled: when finding one, shows a message dialog with the control name violating the mandatory property. The method returns "true" (no mandatory controls found) or "false" (a string), according to the outcome.

setEnabledComponent(attr, enable)​

Set the enable state for the input control belonging to the current form panel, identified by the attribute name. The second argument can have the values "Y" or "N", used to set the enable

setEnabledComponent(panelId, attr, enable)​

Set the enable state for the input control belonging to the panel, identified by the attribute name. The third argument can have the values "Y" or "N", used to set the enable

getMode()​

Returns the mode (READONLY, INSERT or EDIT) of current panel

setFormPanelCurrency(panelId, attrName, currency)​

where panelId is the panel identifier (CON12) and attrName the name of the attribute which identifies a specific input field – set the specified currency in the input field of the panel

setFormPanelStyle(panelId, attrName, style)​

Since 6.0.2 version

where panelId is the panel identifier (CON12) and attrName the name of the attribute which identifies a specific input field - set the specified style to the field of the panel.

The available attributes for the style object are:

  • mobileControlBorderColor
  • mobileControlBorder
  • mobileBackgroundColor
  • mobileForeColor
  • mobileFontName
  • mobileFontStyle
  • mobileFontSize
  • showCounterChars
  • disableSelfCorrection
  • textStrikethrough
var style = \{
mobileControlBorder: "ALL_ROUNDED",
mobileControlBorderColor : "#FF0000",
mobileFontSize : 14,
textStrikethrough : "Y"
\}
setFormPanelStyle(19, "descriptionIt", style)

getFormPanelVo(panelId)​

Since 6.0.2

Returns the passed panel vo.

addFormPanelControl(panelId,controlArgs,constraints,style)​

Since 6.0.2

Add a control to visible panel, the panel must have a CONSTRAINT layout, absolute layout is not supported.

ArgumentDescription
panelIdpanel identifier
controlArgsthe controls properties
constraintsthe control constraints
stylethe control sytle (see setFormPanelStyle)

controlArgs is a JSON and support this properties:

  • type
  • attributeName
  • label
  • value [OPTIONAL]
  • eventClick [OPTIONAL]: the actionId of the action to call on click event
  • eventChangeValue [OPTIONAL]: the actionId of the action to call on change event
  • eventLostFocus [OPTIONAL]: the actionId of the action to call on lost focus event

Supported controls are:

  • "TEXT_FIELD";
  • "BUTTON_FIELD";
  • "LABEL_FIELD";
  • "LINE_FIELD";
  • "TEXTAREA_FIELD";
  • "IMAGE_URL_FIELD";
  • "IMAGE_PATH_FIELD";

constraints is a JSON, see Constraints for the list of available properties

style is a JSON, see setFormPanelStyle method for the list of available properties

var controlArgs = \{
type : "BUTTON_FIELD",
attributeName : "customButton1",
label : "Bottone 1",
eventClick : 7219
\}
var constraints = \{
"layoutConstraintLeftToLeftOf": "center",
"layoutConstraintTopToTopOf": "center",
"height": 250,
"width": 250
\}

var style = \{
mobileBackgroundColor : "2f4352",
mobileForeColor : "FFFFFF"
\};

addFormPanelControl(279, controlArgs, constraints, style);

setFormPanelDatePickerStyle(panelId, attributeName, style)​

Since 6.0.2

Set the style of a date picker controls.

ArgumentDescription
panelIdpanel identifier
attributeNameattribute name
stylethe control sytle (see setFormPanelStyle)

Style accept the following properties:

  • showNowButton: only works on iOs Picker
  • title: only works on iOs Picker

setFormPanelAnimation(panelId,attrName,options)​

Since 6.0.2

Set the animation for an animation control

ArgumentDescription
panelIdpanel identifier
attrNameattribute name
optionsoptions

Available options are (all options are optional):

  • json: animation json (as an alternative to url or path)
  • url: animation url (as an alternative to json or path)
  • path: animation local path (as an alternative to json or url)
  • cacheKey: optional, cache animation cache key
  • minFrame: [integer] the minimum frame that the animation will start from when playing or looping
  • maxFrame: [integer] the maximum frame that the animation will end at when playing or looping.
  • minFrameMarker: [string] the minimum frame to the start time of the specified marker
  • maxFrameMarker: [string] maximum frame to the start time + duration of the specified marker
  • minProgress: [float] the maximum progress that the animation will end at when playing or looping
  • maxProgress: [float] the minimum progress that the animation will end at when playing or looping
  • repeatCount: [integer] how many times the animation should be repeated. If the repeat count is 0, the animation is never repeated. If the repeat count is greater than 0 or INFINITE (-1), the repeat mode will be taken into account. The repeat count is 0 by default.
  • repeatMode: [integer] This setting is applied only when the repeat count is either greater than 0 or INFINITE. Available value are 1 (RESTART) or 2 (REVERSE)
var options = \{
//json : '\{"v":"5.7.4","fr":25,"ip":0,"op":55,"w":37,"h":24,"nm":"code 2","ddd":0,"assets":[],"layers":[\{"ddd":0,"ind":1,"ty":4,"nm":"Capa 2 contornos","sr":1,"ks":\{"o":\{"a":1,"k":[\{"i":\{"x":[0.833],"y":[0.833]\},"o":\{"x":[0.167],"y":[0.167]\},"t":5,"s":[0]\},\{"t":17,"s":[100]\}],"ix":11\},"r":\{"a":0,"k":0,"ix":10\},"p":\{"a":1,"k":[\{"i":\{"x":0.667,"y":1\},"o":\{"x":0.333,"y":0\},"t":0,"s":[14.823,11.955,0],"to":[-1.354,0,0],"ti":[1.354,0,0]\},\{"t":17,"s":[6.698,11.955,0]\}],"ix":2,"l":2\},"a":\{"a":0,"k":[11.405,14.419,0],"ix":1,"l":2\},"s":\{"a":0,"k":[100,100,100],"ix":6,"l":2\}\},"ao":0,"shapes":[\{"ty":"gr","it":[\{"ind":0,"ty":"sh","ix":1,"ks":\{"a":0,"k":\{"i":[[0,0],[0,0],[0,0]],"o":[[0,0],[0,0],[0,0]],"v":[[3.904,6.919],[-3.904,0.001],[3.904,-6.919]],"c":false\},"ix":2\},"nm":"Trazado 1","mn":"ADBE Vector Shape - Group","hd":false\},\{"ty":"st","c":\{"a":0,"k":[1,0.4,0,1],"ix":3\},"o":\{"a":0,"k":100,"ix":4\},"w":\{"a":0,"k":3,"ix":5\},"lc":2,"lj":2,"bm":0,"nm":"Trazo 1","mn":"ADBE Vector Graphic - Stroke","hd":false\},\{"ty":"tr","p":\{"a":0,"k":[11.405,14.419],"ix":2\},"a":\{"a":0,"k":[0,0],"ix":1\},"s":\{"a":0,"k":[100,100],"ix":3\},"r":\{"a":0,"k":0,"ix":6\},"o":\{"a":0,"k":100,"ix":7\},"sk":\{"a":0,"k":0,"ix":4\},"sa":\{"a":0,"k":0,"ix":5\},"nm":"Transformar"\}],"nm":"Grupo 1","np":2,"cix":2,"bm":0,"ix":1,"mn":"ADBE Vector Group","hd":false\}],"ip":0,"op":2250,"st":0,"bm":0\},\{"ddd":0,"ind":2,"ty":4,"nm":"Capa 3 contornos","sr":1,"ks":\{"o":\{"a":1,"k":[\{"i":\{"x":[0.833],"y":[0.833]\},"o":\{"x":[0.167],"y":[0.167]\},"t":5,"s":[0]\},\{"t":17,"s":[100]\}],"ix":11\},"r":\{"a":0,"k":0,"ix":10\},"p":\{"a":1,"k":[\{"i":\{"x":0.667,"y":1\},"o":\{"x":0.333,"y":0\},"t":0,"s":[20.721,11.955,0],"to":[1.438,0,0],"ti":[-1.438,0,0]\},\{"t":17,"s":[29.346,11.955,0]\}],"ix":2,"l":2\},"a":\{"a":0,"k":[11.405,14.419,0],"ix":1,"l":2\},"s":\{"a":0,"k":[100,100,100],"ix":6,"l":2\}\},"ao":0,"shapes":[\{"ty":"gr","it":[\{"ind":0,"ty":"sh","ix":1,"ks":\{"a":0,"k":\{"i":[[0,0],[0,0],[0,0]],"o":[[0,0],[0,0],[0,0]],"v":[[-3.904,6.919],[3.904,0.001],[-3.904,-6.919]],"c":false\},"ix":2\},"nm":"Trazado 1","mn":"ADBE Vector Shape - Group","hd":false\},\{"ty":"st","c":\{"a":0,"k":[1,0.4,0,1],"ix":3\},"o":\{"a":0,"k":100,"ix":4\},"w":\{"a":0,"k":3,"ix":5\},"lc":2,"lj":2,"bm":0,"nm":"Trazo 1","mn":"ADBE Vector Graphic - Stroke","hd":false\},\{"ty":"tr","p":\{"a":0,"k":[11.404,14.419],"ix":2\},"a":\{"a":0,"k":[0,0],"ix":1\},"s":\{"a":0,"k":[100,100],"ix":3\},"r":\{"a":0,"k":0,"ix":6\},"o":\{"a":0,"k":100,"ix":7\},"sk":\{"a":0,"k":0,"ix":4\},"sa":\{"a":0,"k":0,"ix":5\},"nm":"Transformar"\}],"nm":"Grupo 1","np":2,"cix":2,"bm":0,"ix":1,"mn":"ADBE Vector Group","hd":false\}],"ip":0,"op":2250,"st":0,"bm":0\},\{"ddd":0,"ind":3,"ty":4,"nm":"Capa 4 contornos","sr":1,"ks":\{"o":\{"a":0,"k":100,"ix":11\},"r":\{"a":0,"k":0,"ix":10\},"p":\{"a":0,"k":[18.022,11.955,0],"ix":2,"l":2\},"a":\{"a":0,"k":[4.619,11.096,0],"ix":1,"l":2\},"s":\{"a":0,"k":[100,100,100],"ix":6,"l":2\}\},"ao":0,"shapes":[\{"ty":"gr","it":[\{"ind":0,"ty":"sh","ix":1,"ks":\{"a":0,"k":\{"i":[[0,0],[0,0]],"o":[[0,0],[0,0]],"v":[[3.119,-9.596],[-3.119,9.596]],"c":false\},"ix":2\},"nm":"Trazado 1","mn":"ADBE Vector Shape - Group","hd":false\},\{"ty":"st","c":\{"a":0,"k":[1,0.4,0,1],"ix":3\},"o":\{"a":0,"k":100,"ix":4\},"w":\{"a":0,"k":3,"ix":5\},"lc":2,"lj":2,"bm":0,"nm":"Trazo 1","mn":"ADBE Vector Graphic - Stroke","hd":false\},\{"ty":"tr","p":\{"a":0,"k":[4.619,11.096],"ix":2\},"a":\{"a":0,"k":[0,0],"ix":1\},"s":\{"a":0,"k":[100,100],"ix":3\},"r":\{"a":0,"k":0,"ix":6\},"o":\{"a":0,"k":100,"ix":7\},"sk":\{"a":0,"k":0,"ix":4\},"sa":\{"a":0,"k":0,"ix":5\},"nm":"Transformar"\}],"nm":"Grupo 1","np":2,"cix":2,"bm":0,"ix":1,"mn":"ADBE Vector Group","hd":false\},\{"ty":"tm","s":\{"a":1,"k":[\{"i":\{"x":[0.667],"y":[1]\},"o":\{"x":[0.333],"y":[0]\},"t":2,"s":[50]\},\{"t":10,"s":[0]\}],"ix":1\},"e":\{"a":1,"k":[\{"i":\{"x":[0.667],"y":[1]\},"o":\{"x":[0.333],"y":[0]\},"t":2,"s":[50]\},\{"t":10,"s":[100]\}],"ix":2\},"o":\{"a":0,"k":0,"ix":3\},"m":1,"ix":2,"nm":"Recortar trazados 1","mn":"ADBE Vector Filter - Trim","hd":false\}],"ip":0,"op":2250,"st":0,"bm":0\}],"markers":[]\}',
//url : "https://assets8.lottiefiles.com/private_files/lf30_uqiitjs4.json",
path : "animations/success.json",
cacheKey : "success_123",
//minFrame : 5,
//maxFrame : 10,
minProgress : 0.2,
maxProgress : 0.7,
repeatCount : -1,
repeatMode : 1,
\};

setFormPanelAnimation(5909, "animation", options);

API AVAILABLE ONLY ON FILTER PANEL:​

removeFilter(fieldName)​

Remove a filtering condition fromthe filter panel search. Typically, this instruction is added to a js action linked to the "before search" event of the Search button in a filter panel.
Required parameters:

fieldName - physical field name; the table name is not required; any filtering condition having this field name will be removed

getFilterPanelValue(panelid, attr)​

where panelId is the filter identifier (CON12) and attr the name of the attribute which identifies a specific input field – returns the value currently set on the input field of the filter panel

getFilterPanelValue1559("attributeName");

setFilterPanelValue(panelid, attr,value)​

where panelId is the filter identifier (CON12) and attr the name of the attribute which identifies a specific input field – set the specified value in the input field of the filter panel

setFilterPanelValue(1159, "attributeName", "value");