Airtable update record updates only first item in array in a Bundle

Questions
,
1

:bullseye: What is your goal?

Update Airtable records based on a search that returns several days and several records within those days.

:thinking: What is the problem & what have you tried?

I have the following Make setup:

  • Airtable “Find Records” → Iterator → Airtable “Update Records”

The search step returns one Bundle per day, and within that Bundle is an array with IDs for the records to be updated. The Iterators gets the array (heading level, [ ]) from the search as input, and outputs one Bundle per day, with the records as sub-Bundles.

The Airtable update has the array from the search step for Record ID (the records to be updated), the sub-level with the number ([ ]).

The scenario returns the right amount of updates (in this test, 2 days and 9 records total), but only processes one of the record, one in each day-Bundle. So it processes the same record 4 times for day 1, and another one 5 times for day 2.

:clipboard: Error messages or input/output bundles

Ìterator Output

Bundle 1Collection
Record ID rec1G1OtMnE3pg
Bundle order position 1
Total number of bundles 4
Bundle 2Collection
Record ID recVdaIKcMhtTG
Bundle order position 2
Total number of bundles 4
Bundle 3Collection
Record ID recU2q2WXk1i0w
Bundle order position 3
Total number of bundles 4
Bundle 4Collection
Record ID recmhfTMQ1unkS
Bundle order position 4
Total number of bundles 4

Then the Update output shows that there are 4 operations for the first record ID, and then 5 for the first one in the second Operation

Thank you for any insights in how to get all the record IDs updated!

Rgds,

Björn

3

Hello Bjorn,

Here is your problem - you are referring to the same data over and over.

So what you should do? Map Record Id used by Update Records to data generated by iterator.

But there is a catch - you should use a second iterator to update each record (iterate through array of record ids to be updated), one by one, or use a bulk update module if it will fit your use case.

If you need any additional help or I understood you wrong - please attach some screenshots - especially update record module and scenario.

Have a nice day, Michal