Blog Single Author Fullwidth

Sometimes in Sharepoint, there may be a need to have more than one form layout for an individual list. Different fields or form designs may be required to differentiate between field values.

For example using a customers list, we may need to paint the form’s background blue if the gender is male and pink if female.

PowerForms HTML supports different customizations for each list. By default, each form automatically creates a customization with no conditions applied and this customization is used every time the form appears.

In order to see the different form layouts, we select the following button on the editor screen:

A form containing the default customization appears:

Let’s describe how to create a second form layout for the same list. For our example, we’ll need to present a different form to the user everytime the item’s title is test. To do so, we follow these steps:

– Select the default condition

– Enter our conditional statement in the Create copy with condition box. In our case, we want to automatically load this form customization every time the title is test. The statement is:

“{Title}”=”test”

– Press on the Copy button.

*Note :  You should use the field’s Sharepoint name when trying to create a conditional statement and not the name given by the designer. i.e. notice we are using Title instead of c_Title.

From this point on, this customization will automatically load everytime the title is test. To visually differentiate  between the two customizations, we select our newly created condition and press on theSelect button. This causes the editor to load the selected customization.

Using the Editor, we decide to change the background color of the c_Title field to red. This means that everytime the Title is test, the box will have a reddish hue else it will be white.

Title is test

Different Title

You can edit the conditional statement by going to the design form and selecting Options.

One of the options available with every control is to provide its value using a calculation formula. By setting a field to be calculated, you have to define the calculation formula for the field values.

You can also use calculation formulas in the “Visibility formula” and “Enabled formula” properties, on the General tab. These formulas should always return a Boolen (True/False) value to indicate whether a control should be visible/enabled or not.

The calculation formulas use Javascript like syntax and a guide on how to use them is available in Form Properties and Methods.

To reference the value of a control i.e. c_Control1 which contains text, simply use the following syntax:

The above expression is the equivalent but shorter version of the following:

For example, let’s assume we have 2 controls on our form

c_Control1 is a Textbox

c_Control2 is DateTimePicker

Our example form looks like the following:

We decide to use a calculation formula on the Textbox control (c_Control1), so that anytime a date is selected on c_Control2, c_Control1’s text will display:

Selected Date : followed by the selected date.

Note:

You can also have the same result by typing in the following expression:

After saving the above changes, everytime a date is selected on the DateTimePicker control the Textbox control will show: