Pre-populating Answers and Repeating Sections
In my organisation, forms need be signed-off by several levels of management before they are complete. If they're unsatisfied with anything, this can be passed back to the previous stage. This means I need to save and recover the current answers, then pre-populate them in the form at each stage.
Currently I do this by saving answers to a SQL database, then recalling them as a comma delimited string and using a substring to 'cut up' the answers. I did try extracting each answer as a row in a Collection (by using a Pivot table in SQL), but this required a separate variable for each element and in larger forms, lead to the workflow being too large to save.
There doesn't appear to be a way to do this with Repeating Sections. I can't find any way of specifying which index you would like to refer to within a Repeating Section, and this also makes saving answers very difficult (though I found a method of doing this).
To pre-populate answers, you'd need to consider JSON, comma delimited lists as an input, or at least allow users to specify an index. Specifying index 4 for example would allow the user to per-populate the 4th instance, and create instances 1-3 if they don't already exist, to ensure it's in the correct place.
A general 'repopulate using previous answers' option would be ideal - similar to what Survey123 does, but integrated into the workflow. In my mind, it would bring back the form in the same state it was submitted earlier in the workflow, with all the answers pre-populated.
Ideally it would also work within loops, to allow the user to create a workflow which loops through different levels of authority, while keeping the current answer set.
alan_fire
shared this idea
Thanks for your suggestion.
I will update the ticket if we have anything to share on this idea.
Cheers,
Euan
-
Ankur
commented
any update on this? We are looking for this feature to move our Workflows from O365 to NWC.
-
Vicentiu Nae
commented
In the Nintex Workflow Cloud Form we are using the repeating section, the process starts with Form submission then proceed with Task Approval. When developing the Task Approval Form we cannot get the repeating section values to be added on the Task Approval Form.