Single form that creates multiple records


#1

Hi All. I believe I know the answer to this, but I wouldn’t be doing my due diligence if I didn’t ask the community.

User wants to have a form that will provide entry into multiple records.

FORM would look like this;
Date: 20180410
Name: Joe Bloe
Product: Banana, Apple, Pears

OUTPUT INTO TABLE would look like this;
Date/Name/Product
20180410 / Joe Bloe / Banana
20180410 / Joe Bloe / Apple
20180410 / Joe Bloe / Pears

Can this be replicated?


#2

I don’t think this can be done using only Airtable’s functionality. But it strikes me as something that could be done using Zapier

It might also be possible using Google Forms and importing the resulting .csv either manually or in some automated way - but I’m less knowledgeable of that.

Lastly, it should be possible via a custom web form that hits the Airtable API.


#3

It can be replicated in Airtable with one caveat: It would require for a field value to be copy-and-pasted into (onto?) another field. This can be done manually (Ctrl-C, Right-Arrow to adjacent field, Ctrl-V or Click-and-drag fill handle to adjacent cell) or through a service such as Zapier.

I recently put together a demo base for client evaluation where such a copy/paste routine generates over 460 records.


#4

I could be wrong, but I don’t think that the c/v method is an option in Form view. I tried to convince the user to use the table view for entry as it is much easier to enter data however, the user maintains his need to have the data entry in a Form only.

The live scenario is an attendant one the phone with a client while entering data. In this scenario, I would think that Zapier wouldn’t be as effective as in other scenarios. There’s other relationship there like quantity of fruit etc.

I’m not well versed in API but will look into that option.

Thanks for both your help!