Many to Many connections as input for pipe

[slimpens]

Hi,

i have a user table and a child table. Each child is connected to a User. User’s can have multiple childs.
Is it possible to run a pipe, based on the child data of all records? Currently I have a connection field (Child 1 and Child 2 in the case of 2 child), since I need to have the data stored in both Child records for a individual pipe input parameter.
Is this possible?

So.

User

• Child 1 field number value =100
• Chuld 2field number value = 50

Input Pipe

Input pipe = parameter 1 = connection field number value child 1
parameter 2 = connection field number value child 2

Run pipe (multiply parameter 1 by parameter 2)
Pipe response = 5.000

[Kristen]

I don’t think this is possible, but maybe someone has a creative idea for how to do this?

You could do this in make.com if you use the search function to find all the children and then multiply your results and store back in the User table. That would have to happen with a trigger or a schedule.