News

Part 1 - Overview  Part 2 - Installing the Apps  Part 3 - Building Your First Workflow  Part 4 - Working With Forms 

Part 1 - Overview- Part 2 - Installing the Apps  Part 3 - Building Your First Workflow  Part 4 - Working With Forms 

I wanted to be able to do a Group Count on a set of items in a library (I actually wanted to save the values and counts to a list so that I could attach a chart control – but that’s another story).There is no way of doing a Group By in the Query List task, so I had to come up with this.Retrieve all my key values into a collection, then create a list of those unique key valuesIterate through the unique values and remove them from the original list – the number of items matching the key value is the number of items removed from the collection – the difference between the counts before and after the deletion.In pseudocode, the process is thisQueryList : get all ‘key values’ in range into collection AllKeysCollection: Remove duplicates from

OFFICE 365 Recently, I had the need to hide/show panels based on a value or values of a choice control. Online I saw multiple posts on how to accomplish this using simple rules; however, they did not explain how this would affect the user when accessing the form in read-only. For this post, I'll be referring to the following setup:A choice control with three options: Panel A, Panel B, and Panel C Three panels, each corresponding to the options listed on the choice controlThe expected behavior is as follows:A user sees only sees the panels the correspond to the options selected in the choice control. When the recipient or user opens the form in read only, he/she should see the panels that were selected in the choice controlSolution 1:

This works with on-prem Nintex Workflow 2013Problem:  Upon archiving a document I use workflow to update the date/time field of when the archive happened.  When user wants to un-archive the document, I need to clear the date field to display as empty (or null). Resolution: Create variable vDateArchivedDate as Date and Time with blank default date Use Convert value action input "1/1/0001" and store in variable vDateArchivedDate Use Set field value to update the date column with workflow data > vDateArchivedDate

Recently I needed to create a schedule of dates, one week apart. I created a loop and added 7 days in each iteration. I noticed it took a very long time, so I added a Log in History task in the loop and saw that each iteration was taking 5 minutes. I realized that this was down to ‘Safe Looping’.This protective feature places some safety measures against the hazards of an infinite loop by adding a hidden delay..I didn’t want to disable this option, mainly because of the maintenance overhead involved, so I looked for another option.I realised that the Collection iteration (For Each) didn’t have any such restriction, so all I needed was to create a collection with the number of entries that I wanted to loop for.The Regular Expression task with the Split operator is the easiest way to create a collection; it simply splits text based on a character. All I had to do was to create a string with the right number

The action Assign Flexi Task is under development for O365.Recently, the Task Outcome for Assign a Task was released.The Delegation of a Task becomes then more intuitive.Here is how I have implemented it. 1. Let's create a new Site column for the Task Outcome.Go to Site Settings of your Site Collection and under Web Designer Galleries, click Site columnsClick Create and name it like you wish. I have name it Task Outcome Approve.For The type of information, tick Task Outcome.For Group, the best practice is to create a New group to store your customized columns. I ha

Applies to: Nintex Workflow and Nintex Forms for SharePoint 2016, 2013, and 2010 Note: The Nintex external platform includes the following external services: Nintex Live (connector actions), external forms (live forms), Document Generation, and External Start. OverviewIf you are running a previous version of Nintex Workflow for SharePoint, and are not yet ready to upgrade your installation to the latest product version, you can install the latest SSL certificates for the Nin

Dear all:I have been very confused about this topic for months:How to navigate from a parent form to child form and come back? How to navigate from a child form to a new one child form keeping the parent link? How to validate child form data before come back in both cases?I think I have now a good approach to do it without javascript.  How buttons workFirst of all, I would like to describe how buttons are working under my understanding, in the case of validation and redirection:Save and submit button / Save button:Both buttons have redirection parameter. You can build the URL dynamically, using a list field value and run-time functions. You can't use calculated fields or control values, this is a very important point.In the case of validation, both buttons can validate data, including list required fields and validation rules in the form.

Though I have been working with Nintex Forms and Nintex workflows for a long time I didn't happen to realize how versatile and fun to work with repeating sections on the forms in conjunction with Nintex workflows. Long story short, I always had this common requirement from Infopath form days till a new project I implemented purely with Nintex, that is none other than having an ability to report and update the repeating table rows using spreadsheet view in the SharePoint. Until I come across a great post written by Vadim Tabakman parse repeating section data I felt it is not possible help clients with such requirements without code, but Vadim Tabakman's posting changed the way how I looked at NIntex F

