Skip to main content

Form for adding user with multiple email

  • August 29, 2022
  • 2 replies
  • 50 views
M

Hello,
In my base I have 2 tables: Users and Emails. They are linked together because one user can have multiple emails.

Users

Id|First name|Last name
1|John|Doe
2|Sam|Harison

Emails

Id|Address|User id
1|john.doe@gmail.com|1
2|sam.harison@gmail.com|2
3|sam.harison@yahoo.com|2

I want to create a form in which user has to provide first name, last name and one or more emails. How can I achieve this in Airtable? Of course after submission data should be stored in tables with correct relationships.

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hmm, sadly I don’t think there’s a nice way to do this natively with Airtable forms

Assuming your form is in the Users table, a possible workaround would be to get your users to key in their emails comma separated, i.e. test@gmail.com, test@yahoo.com

You could then have an automation that ran on form submission that would paste those comma separated values into the linked field to the Emails table, which would create a single record per comma separated value

If you want your users to be able to have separate input fields for each email, I think you might have to look into a third party tool like miniextensions or something

Adam, Airtable Consultant - thetimesaving.company
ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9808 replies
  • August 30, 2022

@Mikolaj_Wasniewski Is there a maximum amount of emails that you want to allow? For example, 5 emails? If so, you could create 5 separate email fields on your form, and then after the form is submitted, create an automation that takes those emails and puts them in the appropriate place.

Otherwise, as @Adam_TheTimeSavingCo mentioned above, you would need to use the form from MiniExtensions.com or On2Air: Forms to create linked records by using the form itself.


Terms & ConditionsAccessibility statement