I’m not sure this is the best way to reach the end result so let’s start from the bottom. I’m looking to have a table where the answers from different forms (but same structure) are merged together. In this way thanks to a support table in airtable/google sheet I can discriminate between them (each form is a different product - I don’t want the users to select the product by themselves).
Use Case: Online Bookings
I have product details page with forms to be completed, so each detail page now have a different form (with different url - for each product I sell) with the same form structure. I then use google sheet to append the answers, and thanks to a support table I identify the product thanks to the different URLs of the forms, but I don’t like this solution as IMPORTRANGE of gsheet (that I use to merge the different sheet with form answers) is not that solid.
Is there a more efficient way of doing so? Asking the customer to re-select the service as a question, after he/she has opened the form in a product detail page is not that great, I want to come up with a different solution.
It is important to discriminate because, as you can imagine, each booking request has to be redirected to a different person (this is done thanks to the support tble mentioned above).
If you have other suggestions on how to handle the problem you are welcome!
Best answer by john.desboroughView original