News

Hola guys    .Author Palesa Sikwane‌ Long Description This is a little workaround that can assist you providing a user friendly way of keeping track of an items version history while keeping your Workflow History list data to a minimum on your site. Dependencies SharePoint ® On Premise or SharePoint ® Online Versioning Enabled on the List/Document Library Compatibility Nintex Workflow ® Office 365 ® Nintex Forms ® for Office 365 ® Nintex Workflow ® On Premise Nintex Forms ® On Premise Platform SharePoint® On Premise (2010, 2013 or 2016) Office 365 ® Useful Reads You can read my previous posts to get more information about my Timesheet scenario:   Part 1 Part 2 Part 3 (the Nintex® Form) Part 4 (Office 365®)   VideoCheck out the video below(Enjoy ):  Summary/Requirement OverviewEver wondered how you can present a forms version history in a user friendly format without having to rely on the Nintex Workflow® History Lis

A tricky & alternative solution to split string at specified delimiter.Thanks to KuanChiang Lui to provide this Trick.  Scenario: There have a string value (Delimiter strings) that returned from a data source or response value from a web request (SOAP or REST) and would like to split it and store into a dictionary.   Example Input Text = “1,2,3,4,5,6,7,8,9,10‌”   Expected Output Dictionary = ["1","2","3","4","5","6","7","8","9","10"]  Solutions: Check out the step by step below.Pre-requisites: Create a Text Variable and set value with "1,2,3,4,5,6,7,8,9,10".{Variable: String to Split} = 1,2,3,4,5,6,7,8,9,10‌ Step 1: Apply “Set Workflow Variables” action and configure to add XML node in between “String to Split”. Step 2: Apply “Replace Substring in String” action and configure to replace the delimiter “,” with XML node.The Output “String to Split” is becomes a valid XML as below. <values>                 <value>1</value>                 <va

Hello! I wanted a solution to remind my users that they had outstanding and overdue items. My current solution is to query a list for users with outstanding items and send them an email with a link to a page showing the items to do. While this works to a point I wanted to spoon feed them a little more. I wanted the email to include information about each item and to have a link to each item. Something like...  The list for this example is a Diary list. A simple list that sends reminders on a due date for the Event Owner to do a job and then Close or Rollover the item. Of course many don't bother closing the item so we have lot's of events that look overdue. Hence the reason for this reminder. We need to use a site workflow for this to work. First couple of Actions. Query List to capture the EventOwners and then a Collection Operation to Remove Duplicates  Query List. Filter to just overdue Items in progress and gather the EventOwner field into a collection.     Collection Operation. Re

In my previous blog post (i.e. RPA Claim Processing - Part 2: Simple OCR), we have learn how to use the built-in Simple OCR to read printed text from a PDF form. This helps us to process all inbox pdf and categorize the documents to different claim categories. Let us take a step further, instead of OCR the printed form title, if we use the same technique to OCR a PDF that is filled with handwritting, we will come to realize the Simple OCR is having difficulty to get the right recognition of handwritting for us.  The results of the Simple OCR i have tested are shown in the below captures (i.e. using PDF, Image, and Cropped Image). Take note of the Preview results, the result is somehow unpredictable and unexpected. Figure 1: Simple OCR with PDF Figure 2: Simple OCR with JPG Image Figure 3: Simple OCR with Cropped JPG Image Google Vision APIGoogle Vision API can detect and transcribe text from PDF and TIFF files stored in Google Cloud Storage (i.e. Google Cloud Vision API ). Unfortunatel

So the idea behind this was to create a master booking, I.E a photographer or doctor is coming in for a day, and we need people to signup for one of the available 10 minutes slots throughout the day for their photo flu jab.There are two lists. One to capture the main booking and the other to hold the available slots. The master booking form needs to capture the following information... Once saved we can then run the generate slots workflow. It works by simply taking the start time of the first session adding it to a collection, then until the end of the 1st session, looping through and adding the slot duration and adding that to the collection. Repeated for each session.  The workflow then creates those slots in the other list. On my home page, it shows the current open booking with a link to a booking page. This uses a filtered url to only show the relvant booking and slots. https://Applications/Bookings/Pages/BookingView.aspx?FilterField1=BookingIDText&FilterValue1=ID000008. Whic