Products: Nintex Workflow for SharePoint (2016, 2013, 2010) Avoid “All” and “Item” Content Types To prevent lengthy content type evaluation when saving or publishing reusable workflow templates, avoid selecting “All” or “Item” for the content type. Instead, create a content type based on Item and then select the created content type when defining the reusable workflow template. For instructions on creating content types, refer to the SharePoint documentation. More Information For more information about reusable workflow templates, see “Set Title and Description for Reusable Workflow Template” in the Nintex Workflow Help (2016 |

Thanks to Sean Fiene‌ for assistance. Below is an example of how to perform Validation on specific controls based on their dates. The goal: If start date is less than or equal to 11 days from today andor If start data is more than 7 days before end date than prevent the form from being submitted. Step 1:Create a list with a “Start Date” and “End Date” column of data type “Date and time”. Step 2:Open Nintex Forms and choose “Forms Variables” from the ribbon bar. I named my variable ‘varStartDate” Type: Integer Connected To: Not Connected Recalculate formula on view mode: No Recalculate formula on new mode: Yes Recalculate formula on edit mode: Yes Formula: dateDiffDays(Current Date, StartDate)

There is currently a .Net update that has caused disruption on SharePoint 2007,2010,2013 and 2016 platforms.  After applying .NET Security Only patch to resolve CVE-2018-8421 (Remote Code Execution Vulnerability) , all SharePoint "out of the box" & Nintex Workflows fail to execute and the log will show an error like the below: ULS Log: System.CodeDom.CodeBinaryOperatorExpression is not marked as authorized in the application configuration file Publishing a Nintex workflow   ResolutionMicrosoft link to issue & resolution. Microsoft related u

When i am developing forms for applications, i like to have as much information on the new item form as possible. Workflow can update the item after submission but I think it adds to the user experience to see important information on the form. Whether it is a unique reference number as described here: Ensure Unique Reference On New Item‌ or other information.Another piece of important information, especially in an application that requires line manager approval is, yep, you guessed it, the line manager.With Nintex Forms People Picker API, described in detail here: People Picker Extensions - Nintex Forms‌ we can add the line manager to the people picker control,In my example i have an employee people picker field default to current user and a Client ID JavaScript variable name of varCurrentUser

I had these notes stored from a couple of years ago - they helped me at the time with a problem I had been banging my head with for ages, but I haven't needed to use them since.  Not sure if any use to anyone, but in the process of getting all my blog posts in one place, and what better place than the Community  Believe it or not, this is not straight forward.  For this blog I will paint the picture.  I have a request list which uses Managed Metadata to store Business Units.  I have a list on another site which stores approved and completed items from the original request list.  On this list, the same Business Unit Managed Metadata column is used.  I tried using the "Create item in another site" action in Nintex Workflow but could not just simply map the field from one list to the other.  Instead I had to query the TaxonomyHiddenList of the target site collection to get the ID and GUID for the term.  To

This is just a reminder for me (if I need it in the future) or whoever need it so as to lose time I lost trying to do it. I tryied to customize a task form with Nintex Forms and I received this message.      Please update to the current version of Nintex Forms for Office 365 You are using an older version of Nintex Forms for Office 365 Update to the most recent version to customize task forms   And I asked myself how could I update it. Because I didn't remember a Sharepoint feature to update installed apps. And after some time I solved it with the next steps: In order to add the app to your Office 365 tenancy, you will need to add the app. This tutorial will take you through the process of adding the app.In your Office 365 site, click on the Settings icon and click on

If I could fill the title with exclamation points, I would. The lookup() runtime function for Nintex Forms for Office 365 is now available. For those of you that have used Nintex Forms for SharePoint 2010 or 2013, you know how powerful this function is, and for those just new to Nintex Forms, let's take a look at what you will be taking advantage of soon! In this example, I want to build an order form that will include a Lookup control pulling Item Names (Title Column) from an Inventory list. In the order form, I want to have read-only values for the item color and the item number. Let's start building! Here is an overview of the Inventory List. Notice the column names and values:Now that we have built an Inventory List, we need to create a list to contain the order form and open the Nintex Forms Designer. I've replaced the Title single line text box contro

In Nintex 2010, 2013 and 2016 for SharePoint (Standard version even) on-premise of course, there was a possibility to use excel services to query and work with the xlsx and xls files' data. However, insharepoint online there is no such powerful mechanism. Moreover Nintex products for SharePoint Online (neither nwc‌ nor nintex for office 365) don't have any "ootb" actions that would fill that gap. So in the end, there is no straightforward way to achieve it. The most common workaround is to convert the XLSX file into a plain, csv file and then to work with the data from the file using collections (I will write about it in second post). Recently I have realized, that there is a set of excel‌ actions in microsoft flow‌! All of us, who has SharePoint Online, has also a free version of Flow available.  Just be aware, that in the free version Flow does not triggers itself once an event occurs. It just repeatedly checks whether an action occurs

You can use the NWAdmin PowerShell snap-in available through the SharePoint 2013 Management Shell on your SharePoint 2013 server with Nintex Workflow installed. You can use NWAdmin and the ExportWorkflow and DeployWorkflow commands to export and deploy a Nintex workflows using a script. You can use the command in migration scripts to move your Nintex solution, in scripts to move your workflows from a development to production environment, or any other situation where programatic access to the workflow will make your work easier. In this post we will walk through how to access the NWAdmin PowerShell tool on a SharePoint server with Nintex Workflow installed, and then export the workflow, and then deploy the workflow to a new list. Contents Export a workflowYou can use PowerShell to export

If you observed that below Nintex Timer Jobs not running on your Nintex 2016 farm  follow the below steps:Nintex Connector Subscription Synchronization Nintex Connector Workflow Manager Nintex Connector Workflow Synchronization Nintex Peak Usage SynchronizationMake Sure that you have Central Admin Site running on Application Server, If not follow below steps:Moved Central Admin site to Application Server Stop and Start all Nintex Services on all server Restart SharePoint Timer Service on all server Activated Nintex for all web application Deactiv

To have external connection working, Follow below steps:Turn on External Settings from Nintex Administration Turn on all Nintex Actions Perform IISRESET for immediate availability of actions in workflow. Make sure that you have root site collection created in web application Now you are able to have DocuSign Connection Support‌Nintex for SharePoint‌

We've had a couple of people request the ability to pull back information on the workflows in their farm. This script will return the results of all workflows found inside of the Nintex databases associated with your farm. There are a couple of things to note: Workflows that have been designed, but never run will not show in the results (no record of them in the Nintex DBs) If you have performed a recent purge on the Nintex databases, the workflows may not show up. If you receive errors when running the script, please allow it to run to completion. The script uses what It finds in the Nintex DB and resolves certain information (SiteID > Site collection URL, Etc.) and may error if a Site Collection/Site/List and/or workflow is not found. This will not affect the results of the workflows that are found.  PowerShell

Nintex Workflow Cloud Release 54 comes with very good news for those of you using Nintex for BOX.Now, the actions in the BOX connector accept the File or Folder ID as parameters to identify and work with files and folders. And, as you can see in the examples below, the new feature has been added to the actions, it’s not replacing the previous option of the action working with the objects paths. So, if you were already using BOX actions in your workflow with paths don’t panic, you won’t have to change anything. This new feature comes as a response to the feedback we’ve received during the last months from customers and partners asking for a way to interact with BOX objects using the file and folder ID. From here I’d like to thank my product team at Nintex, for the great job they’ve done here and the quick reaction to the BOX and Nintex user's request (myself included

 Nintex is pleased to announce the acquisition of Promapp, a business process management software company which provides partners and customers new tools to better optimize business processes through a market leading visual process mapping solution.  The full press release is available at https://news.nintex.com/2018-07-31-Nintex-Acquires-Process-Management-Leader-Promapp . Further details are available at  https://www.nintex.com/workflow-automation/process-mapping/. 

A sandwich PDF is a scanned document that contains an invisible text layer exactly over the image text. Text layer is produced by OCR (optical character recognition) using open source software tesseract. So PDF ist searchable for text and text can copied and pasted in another document. prerequisitesPowerShell workflow action (I use dataone PowerActivity, it should also be possible to other actions like NTX PowerShell Action - Stable Release from Aaron Labiosa ) tesseract (GitHub - tesseract-ocr/tesseract: Tesseract Open Source OCR Engine (main repository) ,  windows installe