Search

  • 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 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...

  • 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 show Edit button based on user's permission on the list

    For checking if a user has permissions to edit an item and showing basing on this check an "Edit" button in the Display form's Command Bar, you can add this Function Code b...

  • 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 ...

  • 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

    Table of contents Classic add-ins Modern add-ins Classic add-ins The expression language used in skybow Rich Forms and Action Links is very powerful because it allows yo...