How to read data from one table into another?

[lynnstar]

Hi all, I am using Fillout Form integrated with Airtable. I have two tables in one airtable base. One table lists all the eligible emails that can login and fill out the form. The second table is where the form submissions land. I would like to be able to tell who has actually submitted a form from the "Eligible email table". 

Essentially I would like to automatically "read" the "modified time" column found in the "Submission Form Table" within the "Eligible email Table" when the emails in the columns match. 

From what I understand formulas in airtable cannot talk to each other across tables? And the lookup function doesn't have a way connect that the emails match? Am I missing something? 

I have tried this formula but nothing is appearing in the box and I'm not sure why: 

IF({FORM EMAIL (from 2025 Form Submissions)} = {Eligible Email}, "Submitted")

[lynnstar]

UPDATE: I was able to come up with a solution, though it feels a bit cumbersome, if anyone has any pointers please let me know! I don't like having to make extra columns in my tables: I linked the two tables and added a lookup for the "created time" in my "Eligible emails" table (this creates 2 new columns there), one column is auto created in the other table.

Then I created an automation: when a record is created from a form being submitted, it updates a record in the "Form submission table". I have the linked "eligible email" column fill with what what submitted in the "form email" column. Since it's linked to the other table, it auto fills in the info I want in the "Eligible email" table.

[TheTimeSavingCo]

Yeap that's the recommended way to handle it!