Automation Snag

Hi Airtable Community! I’d love to create an automation from Table A, so that when I click “Send Invoice,” it will update all the records of Table B by changing the “Sent Invoice to Client” from “No” to “Yes”. I believe I’m stuck because I’m trying to pull a string of Record IDs from Table A’s lookup field and then update the Record IDs as individual rows in Table B. Is there a way to do this?

Thanks so much for all your help!!!

Screen Shot 2021-02-12 at 3.06.51 PM|700x283

Unfortunately, automations aren’t powerful enough to do that.

You can accomplish that by writing a custom Javascript, or by using an external automation tool like Integromat, which is a low-code/no-code automation platform.

(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code.)

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.