Transpose / Rotate Form Responses

Hello

I need to collect answers from my clients, to 20 different questions each month. I then put a photo beside the clients answer and have Zapier send the photo and the corresponding answer, to the Instagram of the client, through Buffer.

I’m assuming I will need a seperate table for each client and that it will look like this:
CLIENT TABLE 1
|Q1|Response|Image|Date|
|Q2|Response|Image|Date|
|Q3|Response|Image|Date|

My Airtable Form responses end up in a table like this though…
Client 1 | Q1 Response | Q2 Response | Q3 Response etc
Client 2 | Q1 Response | Q2 Response | Q3 Response etc
Client 3 | Q1 Response | Q2 Response | Q3 Response etc

Which is not really helpful for me, since I need to add the image etc…

How can I rotate that data? Or is there a completely different way to do this that I’m missing!

Thanks!

As far as I am aware, forms can only insert records into a single table. So instead of providing clients with the same form, you would want to create a table for each client in advance and then send each client the link to the form related to their own table. Alternatively, if you just want to separate out each client’s responses for your own visibility, you could give each client their own addressable “code” that they would insert into a form. And then from your table, you can filter each view based on that code. This assumes you would want to prevent your client’s from seeing each other in the form, otherwise you can just use a single-select (depending on the number of clients).

I can see why this would be a challenge with Zapier because you need to declare a specific table in advance. Perhaps someone else can chime in with a Zapier solution.

Thank you for replying! I’m still looking for a solution. Maybe I can hire an expert to create some custom code?

Hi @Kirstie_Mcconnell,

All of this can be easily accomplished with Integromat.

If you’d like to hire an expert to help you with your project, I am an expert Airtable consultant and an Integromat Partner. Feel free to contact me through my website at ScottWorld.com.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.