How do I use a Form to populate multiple records at the same time?

Femxx_Health · ‎Jun 23, 2022

I have a table Treatments and a table Users. Then I have a table Users_Treatments where each record is a combination of one User and one Treatment, and in addition there is a Review field (basically users review treatments they have tried).
I have already pre-populated the Users_Treatments table with users and treatments but I miss the reviews. I would like to create a Form, so that each user can add a review for each one of the treatments they have tried. Is this possible? I only managed to create a Form that however shows only one treatment per user.

kuovonne · ‎Jun 23, 2022

Not directly with an Airtable form.

If you have budget, I suggest using a 3rd party portal system, such as MiniExtensions or Softr.

If you have no budget, you could have a pre-filtered shared view for seeing user-treatments, then add a button that opens a prefilled form for submitting reviews, plus automations to merge the results of the new form submission with the original record. However I do not recommend this method. It is too easy for users to remove the pre filter and see other people’s data. And the user experience is clunky.

ChrisDrit · ‎Jun 23, 2022

I have the same comment as that from above, not directly with an Airtable form.

I do this with ease by submitting my forms to a glue service, like Make, and then send the data to any & all records I want in Airtable.

I use native Webflow forms for this, but you can really use most 3rd party form services.

HannesK-ME · ‎Nov 11, 2024

Hey there, Hannes from the miniExtensions team here. As kuovonne has already mentioned, our portal can do just what you're looking for! Your users could log in and see the treatments that are linked to them. This would then allow them to review each one, either directly inline from a grid view, or with a form (there are also several other view types available, just like in Airtable). It's super easy to set up and you can try it out for free right now by signing up for a free account! 🙂