Mark, so what about a Pipeline that will copy only the fields of a record, that are answered 'No'? So say there are 100 questions, these random 18 questions were answered no, pipeline them to a separate table, where a Form can be generated for those questions?
I think you are misunderstanding the capabilities of a form. You can't just create a new form on the fly with random fields on it.
So like I said you can use Form to specify to open certain fields subject to conditions.
For example. Suppose Q1 (which is a multiple choice field - Yes / No) is
[Do you have any Pre-existing medical conditions?]
Then you can have a form rule that says when that is answered as "Yes", then
Show the field called [Describe all your pre-existing medical conditions]
Require the field [Describe all your pre-existing medical conditions]
Thank you for the reply, I'm on the same page regarding not being to create a form on the fly. I was mostly referring to using Pipeline to copy the fields to a second table, to have a form created there. Mostly to keep the field values separate for auditing purposes, in case the original value vs. the updated value (since the 'NO' questions will be addressed). I'm also trying to understand all my options in accomplishing this in QB, since I still have a lot to learn. If copying the field values to another table (and successive form) isn't a good option, I'm guessing I can just create a new form with a lot of rules to Hide/Show the questions and actions (which might end up being the solution)
The simplest solution like you laid out might be the best one.
