Hello.
I have a "main" form that captures 8 specific questions. Then there are several more questions that may be needed depending on the user input. (Think of one of those questions that if you answer yes, they then want you to elaborate on.) I have all this info saved in one table for ease of queries later. I tried using a modal form to "pop up" with the click of a check box. Problem, this creates a new record in the table. Do you have a better idea on how to accomplish this task. Would like this to be easy to recreate as more questions are being added while this is being developed.
Example:
after the eight general questions, (name, age, etc).
Some questions may be just yes/no's
Others need further info other than yes/no to qualify. Example: Payment Agreement Meet? y/n, Then need to add payment request date and payment rec date.
I have a "main" form that captures 8 specific questions. Then there are several more questions that may be needed depending on the user input. (Think of one of those questions that if you answer yes, they then want you to elaborate on.) I have all this info saved in one table for ease of queries later. I tried using a modal form to "pop up" with the click of a check box. Problem, this creates a new record in the table. Do you have a better idea on how to accomplish this task. Would like this to be easy to recreate as more questions are being added while this is being developed.
Example:
after the eight general questions, (name, age, etc).
Some questions may be just yes/no's
Others need further info other than yes/no to qualify. Example: Payment Agreement Meet? y/n, Then need to add payment request date and payment rec date.