Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Automation Snag

170 1
Showing results for 
Search instead for 
Did you mean: 

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
Table B

1 Reply 1

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