Snagging Data from another table


#1

Hello there. I am new to AirTable, but really digging the features and Zapier support.

I have a database with 2 tables.

Tabel #1 has the following fields: Email, id, first name, last name, sent, open, rea.

Table #2 has the following fields: id, email, event, IP address, timestamp.

Table number 2 is auto-populated via a Webhook when someone views an email. I’d like to take the latest event and time stamp from Table #2 and have it append table #1 with the data.

I’ve tried linking the fields and using roll-up, but not having any luck. Am I looking in the right place? Is this a roll-up type function, or is there a function code that would work better?

Thanks in advance for an help or info that will point me in the right direction.


#2

Maybe Lookup: https://support.airtable.com/hc/en-us/articles/202576519-Guide-to-formula-lookup-count-and-rollup-fields#lookup