Automation Snag

[Cameron_Poter]

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!!!

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

[ScottWorld]

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.)