Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Automatic fill of the gender field by searching for the same first name among the existing records

Topic Labels: Automations
110 1
Showing results for 
Search instead for 
Did you mean: 

Hi there! I have a big table with business founders, and I’m looking for a method for new records to auto-complete the gender field by searching the same first name in the table and looking up the gender.
How can it be done using automation?

1 Reply 1

Hi @Vadim_Ciobanu1,
This should be easily accomplished, but what will you do if the first name is shared by more than one gender option? Is there a more unique way of looking up the person, like an email address?

Are the records being created from a Form, coming from another site, or are users entering the new record right into Airtable?