Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 10, 2020 10:00 AM
So I have a “Members” table with “Name” and “Email” as fields
I also have an Activity form for activity checks as “New Members” table.
They put in their email in, and submit the form. This is then placed in the “Email” field.
I want to display their name in the “Name” field of the “New Members” table using lookup. I know I can use the link to another record field, but that isn’t automatic. Is there a way to take the table’s “Email” and set a value to the “Name” field based on the email that was provided (executing a lookup to the “Members” table)
Mar 13, 2020 05:08 PM
Hi there – it sounds like the New Members table might be better as a view on your members table. Mind reviewing this support article and letting me know if this seems like a solution?