Hi there, I have a form in one table which users can fill out. One of the input fields is asking for their email address. Now I would like to automatically find this user with the provided email address in another table which contains additional information of that user. Is that possible automatically without manual linking to a record?
In Google Sheets I have this kind of formula to solve the problem but I cannot find something similar in Airtable: =ArrayFormula(IF(ISEMPTY(B2:B);;IF(ISERROR(COMPARE(B2:B;Database!B:B;0));“Participant not in database”;HYPERLINK(CONCAT(“docs.google.com/spreadsheets/d/1234567890/edit#gid=1234567&range=B";COMPARE(B2:B;Database!B:B;0));"Details;%22Details) of participant”))))