IntroductionNot a lot of people know about Nintex RPA’s great interaction with SAP, so I thought I would create a blog about it and explain exactly how easy it is to get started. If you’re familiar with Nintex RPA (formerly Foxtrot RPA), then you should know by now that our goal  has always been to make things as easy as possible for anyone to get in and start automating their tasks. This is no different when working with SAP, and as usual the main tool is the drag-and-drop selector to build all of your SAP actions. Setup within SAPBefore getting started, it is important to enable scripting access within your SAP client. Without changing these settings, Nintex RPA will not be able to interact in the best way possible.After logging in, find the Options menu. From there, choose “Accessibility & Scripting” then “Scripting”. Check the box to enable scripting, and make sure the others below that option are unchecked.  And that’s it! There is no other setup needed within SAP or within Ni

Coming Soon: Nintex Customer Central We have some exciting news to share with you all about the forthcoming launch of our Nintex Customer Central portal. Nintex is proud to announce the upcoming release, in March 2018, of the next generation of customer self-help web portal. In conjunction with our customers we have developed an innovative and intuitive self-help web portal.   Tell me more!These are some of the features that will be available in the portal:Gain instant visibility to your usage summary of Nintex products Ability to manage your Nintex licenses, renewing, upgrading or adding. Ability to create and fully manage support cases Omni-channel user experience between Nintex products Access to Learning Central, enabling you to manage your consumption of Nintex training modules Dynamic Knowledge Central tool enabling you to search for content across all Nintex assets Access to product downloads, both current and previous versions Ability to manage your own company and contact deta

NTX PowerShell Action - Stable Release FeaturesRobust security features based on Windows Remote Management. Ability to execute PowerShell scripts from any machine allowing Remote Management from your SharePoint servers. PowerShell exceptions are handled so workflows are unaffected. OpenSource Actively Developed Automated Installation RoutinePlanned FeaturesAsync PowerShell script execution Script Repository Run worker as a centralized SharePoint service instead of in Workflow Infrastructure Pass SPServer object to PowerShell session for determining executing server. Current roadmap/planned features can be found here. DownloadsDisclaimer: As stated in our Terms of Use, Nintex is not responsible for any third-party content made available for download on Nintex Connect, whether or not this content has been reviewed and/or moderated by Nintex and regardless of who originated that content (including, but not limited to, Nintex employees, partners, affiliates, or moderators).  Users shall as

The other day I was presented a questions about a date not being presented the way the customer wanted. In Spanish typically months are not capitalized but this customer wanted to have the month capitzalied for all of their Spanish documents. At first I gave them the idea to create a formula field in Salesforce to see if they can reformat the date the way they wanted. This option was not possible as it would take weeks of approval and testing.  We were now stuck with option 2 and that was to create an excel file that would get the date from Salesforce and we will have to translate the date as needed.  I like to create two tabs in the Excel a Sheet for Input and the other Sheet for Output. The Input sheet is used for the values that coming from Salesforce. In this example it will be the date value that they are trying to translate.   Also, below the circled date you will notice a table. This table is for all of the months in English with the transtaion into spanish in the column next to

In receiving hundreds of Insurance Claims per day, we going to look into how RPA solution can help insurance companies save efforts and money hiring tens of people to do the capturing of claims, from scanned documents to claim processes. In this blog post, I am going to share how I convert a PDF file to an image for the OCR purpose. Converting PDF to image is not a mandatory step, but in the RPA Claim Processing exercise, it is a step I will need to overcome challenges that we going to discuss later. We will need some basic setup for the PDF to Image Conversion purpose, this is shared in the following paragraphs. Environment and Steps Setup:1. Python 3.7.4 2. ImageMagick 6.9.10 Q8 (64-bit) 3. Project speicific Python Virtual Environment 4. Python Wand library package install to the virtual environment5. creating a Python action in Foxtrot RPA 1. Install Python 3.7.4I am using Python 3.7.4 version on windows 10 for this exercise, I am making assumption if you are looking at running a py

Introduction & BackgroundAll the blogs in this series were inspired by an internal use case that I worked on a few months ago. The licensing software for Nintex RPA did not have any API for workflow to attach onto, so all automation needed to happen through the user interface. Using a combination of Nintex RPA, Nintex Workflow Cloud and Forms, we automated the trial provisioning process from start to finish. A user can now fill out a form online, which starts the workflow. The Nintex Workflow Cloud workflow takes the user’s input, and uses the Document Generation action to produce an Excel file. That Excel file is dropped into a cloud drive, such as OneDrive, for Nintex RPA to pick up and process. Nintex RPA recognized the file, scraped the data from it to provision the license needed. After the licensing software produced the product key, Nintex RPA passed that back off to the running & waiting workflow. From there, the workflow “unpaused” to continue with the rest of the proc

