Help

Lookup based on Form Input

Topic Labels: Formulas
1214 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Vandesm14
4 - Data Explorer
4 - Data Explorer

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)

1 Reply 1
Pete
7 - App Architect
7 - App Architect

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?