Expressions on forms
-
Overview of the skybow Expression Builder
The skybow Expression Builder helps you to intuitively add calculations, default values, hide/when conditions, validation rules and more without extensive programming langu...
-
Useful JavaScript expressions for the skybow Expression Builder
We always try to make our Expression Builder as simple as possible. This makes it easy to use without extensive programming knowledge. However, it can still happen in vario...
-
How to calculate field values with the skybow Expression Builder
The skybow Expression Builder helps you to intuitively add calculations, default values, hide/when conditions, validation rules and more without extensive programming langu...
-
skybow tutorial - Modern Forms - How to capitalize field values?
In this video we will show you briefly how to use skybow Modern Forms to automatically transform field values into upper case. For this purpose a "Set Form Field Value" act...
-
How to show/hide controls for users of a specific SP group
You can show or hide controls such as fields, tabs, buttons etc. based on the fact that the user is a member of a specific SharePoint group via the Visible Control Status i...
-
How to create a unique ID for a form
To have a unique ID for a form you can use the Form ID with a custom prefix. To create this, you need to know that it can't be created on the New Form. The New Form does no...
-
How to define the current user as default value of a people picker
To select the current user as a default value in a people picker field you can use the Initial Field Value in skybow rich forms and solution studio online and add [[@User...
-
Field Validation Examples using Regex
The SharePoint out-of-the-box field validation is very limited and you can't use regex to validate the value entered in the form. Using skybow rich forms as add-in but as ...
-
How to use [[Attachment]] field placeholder on Modern Forms
Field placeholder [[Attachment]] in Modern Form's Expressions has additional properties after evaluation that can be used for different scenarios e.g. to configure some val...
-
Calculation with numbers using Javascript and different regional settings
Using skybow forms you can use expressions to calculate field values. If you want to calculate with numbers having fixed decimal places, but want to make sure you can easil...
-
Get the number of work days between two dates
Very often, in different business apps scenarios, you will need to get the number of work days between two dates. This code snippet will help you to do exactly that. I...
-
How to sum/calculate with numbers in a sublist matching a condition?
Within skybow Modern Forms there is a function to easily calculate (sum / average / count / min / max) of sublist numbers. This is taking the value of every row whatever ...
-
Selecting User Profile values from the people picker fields
Table of contents How to do that in skybow modern forms How to do that in skybow rich forms Very often there is a need to select the User Profile properties for ...
-
Calculate automatically person's age in a form field
Very often, it is necessary to calculate persons age (the most often in years) in a form field, based on the date value set in another field. This is very easy to do in sky...
-
Reading JavaScript date values from SharePoint date fields regardless of locale (culture)
Using standard JavaScript Date.parse() method with JavaScript does not really work with SharePoint fields, since it does not take in account the locales of the SharePoint s...
-
Referencing JavaScript libraries in your expressions
The expression language used in skybow Solution Studio and Add-ins is very powerful because it allows you to use any JavaScript code. In many cases you might not want to i...