Blog Elements

Half Sized Blog Element (Single Author Style)

Half Sized Blog Element (Multi Author Style)

How To Articles, Knowledge Base, PowerForms HTML

Enable or Disable a control based on form conditions

One of the most common scenarios when designing a custom form, is the requirement to enable/disable a specific control (or set of controls) based on a) the values of other controls, b) the user using the form. For our example, we have a list with the following columns : Customer (lookup column referencing the Customers […]

August 13, 2017/by Konstantinos

API Reference, Knowledge Base, PowerForms HTML

The Slider control

The Slider can be used instead of a numeric textbox. Moving the slider left or right increases or decreases the number. The Slider can store its data in a single line column or a numeric column. Type : Slider Name Provides a unique name for the control. Binding Indicates if the control is Unbound […]

August 11, 2017/by Konstantinos

How To Articles, Knowledge Base, PowerForms HTML

Enable or Disable a control based on form conditions

August 13, 2017/by Konstantinos

API Reference, Knowledge Base, PowerForms HTML

The Slider control

August 11, 2017/by Konstantinos

Full Sized Blog Element (Big Preview Pic)

How To Articles, Knowledge Base, PowerForms HTML

Enable or Disable a control based on form conditions

For our example, we have a list with the following columns :

Customer (lookup column referencing the Customers list)

Priority (Choice column with values : Normal, High, Low)

The scenario requires that if a specific customer is selected, the Priority ComboBox should be set to Priority=High and should be disabled for the user.

When first opening the form, it should show something like the following :

You can enable or disable controls using 2 different approaches :

Enabled Formula

Open the designer and select the Priority ComboBox properties.

In the Enabled formula add the following expression :

Code

form.GetControl(“c_Customer”).GetValue_Name() != “BPC”

NOTE : In the expression above, we only check for the display member of the combobox value. If we wanted to check for the value member (ID) we would have to write something like :

Code

form.GetControl(“c_Customer”).GetValue_Value() != “1”

// or

form.GetControl(“c_Customer”).GetValue() != “1;#BPC”

When the user selects a different customer, the Priority combo is enabled :

But if we select the customer appearing in the formula, the control is automatically disabled :

Now to completely meet the requirements, we have to set the value to “High”.

This can be accomplished using a simple script inside the Value-Change event of the Customer ComboBox.

The script should be something like the following :

Code

if (form.Loaded) {

value = form.GetControl(“c_Customer”).GetValue_Name();

if (value == “BPC”) form.GetControl(“c_Priority”).SetValue(“High”);

}

The form.Loaded condition is used because we want this script to be executed only after the user changes the value and not during form initialization (the value-change events are raised during form loading).

Using script

The same thing can be accomplished without using the Enabled formula but by script alone.

Here is the changed script that we should use to have the same effect.

The script should handle the value-change event of the Customer ComboBox.

Code

value = form.GetControl(“c_Customer”).GetValue_Name();

if (value == “BPC”) {

form.GetControl(“c_Priority”).SetEnable(false);

if (form.Loaded) form.GetControl(“c_Priority”).SetValue(“High”);

}

else {

form.GetControl(“c_Priority”).SetEnable(true);

}

Notes :

In the above script, we check the customer value and we set the Enabled property of the Priority control.

We set the default value only when the event was raised from a user action and not due to form initialization.

August 13, 2017/by Konstantinos

API Reference, Knowledge Base, PowerForms HTML

The Slider control

The Slider can be used instead of a numeric textbox. Moving the slider left or right increases or decreases the number. The Slider can store its data in a single line column or a numeric column.

Type : Slider

Name

Provides a unique name for the control.

Binding

Indicates if the control is

Unbound
Bound to list column
Is a label for a control bound to list column

Enabled for new records

Sets if the control will be enabled or disabled when the forms handles a new record

Enabled for existing records

Sets if the control will be enabled or disabled when the forms handles an existing record

Required

Marks the cotnrol as Required.

By default, the system recognizes required fields and marks them with this flag. Additionaly, controls can be marked as required event if the bound column is not.

Enabled Formula

Set an expression then will be evaluated during run-time and enable or disable the control.

The expression must be in javascript and should return a boolean value.

Dependencies between controls are automatically identified and the expression is re-calculated every time a control affecting the formula changes.

Example :

Code

form.GetControl(“c_Status”).GetValue() != “Open” && form.UserInGroup(“Administrators”)

Visibility Formula

Define a valid formula (using javascript) that will be evaluated during runtime to show or hide the control.

The expression should return a boolean value.

For example :

Code

form.FieldValue(“c_Status”) != “Rejected” || form.UserID() == “1”

Value

This property defines how the control will get its value.

Here are the available options :

The value is Static (this is the default for label controls)
The value will be provided by the user (Not applicable for labels)
The value will be calculated by a formula
The value will be retrieved from a list query
The value will be provided by a web service call
The value will be provided by a SQL query

Static value

A static text must be set in the appropriate designer control.

Formula

A javascript expression must be set that will provide the value for the control.

If the formula contains references to other controls, dependencies will be automatically identifies during run-time and the value will be updated to reflect changes.

Example :

Code

form.FieldValue(“c_Active”) ? “Yes” : “No”

There is an additional option that instructs the form to perform calculations only for new records. Existing records will keep their original value.

List Query

A predefined list query is bound to the value of the control. So during form initialization, the specified list query is executed and if it returns any item, it selects the first one and it will apply the value to the label based on the following rule :

If a Field Name has been selected in the corresponding box, that specific column will be used from the list item to fill the control value.

If the Field Name is left blank, the first column retrieved will be used.

Web Service

The same as above, the required web service is selected and after the web service retrieves data, the first item will be used to update the control value. If no Field Name is set, the control will receive the first field of the retrieved item.

SQL Query

Works the same way ListQueries and Web Service works.

Example :

Code

=”User : ” + form.UserFullName()

Width

Defines the width of the control.

When the value is zero, the maximum allowed width will be used.

Please note that you can only change the Slider’s width using the above Layout property and not by adjusting the number of boxes it occupies on the designer view.

Height

Defines the control height.

If the value is zero, the height property will not be set.

H.Alignment

Defines the horizontal alignment of the parent cell (values : left, right, center)

V.Alignment

Defines the vertical alignment of the parent cell (values : top, bottom, center)

Fore Color

Not Applicable for the Slider control.

Back Color

Not Applicable for the Slider control.

Cell Color

Defines the color of the parent cell.

Margin

Sets the margin applied to the control, that is, the spacing between the control and the cell borders.

Font Style

Not Applicable for the Slider control.

Not Applicable for this control

MinimumValue

Indicates the minimum value for the progress bar.

MaximumValue

Indicates the maximum value for the progress bar.

SmallChange

Indicates the least amount of change in the value that can happen by moving the slider.

LargeChange

Indicates the most amount of change in the value that can happen by moving the slider.

Decimals

Sets the number of decimals for the displayed value, default is 0.

Sets the script that will be executed at the value-change event of the control.

Example :

Code

var value = form.GetControl(“c_Title”).GetValue();

if (value == “Open”) form.HideSection(“Details”);

else form.ShowSection(“Details”);

August 11, 2017/by Konstantinos