Use ‘Form Event Actions’ Feature Of NITRO Forms To Add Custom Functionality – III

Applies to:
Crow Canyon NITRO activated sites in:
SharePoint Online and On-Premises 2013/2016/2019/SharePoint Server Subscription Edition

Description

NITRO Forms have a lot of built-in functionality to customize the layout, design and functionality as required in common business applications. For any specific cases not covered directly by the configurations, custom JavaScript and CSS can be added. These custom scripts can be invoked on form load, on column values change and before/after an item is submitted. For all these cases, scripts can be invoked conditionally based on various values entered in the form.

Please refer to this article for form event actions’ basic usage and configurations. Refer to this article for more FEA use cases.

This article describes some sample use cases to configure form event actions in NITRO forms.

Use case 1: Update closed date when a task is completed

Sample list schema and use case

  1. Standard SharePoint list
  2. Columns:
Column Display NameColumn Internal nameColumn TypeColumn Value
StatusStatusChoice ColumnNew In-process Complete
DateOfCompletionDateOfCompletionDate and Time 
  • Use case: Update ‘DateOfCompletion’ with current date and time when a task is ‘Completed’.

Steps to configure

  1. Navigate to NITRO Forms designer for the list -> Expand ‘Advanced’ section from the left-hand panel -> ‘Form Event Actions’ -> Click ‘New Configuration’ button as shown below:

2. Configure a form event action on ‘Execute on column value change’ event and select the ‘Status’ column. This FEA will trigger when the value of ‘Status’ column changes.

3. Expand ‘New Action’ menu -> Click ‘Update Form Controls’.

4. Specify condition: Status ‘equal’ Complete. Click ‘New Mapping’ button.

5. Configure column mapping:

    ‘DateOfCompletion’ -> {Now}

    ‘{Now}’ captures the current date and time as per the site’s regional settings.

    6. Click ‘Ok’ to save the Form Event Action configurations à Publish the NITRO form.

      Sample output:

      Note: We can configure ‘Hide’ permissions to show ‘DateOfCompletion’ column only in the display form and hide from the new and edit forms. Refer to ‘Column Permissions’ from the manual for detailed steps to configure the column permissions.