Hoping someone can point me in the right direction. I’ll do my best to explain the situation, but it’s probably a bit abstract for someone who can’t directly see what I’m working on.
I have a very long Typeform (300 questions or so) that I use to intake new customer orders. 90% of the questions on the Typeform are from the ‘Picture Selection’ question type. When the results of a completed Typeform are pushed to my Google Sheet, the picture does not show up and instead just the text does. In my case this text is normally ‘Option 1’ for example.
While I have documentation for my team to confirm what exactly ‘Option 1’ relates to, I would really prefer to be able to provide them the exact image of the selection that was chosen. This could be by updating or formatting the results in Google Sheets to the appropriate image (so I would basically format each question/answer as Answer A = Image A, Answer B = Image B, etc.) --- Not actually sure if this is possible, couldn’t figure it out.
Another workaround or option as well would be automatically creating a Google Drive folder, and then dumping the ‘results’ into that folder. But again, the results I would want dumped into this folder would need to be the images, not the text (‘Option 1’) --- Same thing could also work if these images could be dumped into my project management tool, ClickUp.
Hopefully this all makes sense? If anyone could point me in the right direction it would be greatly appreciated!