Tag Archives: Nintex

Regular Expression to Extract the First Part of a URL in Nintex Workflow

Using the Regular Expression action in Nintex Workflow, you can extract the first part of a URL and store it in a workflow variable to use in the rest of the workflow.

Follow these steps to build out this functionality:

  1. Add a Regular Expression action to the workflow.
  2. Configure the action with the following options:
    • Pattern = See examples in the table below
    • Ignore case = Check if string case should be ignored
    • Operation = Extract
    • Input text = URL string to extract data from (can be hard coded or inserted from the Insert Reference button)
    • Store result in = Create a “Single line of text” variable to use.
      • Note: The result is stored in a Collection variable. You will need to add another action like the “Collection Operation” action to get the result.
  3. Use the “Run Now” functionality to test the regular expression.

Examples
Below are the results when using each of the Patterns with this example URL in the “Input text” field:

https://DomainName.com/sites/SiteName/SubsiteName/ListName.aspx

PatternResult
(^https:\/\/[\w\d].[\w\d]*)https://DomainName.com
(^https:\/\/[\w\d].[\w\d]\/[\w\d]*)https://DomainName.com/sites
(^https:\/\/[\w\d].[\w\d]\/sites\/[\w\d]*)https://DomainName.com/sites/SiteName
(^https:\/\/[\w\d].[\w\d]\/[\w\d]\/SiteName\/[\w\d])https://DomainName.com/sites/SiteName/SubsiteName

Show and Hide Group Controls Using a Choice – Multiple Field in a Nintex Workflow Cloud (NWC) Form

In this video, I show you how to show and hide Group controls using a Choice – Multiple control in a Nintex Workflow Cloud (NWC) form. As part of this solution, I will also show you how to configure Form Rules to accomplish this dynamic functionality.

Show and Hide Group Controls Using a Choice – Multiple Field in a Nintex Workflow Cloud (NWC) Form

Show and Hide a Group Control Using a Checkbox in a Nintex Workflow Cloud (NWC) Form

In this video, I walk you through you how to show and hide a Group control using a Checkbox control in a Nintex Workflow Cloud (NWC) form. As part of this solution, I will also show you how to configure a Form Rule to accomplish this dynamic functionality.

How To Restrict Numeric Data Entered to a Certain Number of Digits in a Nintex Workflow Cloud Form (NWC)

You can easily configure a form field to only accept a certain number of digits as input. This configuration also will not allow text or special characters to be entered in the form field. This post will show you how configure this in a Nintex Workflow Cloud form. This solution can be useful to validate data like Account Numbers, Employee IDs, Invoice Numbers, and many other examples.

Follow these steps to build out this functionality:

  1. Add a Text – Short control to the form.
  2. Select “Regular expression” in the Input Validation setting drop-down menu.
  3. Enter the desired regular expression string in the Pattern field. Below are examples:
Restrict Number of Digits Entered to:Pattern:
5 digit number^(\d{5})$
7 or 8 digit number^(\d{7}|\d{8})$
9, 10, or 12 digit number^(\d{9}|\d{10}|\d{12})$
  1. Feel free to enter a message in the “Custom Regular expression message” field.
    1. This message displays if the data entered is not the correct number of digits.
    2. You can use this message as an instruction to the form user to correct the data.
  2. Test out this functionality by going to the Preview tab and adding data to the form field you configured.
    1. If you enter fewer or more digits than the pattern, the field is marked as invalid and the “Custom Regular expression message” appears under the field.
    2. If you enter text or special characters, the field will also be marked as invalid and the “Custom Regular expression message” appears under the field.
NWC Form Restrict Data Entered to Certain Number of Digits

Set Up Age Verification on a Date/Time Control in a Nintex Workflow Cloud Form (NWC)

In this scenario, we need to verify that a user is older than a certain age (i.e. 18 or 21) based upon a date of birth entered in a Date/Time form field. This can be accomplished by creating a Submit Rule to validate the date field.

Follow these steps to build out this functionality:

  1. Add and configure a Date/Time control on the form:
    1. Enter a name like “Date of Birth”.
    2. Make sure the “Restrict past dates” toggle is set to No.
    3. You can also add a Description or Tooltip with a message like “You must be over 18 years old”.
  2. Configure a Submit Rule on the form:
    1. Go to the Rules tab.
    2. Click on the “Add submit rule” button in the Submit Rules section.
    3. Enter a descriptive Name for the rule like “Verify Date of Birth Over 18”.
    4. Configure the If statement.
      1. Click on the blue Insert button on the first drop-down field.
      2. Configure the Formula field.
        1. Find and insert the dateDiff() function from the Functions tab of the Lookup section.
        2. Enter “TotalYears” as the first parameter (make sure to include the quotation marks).
        3. Find and insert the “Date of Birth” form control as the second parameter.
        4. Find and insert the dateNow() function as the third parameter.
        5. The Formula should now be configured as (see the image below):

          dateDiff(“TotalYears”,[Form].[Date of Birth],dateNow())


        6. Click the Insert button to save the Submit Rules.
      3. Select “Less than” from the second drop down field.
      4. Enter the age (18 or 21) that the user needs to be older than.
    5. Configure the Then statement.
      1. Select “Date of Birth” from the first drop-down field.
      2. Select “Show Validation Error” from the second drop-down field.
      3. Enter a message like “You must be older than 18 years old” in the third field.
    6. The Submit Rule should now look like the image below:


    7. Click the “Create rule” button to save and activate the Submit Rule.
  3. Test out your rule by going to the Preview tab, selecting a Date of Birth, and clicking the Submit button.
    1. If the user is under 18, the field will be marked as invalid and the validation message will appear.
    2. When the user is over 18, then the field is valid and the form can be submitted.

