Hey folks! I’m trying to figure out something in Airtable and could use some help. I’ve got two tables: one called ‘Data’ with Male and Female name lists (about 30k names each), and another called ‘Work’ with Name and Title columns.
What I want to do is:
- If a name from ‘Work’ is in the Male list, show ‘Herr’
- If it’s in the Female list, show ‘Frau’
- If it’s not found, show ‘no data’
I did this easily in Google Sheets, but I’m stumped in Airtable. Is this even possible here? Or am I barking up the wrong tree?
Basically, I’m trying to automate addressing people as ‘Dear Sir’ or ‘Dear Madam’ in German based on their first names. Any ideas on how to tackle this in Airtable? Thanks in advance!
hey there FlyingLeaf, try linking ur work table to data with a lookup. then use a formula field like IF(OR({LookupMale},{LookupFemale}),IF({LookupMale},‘Herr’,‘Frau’),‘no data’). hope this helps!
I’ve dealt with similar name-based categorization tasks in Airtable before. One approach that worked well for me was using a combination of lookup fields and a rollup field.
First, create two lookup fields in your ‘Work’ table, one for Male names and one for Female names. Then, add a rollup field that combines these lookups.
The formula for the rollup could be something like:
IF(NOT(BLANK({Male Lookup})), ‘Herr’,
IF(NOT(BLANK({Female Lookup})), ‘Frau’,
‘no data’))
This method is pretty efficient and scalable, even with large datasets. Just make sure your name lists in the ‘Data’ table are comprehensive and up-to-date.
One caveat: this approach assumes gender binary and might not work for all names or cultures. Consider adding a manual override option for edge cases or non-binary individuals.
I’ve faced a similar challenge in Airtable, and I think I can help. You can achieve this using a lookup field and a formula field in your ‘Work’ table. First, create a lookup field that searches for the name in both the Male and Female lists from your ‘Data’ table. Then, create a formula field that uses this lookup to determine the appropriate title.
The formula would look something like this:
IF(FIND(Name, {Male Names}), ‘Herr’,
IF(FIND(Name, {Female Names}), ‘Frau’,
‘no data’))
Replace {Male Names} and {Female Names} with the actual field references from your lookup.
This should give you the desired output. Keep in mind that this method assumes names are unique to each gender list. For names that could be either gender, you might need a more complex solution.