What is RPA?RPA is a configurable software tool that uses business rules and sequences of actions to automatically complete processes in any number of different applications the same way a human would, with the help of people for exception management. So, a less technical definition of RPA is simply this. It's a class of software that allows you to transact in any IT application or website typically in the same way a human would, to perform complex rule-based work. What is RDA? What about assisting people, by handling specific tasks in a larger process? Well, this is also commonly referred to as RPA, but there's an interesting twist. For software to react quickly to a person calling it into action, it most often needs to reside on the person's desktop. So as a result, this form of automation is becoming known as robotic desktop automation or RDA. RDA is a configured software that works in real-time with a human operator by presenting a predefined set of information coming from differen

If it’s a static link for the image they can follow the instructions below:      Add Rich Text Control on form      Open Control and click the insert ribbon      Click Image and select either computer or from address      Select the image (if from computer) or input the url (if “from address” selected)      Image should be available now. Click ‘Edit Source’ in the ribbon      Append <a href=”http://yourlink.com”> </a> around the image source html in the box      Save the control      This image is now a hyperlink If you are looking to do something more dynamic (based off of an entry in a field), it may be quicker to do a button, set the button type to ‘Image’ then use JavaScript to build the link.

We have just completed the release of the September update of Nintex Forms for Nintex Workflow Cloud. Watch the video below to see all the changes. 

Well it was an age old question.. As an IT Pro using Nintex, and also once I joined Nintex I was asked quite a lot "Can we capture signatures in this process ?"  The answer was almost always the same, "It depends !" When diving in and really looking at the question though, as a consultant or IT Pro in an organisation you had to ask. "Do you really need a legally binding digital signature, or do you just need a hand written signature on a form to satisfy a particular stakeholder ?" I'm not speaking on anyone's behalf, except my own; in my experience the answer was normally that a handwritten signature was needed as part of the process because that was how it is done, and will continue to be.Now I had some success in arguing that the process didn't require a signature, up until the very final phase. Thus removing 4 or 5 signatures from a process and with some strategically placed usernames and date time stamp entries from a workflow, you could removal all signatures from the process. How

 The Nintex Migration White PaperAs more organizations move from on-premises solutions to cloud-based services it is critical that their path to the world of SaaS is as obstacle-free as possible. To help in this effort, the team here at Nintex has developed a new migration guide that is meant to provide tips and considerations for Nintex customers looking to migrate their business processes from SharePoint on-prem to SharePoint Online. This content is designed to assist in planning your migration, understanding the technical considerations of moving to the cloud with Nintex, and taking advantage of the capability improvements in the cloud platform. At the end of the guide, we also highlight some additional tools that can be used to identify migration resources (such as migration partners) that can help streamline and accelerate your journey to the cloud!   Download Moving to the Cloud with Nintex!

Using the Entire Nintex Stack… In one automation project. Sounds daunting, doesn’t it?With three simple blog posts, I will break down the Nintex solution stack into three core elements, and more importantly, show you that an automation project is rather easy. In this series, you will be shown how to:  Effectively create and map processes important to your organisation Easily build forms and workflows to the processes you have Integrate RPA into legacy platforms and existing systems. In doing so, you will see different parts of the Nintex Offering, they are as follows: Nintex Promapp (Part 1) Nintex Workflow Cloud and The Workflow Generator aka the "Magic Button" (Part 2) Nintex Foxtrot (Part 3) And the best part? At the conclusion of this series, you will have your own copy of this to test in your own environment. To Automate, or Not To Automate. That is the question Over the last 12 months we’ve seen that "Automation" has taken the industry by storm, everyone is talking about it, blog

