How can I merge data in many fields into 1 simple table

Yuyiota24634Yuyiota24634 Bangkok ThailandCommunity Member Qubie ✭

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

Answers

  • JenCXJenCX Broomfield, COCommunity Member Superuser ✭✭✭✭

    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.

  • Yuyiota24634Yuyiota24634 Bangkok ThailandCommunity Member Qubie ✭

    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..

Sign In to Comment