Solved
How can I merge data in many fields into 1 simple table
To whom may be concern,
I want to merge data from 3 fields that have the same answer and question into 1 simple table.
I can do separate 1 field for 1 table but when I group 3 fields the table data was not correct.
Best regards,
Yuwadi Otaravanna
Best answer by JenCX
Good morning! What I would suggest doing is to create a fourth field with embedded data. In your survey flow, use branch logic to check if each of your three similar questions are answered and if so, fill the embedded data field with the answer. Then, use the embedded data field in your reports and hide the other three.
+11Good morning! What I would suggest doing is to create a fourth field with embedded data. In your survey flow, use branch logic to check if each of your three similar questions are answered and if so, fill the embedded data field with the answer. Then, use the embedded data field in your reports and hide the other three.
Dear JenCX,
Thanks for your kind. But I have a problem if three field have an answer and not the same answer such as field 1 answer A field 2 answer B and field 3 answer C... How can I do that..
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.