First of all I swear I’ve googled this, and I’ve seen some answers that indicate the thing I’m trying to do is possible but I haven’t actually been able to make those solutions make sense for my purposes.
Basically, I have two tables. I’m planning a wedding. So one table has our guest list broadly, with columns for “table” and “household” and “category” and “plus one?” and such. The primary field is “Name”
However, we’re using airtable to collect addresses for save-the-dates/invitations/etc. So there’s another table called “Addresses,” which receives form submissions (it’s actually a whole zapier/netlify situation because I wanted the form to be prettier, but basically, it’s a form). The addresses table also has “Name” as the primary field.
All I want to do is automatically link one table to the other. Theoretically the names are the same, and if they aren’t, it usually means I need to update the “guests” formula with the person’s full name, so it’s useful for me to see where the link fails.
Unfortunately, the Lookup and Rollup fields only want to look at linked fields that already exist. Is there a way to do what I’m trying to do? I’m sort of thinking (sorta fake psuedocode, resembling SQL)
Guests.AddressLink = LinkedRecord FROM Addresses WHERE Addresses.Name == Guests.Name
Seems doable but I cannot for the life of me figure out how. Help?