Help with update record automation

I’m confused about why you’re not linking the records and using a lookup field? It seems like that would be the easiest & quickest way to solve this problem, because unfortunately, you won’t be able to do what you want with automations — unless you write your own custom JavaScript.

Unfortunately, the “Find Records” action (and the subsequent “Update Record” action) doesn’t work in the way that any of us would expect it to work.

The “Find Records” action is an almost-useless action unless you know JavaScript. In my personal opinion, it would be a good idea for Airtable to remove the “Find Records” action until it can be fixed for all users, not just JavaScript-savvy users.

The only thing the combination of “Find Records” & “Update Records” can do is return an array of Record ID’s that you can then paste into a linked record field (or a text field). That’s about it. I can’t think of anything else you can do with it, except pass it onto a JavaScript for looping through the array — which is what you would need to do in your case to get the results that you’re looking for.

What you were expecting is what most of us were expecting, which is that Airtable would loop through the found Record ID’s and update each one of the records that it found. But unfortunately, it won’t do that.

In your final screenshot above, you’ve pasted in the “List of Record ID’s” into the “Record ID” field, but the “Record ID” field can only handle a single Record ID. You pasted in an entire array of Record ID’s expecting Airtable to loop through each one of those records and update each one of those records, but unfortunately, Airtable can only handle ONE Record ID there.

So unfortunately, the only real solution for this sort of an automation scenario is to write a custom JavaScript to loop through the Record ID’s, or if you want to stick with a low-code/no-code platform, I highly recommend Integromat (this link contains my referral code for Integromat).

I would also email Airtable at support@airtable.com to ask them to improve/fix how this functions.

The documented current purpose is to render a list of records within the body of an email using the Send Email/G Mail action.

Thank you, that’s another action that I forgot! I can see that being useful.

I was only thinking about what else we could do with it for updating records, and I couldn’t think of anything useful besides pasting it into a linked record field (or passing it onto a JavaScript).

No word on if they’ll do it, but I can see some time in the future them adding a separate “Update records” action to take in an array of record ids.

I’m confused about why you’re not linking the records and using a lookup field? It seems like that would be the easiest & quickest way to solve this problem, because unfortunately, you won’t be able to do what you want with automations — unless you write your own custom JavaScript.

Unfortunately, the “Find Records” action (and the subsequent “Update Record” action) doesn’t work in the way that any of us would expect it to work.

The “Find Records” action is an almost-useless action unless you know JavaScript. In my personal opinion, it would be a good idea for Airtable to remove the “Find Records” action until it can be fixed for all users, not just JavaScript-savvy users.

The only thing the combination of “Find Records” & “Update Records” can do is return an array of Record ID’s that you can then paste into a linked record field (or a text field). That’s about it. I can’t think of anything else you can do with it, except pass it onto a JavaScript for looping through the array — which is what you would need to do in your case to get the results that you’re looking for.

What you were expecting is what most of us were expecting, which is that Airtable would loop through the found Record ID’s and update each one of the records that it found. But unfortunately, it won’t do that.

In your final screenshot above, you’ve pasted in the “List of Record ID’s” into the “Record ID” field, but the “Record ID” field can only handle a single Record ID. You pasted in an entire array of Record ID’s expecting Airtable to loop through each one of those records and update each one of those records, but unfortunately, Airtable can only handle ONE Record ID there.

So unfortunately, the only real solution for this sort of an automation scenario is to write a custom JavaScript to loop through the Record ID’s, or if you want to stick with a low-code/no-code platform, I highly recommend Integromat (this link contains my referral code for Integromat).

I would also email Airtable at support@airtable.com to ask them to improve/fix how this functions.

No word on if they’ll do it, but I can see some time in the future them adding a separate “Update records” action to take in an array of record ids.

Kamille, thanks for being a staple within the community. I recently stumbled upon BuiltOnAir and have been backlogging episodes. Keep up the good work.

Yesss, that would be amazing! That would really open up an entire world of possibilities, and I think that’s what all of us were initially hoping for as the companion to the “Find Records” action.

I’m confused about why you’re not linking the records and using a lookup field? It seems like that would be the easiest & quickest way to solve this problem, because unfortunately, you won’t be able to do what you want with automations — unless you write your own custom JavaScript.

Unfortunately, the “Find Records” action (and the subsequent “Update Record” action) doesn’t work in the way that any of us would expect it to work.

The “Find Records” action is an almost-useless action unless you know JavaScript. In my personal opinion, it would be a good idea for Airtable to remove the “Find Records” action until it can be fixed for all users, not just JavaScript-savvy users.

The only thing the combination of “Find Records” & “Update Records” can do is return an array of Record ID’s that you can then paste into a linked record field (or a text field). That’s about it. I can’t think of anything else you can do with it, except pass it onto a JavaScript for looping through the array — which is what you would need to do in your case to get the results that you’re looking for.

What you were expecting is what most of us were expecting, which is that Airtable would loop through the found Record ID’s and update each one of the records that it found. But unfortunately, it won’t do that.

In your final screenshot above, you’ve pasted in the “List of Record ID’s” into the “Record ID” field, but the “Record ID” field can only handle a single Record ID. You pasted in an entire array of Record ID’s expecting Airtable to loop through each one of those records and update each one of those records, but unfortunately, Airtable can only handle ONE Record ID there.

So unfortunately, the only real solution for this sort of an automation scenario is to write a custom JavaScript to loop through the Record ID’s, or if you want to stick with a low-code/no-code platform, I highly recommend Integromat (this link contains my referral code for Integromat).

I would also email Airtable at support@airtable.com to ask them to improve/fix how this functions.