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.