You can find out more about the Nintex Workflow Cloud functionality used in this blog:

Date/Time form control: https://help.nintex.com/en-US/nwc/Content/Designer/FormControls/DateTime.htm

Rules: https://help.nintex.com/en-US/nwc/Content/Designer/FormsRules.htm

Nintex Workflow Stalling on Document Generation Action

I encountered an issue recently where a few Nintex Workflow 2013 workflows that had been running successfully for some time suddenly started stalling.  The workflows still showed a status of “In Progress” but were not moving forward.  Checking the Workflow Progress and Workflow Details pages showed no error messages or issues.  I finally noticed that these workflows were freezing when trying to execute a Document Generation workflow action.

After investigating, I determined that the issue was related to a Nintex Workflow service not running in my SharePoint 2013 environment.  Specifically, the Nintex Workflow Start Service was not actively running on any of my SharePoint 2013 servers.  Once I restarted that service on one of my servers, the stalled workflows continued running, completed the Document Generation action, and progressed to the next workflow steps.

Get Digits Before a Decimal Point Using a Regular Expression in Nintex Workflow

Using the Regular Expression action in Nintex Workflow, you can get the digits before a decimal point.

Here are the steps to follow:

  1. Insert a Regular Expression action into your Nintex Workflow.
  2. Configure it with the following settings:
    1. String = Your number from a column or workflow variable.
    2. String Operation = Replace
    3. Pattern = \.[0-9]+
    4. Replacement String = Keep this empty
    5. Output = Text workflow vatiable
  3. You can then use the workflow variable as you need it.

Here are some examples from using this Regular Expression:

String Regular Expresssion Result
6.5 \.[0-9]+ 6
1234.5678 \.[0-9]+ 1234
1234567.89 \.[0-9]+ 1234567

 

Speaking at SharePoint Saturday Charlotte 2017

I am speaking at SharePoint Saturday Charlotte 2017 on August 26, 2017. This year I will be speaking on “Empower Your Mobile Workforce with Nintex Mobile and Nintex App Studio”. Find out more and register for this free SharePoint conference at the SharePoint Saturday Charlotte site.

Be sure to attend my session and say hello at the conference!

Empower Your Mobile Workforce with Nintex Mobile and Nintex App Studio

Employees today are increasingly on the move and expect to have access to the tools they need to get their work done. Nowhere is this more crucial than on the devices they carry and the mobile apps they use. Nintex provides the tools necessary to enable your mobile workforce to be more efficient and productive. This session will cover features of Nintex Mobile and Nintex App Studio that you can utilize to build dynamic mobile forms and apps with little or no code. You will learn how to leverage Nintex Mobile and Nintex App Studio to create powerful, easy-to-customize mobile forms and apps to empower your organization.

Speaking at the Atlanta Nintex User Group Meeting on 7/26/17

I’m excited to be speaking at the next Atlanta Nintex User Group on July 26, 2017. I will be presenting a session titled “Empower Your Mobile Workforce with Nintex Mobile and Nintex App Studio”. I hope to see you there! For more information and to sign up, visit the Atlanta Nintex User Group page on Meetup at https://www.meetup.com/Nintex-User-Group-Atlanta.

Here’s a summary of my session:

Empower Your Mobile Workforce with Nintex Mobile and Nintex App Studio

Employees today are increasingly on the move and expect to have access to the tools they need to get their work done. Nowhere is this more crucial than on the devices they carry and the mobile apps they use. Nintex provides the tools necessary to enable your mobile workforce to be more efficient and productive. This session will cover features of Nintex Mobile and Nintex App Studio that you can utilize to build dynamic mobile forms and apps with little or no code. You will learn how to leverage Nintex Mobile and Nintex App Studio to create powerful, easy-to-customize mobile forms and apps to empower your organization.

Speaking at SharePoint Saturday Atlanta 2017

I am speaking at SharePoint Saturday Atlanta 2017 on June 17, 2017. This year I will be speaking on “Empower Your Mobile Workforce with Nintex Mobile and Nintex App Studio”. Find out more and register for this free SharePoint conference at the SharePoint Saturday Atlanta site.

Be sure to attend my session and say hello at the conference!

Empower Your Mobile Workforce with Nintex Mobile and Nintex App Studio

Employees today are increasingly on the move and expect to have access to the tools they need to get their work done. Nowhere is this more crucial than on the devices they carry and the mobile apps they use. Nintex provides the tools necessary to enable your mobile workforce to be more efficient and productive. This session will cover features of Nintex Mobile and Nintex App Studio that you can utilize to build dynamic mobile forms and apps with little or no code. You will learn how to leverage Nintex Mobile and Nintex App Studio to create powerful, easy-to-customize mobile forms and apps to empower your organization.