Skip to main content

Hi,


i have created 2 tables, one for houses (woningen) and the other one users.


So the users have a profile with for example min and max what they want to pay for a house.


So the house goes to a filter of all the users profile


to not overwrite the user that is added to the field i am using a array aggrergator. because i want to send the users in a list to have multiple users instead of one that is overwritten


but it gives me this error:



BundleValidationError

Validation failed for 3 parameter(s).



  • Collection can’t be converted to text for parameter


Have you tried listing all the linked records separated by commas? It’s been awhile, but I recall not needing to turn it into an array for adding multiple linked records.

Have you tried listing all the linked records separated by commas? It’s been awhile, but I recall not needing to turn it into an array for adding multiple linked records.




@Carl how seperate ‘10.ID’ it by commas



@Carl how seperate ‘10.ID’ it by commas


Okay, so I am wrong. Just using a list might be in Airtable’s own automations. I swear I’ve done it like that before. But regardless, you don’t need the array aggregators, just use add array function.


add ( array ; value 1 ; value 2 ; … ) (https://www.make.com/en/help/functions/array-functions)


What I’m doing here is adding the new ID into the existing array in an update Airtable record action.


Here’s a screenshot:

Okay, so I am wrong. Just using a list might be in Airtable’s own automations. I swear I’ve done it like that before. But regardless, you don’t need the array aggregators, just use add array function.


add ( array ; value 1 ; value 2 ; … ) (https://www.make.com/en/help/functions/array-functions)


What I’m doing here is adding the new ID into the existing array in an update Airtable record action.


Here’s a screenshot:


@Carl

nothing is added to the field in airtable:




Okay, so I am wrong. Just using a list might be in Airtable’s own automations. I swear I’ve done it like that before. But regardless, you don’t need the array aggregators, just use add array function.


add ( array ; value 1 ; value 2 ; … ) (https://www.make.com/en/help/functions/array-functions)


What I’m doing here is adding the new ID into the existing array in an update Airtable record action.


Here’s a screenshot:


@Carl without add, stays 1 users because its overwrite the old one



@Carl without add, stays 1 users because its overwrite the old one




Hey @Jabir_Tisoudali ,


Linked records field expects array of record ids. Something like


[ "rec111","rec222","rec333"]

The aggregator returns array of objects (with each object being {“IMTKEY”:“recXXX”}), so that does not match the destination.


You should transform the array of objects to simple array using map function. If I am not mistaken something like this:


map(yourArrayo] ; __IMTKEY__)

@Carl

nothing is added to the field in airtable:





I’d double check that you’re mapping a new ID when you do the add(array;value) formula and not one that is already in the original array. I just did the same set up and it worked as expected.

Reply


Terms & Conditions