I am trying to use integromat to collect multiple record IDs, and then dump them together into a many connection field.
Steps are
Find base records
Search for related records
Group related record IDs into an array
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:
I’m not sure if I’m setting the array properly.
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.
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.
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
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?
