Hello,
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!