Let’s say you have a Nintex form with a List Lookup control and over time the contents of that list changes. What happens when you view submitted forms after a selection in the List Lookup is deleted from the supporting list? Spoiler alert: it’s gone from the submitted form as well.
There are many scenarios where this could apply: for example, a form that selects people involved on a project, meeting attendees, RACI charts, and so on. If that person is removed from the list look up and you go back to view the saved form the deleted employee will no longer display where they were selected. The same could be said for a product or service in a List Lookup that was removed because it is now obsolete, an office location no longer in use, or any other value that might be removed from your lookup list when no longer required.
So, what if you need to retain this data for your records, but you also need to maintain an up to date list?
The answer lies in a workflow that will parse the IDs from the List Lookup and writes those values to another column.
First things first, we have to set up the form to capture the values from the List Lookup control. To do so, ensure the control on your form is named. This is a best practice in general and enables you to pull data from a control later.
Here is an overview of the workflow we are going to build:
You will now have turned your IDs (i.e., #;4#;#5#;) into actual text (Name1; Name2). Write this to a list column to retain it forever, whether the values are removed from your lookup list or not!
Have more questions? Elantis is the leader in Digital Transformation and offers Business Process Automation, Business Intelligence and Enterprise Content Management services. Reach out to Elantis’ Nintex certified experts today.
Rhia is a Business Process Automation expert and one of the few Nintex virtual Technology Evangelists (vTE) in the world. Her experience defining, implementing, and enhancing processes, governance, and Information Architecture has garnered industry recognition. Rhia has spoken at industry events throughout Canada and the United States.
Edmonton, Alberta — May 8, 2019 — Elantis announced three of its customers are finalists in the 2019 Nintex Solution Innovation Awards: Bittrex, DynLIFE MD, and the Alberta Teachers’ Association.The Nintex Solution Innovation Awards recognize customer organizations who are driving impactful and innovative business solutions leveraging the powerful and easy-to-use Nintex Platform.
Research on digital transformations has shown that the success rate for these efforts is low. In that case, is business process automation really worth the investment? What kind of improvements can you expect to see and what is the financial impact?
Flow provides individual productivity templates comparable to tools like IFTTT or Zapier, but it also has more powerful integration and enterprise capabilities similar to Nintex workflows. How can you make Flow work for you?