Recent

Runtime Function examples for Nintex Forms

There are two types of functions in Nintex forms, ‘Runtime functions’ which run while the form is open and ‘Inline functions’ which run before the form is opened.  Runtime functions are used both for Calculated Value control formulas and for Rule formulas.

The following are a list of common Calculated Value runtime functions, see the rule examples tutorials if you are looking for form rule examples.  This list is in alphabetical order.


dateAddDays()

If you are doing a calculation and displaying a date, you will usually need to combine the formatDate() function with your calculation.  The dateAddDays() can be used to add days to a selected date field.
NF-Calculated-Value-Examples-16-9

OR the dateAddDays() can be used to subtract days from a selected date field.  Note that the second value in the dateAddDays() function can either be a field reference or a static number.
NF-Calculated-Value-Examples-16-11


dateDiffDays()

You can also use calculated fields to show the difference between two date fields, or the difference between the current date and a date field.
NF-Calculated-Value-Examples-16-10


If()

You can conditionally populate a field value as well, for example if you want the title to be different for different request types.  Use the If() function with the format:
If(condition to test, value if true, value if false)
NWF-Calc-Value-Examples-16-10


If(If())

You can nest if statement if there is more than one condition to test, format is:
If(condition1 to test, value if true, If(condition2 to test, value if true, value if false))
NWF-Calc-Value-Examples-16-11


Lookup()

You can display additional field values from the item selected in a List lookup field on your form.  Use the lookup function with the format:
lookup(lookup list title, ‘ID’, named control, lookup column name to display)
NWF-Calc-Value-Examples-16-4
In the example above the lists title that is being looked up is ‘Items List’ and the column in the Items List which we are displaying the value for is named ‘Price’.


parseLookup()

List Lookup fields return both the Items ID and value (2;#Paper Towels).  Use the parseLookup function to either return the column value (true)
NWF-Calc-Value-Examples-16-6
OR item ID (false)
NWF-Calc-Value-Examples-16-7


userProfileLookup()

Can lookup profile values for the specified people picker field or current user.
NF-Runtime-example-16-1
**See the list of Nintex Forms User Profile Values

About Nick Hurst (84 Articles)
SharePoint and Nintex developer who strives to find easy to deploy and maintain solutions for business problems.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: