Populate a many field using Integromat

Hi,

I am trying to use integromat to collect multiple record IDs, and then dump them together into a many connection field.

Steps are

  1. Find base records
  2. Search for related records
  3. Group related record IDs into an array
  4. Put array into many connection field

With Knack, I was able to accomplish a similar thing by splitting the array using the code below but Tadabase returns errors if you have more options in the “dump” than exist in the array. Knack just ignored the parts of the array that didn’t exist.

{{get(map(6.array; “id”); 1)}}
{{get(map(6.array; “id”); 2)}}
{{get(map(6.array; “id”); 3)}}
etc.

So I have two issues:

  1. I’m not sure if I’m setting the array properly.

  2. I don’t know how to then properly place the array (which could have from 1 to 10 record IDs associated with it) into the many connection field properly.

Anybody have experience doing anything similar?

image

Is this an Integromat or Tadabase question?

As far as Tadabase, you just need to pass a comma seperated value of your record ids.

Like:
3kjZqnEQ6V,q3kjZDVN6V

As far as how to do this in Integromat, hopefully someone else can assist. I keep intending to learn their platform just haven’t found the time yet.

Hey @moe,

It’s a little bit of both actually. Tadabase has an integromat integration (I’m guessing you delegated that portion!), but it doesn’t let me use the same method to populate a many field as I was able to in our previous system.

I was just hoping someone in the community may have already figured it out. Integromat is one of the most useful tools I have ever used. Much better than Zapier, although they serve slightly different purposes and function slightly differently.

Right now there are several things either not working, or missing from the integromat integration, so I can imagine it’s an early work in progress. Things missing like date filters, and things don’t work like the instant triggers (I actually use Zapier, where the Tadabase instant triggers do work, to trigger my integromat scenarios).

If anyone out there has any advice/direction for me, please let me know!

Adding one more piece @moe. The one problem that is seemingly on the Tadabase side, is that it’s not accepting the array unless all of the values in my {{get(map(6.array; “id”); 1)}} to {{get(map(6.array; “id”); 10)}} all exist.

I have used this method in the past to account for the fact that it could be anywhere from 1 to 10 record IDs, and not a set amount. So I guess my question could be summed up as “How do I use integromat to place an array of an unknown size, into a many connection field in Tadabase?”

It sounds like the answer right now is that nobody knows yet. I will update this if I’m able to figure it out.

Thanks,

Chris

Hi @Tophinity I am fairly familiar with Integromat. Can you email me the JSON file for the scenario & I will have a look at it? Cheers

1 Like

Hey @brad! I really appreciate it. I’m sure it’s something that I just don’t understand, since I learned from Zapier on up, rather than from writing API calls on down. There’s a reason I use low and no code platforms :sweat_smile:

I created a sample scenario specific to the issue I’m having here. It won’t let me attach the JSON and it’s too long to post as well. So here’s a Google Drive link to it: https://drive.google.com/file/d/1ZL45DKydiizkJaGCcsALh8p6x7lXPn3j/view?usp=sharing

And here’s the data from the Advanced Log when I tried to run it:

    Search for Community - Search Records5

    The module was initialized.
    Search for Butlers - Search Records6

    The module was initialized.
    Create Array of Butler Record IDs - Array aggregator7

    The module was initialized.
    Assign Butlers to Community - Update a Record8

    The module was initialized.

    The scenario was initiated.

    Cycle #1 was started.
    Search for Community - Search Records5

    The operation was started.
    Search for Community - Search Records5

    <see browser console>
    Search for Community - Search Records5+0.6s

    <see browser console>
    Search for Community - Search Records5

    The operation was completed.
    Search for Butlers - Search Records6

    The operation was started.
    Search for Butlers - Search Records6

    <see browser console>
    Search for Butlers - Search Records6+0.7s

    <see browser console>
    Search for Butlers - Search Records6

    The operation was completed.
    Create Array of Butler Record IDs - Array aggregator7

    The operation was started.
    Create Array of Butler Record IDs - Array aggregator7

    The operation was completed.
    Assign Butlers to Community - Update a Record8

    The operation was started.
    Assign Butlers to Community - Update a Record8

    The operation failed with an error.
    Error

    Validation failed for 10 parameter(s).

         - Missing value of required parameter 'Record ID'.

         - Missing value of required parameter 'Record ID'.

         - Missing value of required parameter 'Record ID'.

         - Missing value of required parameter 'Record ID'.

         - Missing value of required parameter 'Record ID'.

         - Missing value of required parameter 'Record ID'.

         - Missing value of required parameter 'Record ID'.

         - Missing value of required parameter 'Record ID'.

         - Missing value of required parameter 'Record ID'.

         - Missing value of required parameter 'Record ID'.
    Search for Community - Search Records5

    The Rollback Phase has been started.
    Search for Community - Search Records5

    The Rollback Phase was completed.
    Search for Butlers - Search Records6

    The Rollback Phase has been started.
    Search for Butlers - Search Records6

    The Rollback Phase was completed.
    Create Array of Butler Record IDs - Array aggregator7

    The Rollback Phase has been started.
    Create Array of Butler Record IDs - Array aggregator7

    The Rollback Phase was completed.
    Assign Butlers to Community - Update a Record8

    The Rollback Phase has been started.
    Assign Butlers to Community - Update a Record8

    The Rollback Phase was completed.

    Cycle #1 was completed.
    Search for Community - Search Records5

    The module was finalized.
    Search for Butlers - Search Records6

    The module was finalized.
    Create Array of Butler Record IDs - Array aggregator7

    The module was finalized.
    Assign Butlers to Community - Update a Record8

    The module was finalized.

    The scenario was finalized.

Moe, I am also in need of aggregated records ids into csv format from a list of certain records that meet a condition. I need to store those records Ids in to a text field as you outlined so I can store them into a one-to-many connection.

Is there no way run a Tadabase pipe and search for specific records and then run a process to aggregate all the records IDs into a CSV without Integromat (now its called Make)?

Integromat can do this but the problem is that in order to trigger Integromat, I have to a webhook. This means that I can’t do this from an action link or form and allow further action rules to WAIT for Integromat to finish. There isn’t that functionality. So I have a form that does bulk updating of records and first updates the one to many connnection. However, further action rules are supposed to look at that one to many connection field and there is no way to prevent those action rules to wait for Integromat to finish. This creates a problem since I need Integromat to finish before those rules can run.

This is why Integromat is not going to work in my case. Does this make sense?

Hi @Tophinity,
Please try the following and please let me know if it works for you:

1 Like

Hey @IMTConnectorDev

Appreciate you being here with us! Welcome! And thank you for the assistance :+1:

1 Like