Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Aug 12, 2021 11:47 AM
Hi Everyone,
I have 3 tables:
Objective: When new records and emails are added to Table B and Table C, link and update the emails to Table A (and eventually more tables that require the exact same automation). Because Table C has some people that were in Table B, and some now people, the email updating is required, to either overwrite an email in Table A that came from Table B, or add a new one altogether if the record doesn’t yet exist in Table A.
Method:
This automation works as intended for Table B to Table A. But not for Table C to Table A.
Problem: When I try to do the same thing with Table C, the automation fails. The only difference with this 2nd automation is that I want the email in Table A, which was carried over from Table B, to now reflect the latest email in Table C.
Troubleshooting: In Action 2, I have tried to change the record ID 4 ways and have gotten the following errors:
I’ve been messing with this for hours and still can’t seem to get it to work. In reality, I have a few more fields that I am trying to keep up-to-date, not just emails. Any help would be greatly appreciated, thank you!
Update 8/12 11:55am: I tried to split the 2nd automation in 2, where the first automation links, and the 2nd one overwrites the email. This is still returning an error for the 2nd automation.
Automation 1:
Automation 2:
I am still getting the same errors in the 2nd automation.