Question

Multiple forms generated from a single form

Updated November 22, 2018

asked on November 13, 2018 • Show version history

I have a form that is filled by a single person the (initiator), based on a field on the collection named number, we have 3 options, if number is 1 start new form for 1, if number is 2 start new form for 2, if number is 3, start new form for 3 all this forms will be initiated simultaneously. now the problem I am facing is that the forms do separate but the information will remain in one form and the other two will be blank on the collection field instead of having their respective collections and also if we have attachments they remain with the first form only.

0 0

Replies

replied on November 13, 2018

This is interesting..I've attempted this before (and failed). The issue with 3 forms if the data will always be separate on the backend - you won't be able to name the same fields with the same variable (as far as I know).

Even if you create one form with 3 different sections (depending on the path chosen you would show one section and hide the other two) you will still have the same variable problem.

The only option as I see it is to get a custom SQL query involved, write the info from the forms in to SQL, then output from SQL to the final form.

0 0

replied on November 13, 2018

Hey Anthony, hope all's well. Another option I think you could use if you weren't looking to use SQL (which is almost certainly the best way to go if you can) would be to create multiple identical copies of that intermediate form and rename the variables to reflect which form that field comes from (variableName_1, variableName_2, etc.). Then have a final form which arranges those variables for output.

Obviously this makes management of the process that much more complicated, as you'd have to mirror changes to the intermediate form multiple times to ensure the fields are all in sync...

0 0

replied on November 13, 2018

Thanks, Andy. That's another option I didn't think of.

0 0

replied on November 22, 2018

Hey all, I managed to get this working, instead of using parallel gateways I used one workflow to separate the tasks and another to combine the task into one at the end of the process

0 0

You are not allowed to follow up in this post.

Question

Question

Multiple forms generated from a single form

Replies

Sign in to reply to this post.