Intro:This solution will enable users to select a day and see the available appointments for that day. Environment:It uses SharePoint on-premise (I'm using 2013 but any on-premise environment will do) MS SQL database, Nintex Workflow Enterprise edition, Nintex Forms Enterprise edition(Responsive Form). Reason for this post:I have seen many posts on the community asking about creating an appointment system or another type of system where once a selection has been submitted from a dropdown that selection will not show for the next user.  This solution will be for appointments but you could easily use it to reserve a room or car from the fleet for a day using the same concept. I have made it self maintaining so there should be little to no need for an administrator to have to intervene.  There will be 16 appointments a day from 9:00am to 4:30PM (every 30 minutes) but this can be easily altered as I will explain later.  Reading posts on the community forum users wanted to select a time and

Intro & LinksThis blog post will continue a small series that I have planned, focusing on how Foxtrot RPA and Nintex Workflow Cloud are better together. The intention is to provide ways to integrate the tools until we get the built in functionality that is coming. I will focus on ways to do this using each tool’s built in functionality, rather than any extensibility capability, to emphasize the “no code” philosophy that Nintex aims for. I will update each post with links to the other posts in the series. Starting a Botflow from a Workflow (with Document Generation) Workflow Waiting for a Botflow to Finish Just like last time, I’ve got a workflow running and there is a need to interact with a legacy system, or a system without a compatible API for the workflow to hook into. Last time I talked about using Nintex Workflow Cloud’s Generate Document action to trigger the appropriate botflow. This time I will be covering how to utilize a simple email instead. Nintex Workflow Cloud setupS

Recently the topic of a state machine came up with Sean Docherty. I wanted to put thoughts to paper so that I can share my experience with the community and see what others view points are. The ScenarioIn this example I am creating a workflow for a software acquisitions process. Below is a high level view of the steps taken:1. The user fills out a basic form requesting software2. The planning team updates the form with the PRODUCT ID     a. The workflow checks to see if it has been CANCELLED3. A task is generated for the requester's supervisor to approve     a. If approved, the planning team schedules an INSTALL date and completes the request     b. If denied, the requester is notified with details on why     c. If no action is taken with 24 hours, the request is automatically cancelled For the sake of this post I am going to keep the form piece of it out and focus on the workflow that is driving the process. The Workflow  The workflow is setup to trigger when a NEW item is submitted.

I would like to share my solution to a little problem that I recently encountered in a project.  I was using tabbed forms and noticed that submitting the form, if you re-open the form in view mode you will see that the form is not appearing with first tab selected. It is selecting the tab last viewed and displaying the visible panel for that tab. What’s happening here is the choice control is saving the value internally of last option (Tab) selected before the form is saved and that’s why when you are trying to view the form it’s selecting the last value it reached and displaying the required panel that is visible for that value. (Incidentially, if you’d like to know more about choice controls and rules, go here.)That could really be confusing to the user of the form, but we can improve their experience! So before saving the form if we can set the value of the choice control to the first option forcefully, the problem can be solved.What to do? Step 1:For this you have to set ‘Store Cli

With the Introduction of the Modern View in SharePoint for O365 and ShaerPoint 2019, Microsoft have made it relatively easy to utilise their new feature which allows formatting of columns and views using JSON.Information about column formatting can be found on the Microsoft Docs site. When a Nintex workflow is published in SharePoint for O365 a workflow status column is created in the list.  I wanted to utilise the Microsoft column formatting feature to help colour code this column to make it easier to see the status of workflows at a glance. The workflow status column is not populated by default so "Set Workflow Status" actions need to be added to the Nintex workflow to update this column, which a lot of users already do. My Journey:I started off with the below sample code which I obtained from the Microsoft Docs site. The code demonstrates conditional formatting based on a columns metadata.{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json

Click HERE to see the recorded webinar from May 29th, 2019, hosted by Daniel Shai, T4 Manager, and Ayelet Gazit, Training Manager. This webinar we covered the following: • How to choose the right processes to automateWhat questions you should answer before you start How to define your parameters for success How to discover, map and implement the right processes for successful RPA • Abracadabra! Step-by-step wizard creation for contact centersWhat’s important when developing your wizards Customer use cases

We are soon to introduce some new functionality in the Rules Engine of NIntex Forms for Nintex Workflow Cloud. We are allowing rules to execute anytime without user input to make Form Input rules more dynamic and improve Submit Rules. Along with this, we are removing the Form Load rules. Check out the video below to learn more! 

With any automated process that contain approvals sometimes they can be conditionally needed to speed things up. For example, in a sales type use case let's say a Rep is allowed to give a 10% discount on any deal without approval needed. Approval then is only needed if the Rep goes rouge and gives 25%. Let’s say whenever the discount is greater than 25% then the Boss's Boss needs to get involved. This type of process is really common and creatively configuring your workflow can make something like this error free. In the picture below I am using a "Run if true" action and renamed it "Need Approval?". If you look at the configuration on the right its looking at a "OppNeedsApproval" variable and only proceeding with the actions in the box if the logic equals true or Yes in this case.  "Run if true" is great to use in this case because it is simply looking at that variable and only using this configured approval process conditionally. Let’s say now I applied a 25% discount and now my boss