Hey guys, I have two tables—Email Info and IPT. When a checkbox is clicked in Email Info for any domain, the domain and any one corresponding email address and its ID should be updated in IPT. I may select multiple checkboxes at the same time.
Inbox details have multiple emails and ids.
First, create two formula fields in Email Info. One formula extracts the first email from your array, and the other extracts the first ID. You can use REGEX for this. Once these formulas are set up, the values are ready to use.
Then create an automation that triggers when the checkbox is checked. The automation takes the domain, extracted email and ID and copies them into the IPT table.
Taha, Views And Bases
Check out this guide on how to find and link existing records via an automation:
https://support.airtable.com/v1/docs/linking-existing-records-using-automations
Instead of linking, you’d just do the date updates you mentioned
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.