pipelines update parent record from child record

Question

hello,I have two tables.&nbsp;parent named location has a field serial numberchild named equipment also has a field new serial number&nbsp;they are related by parent - Record #ID with a text reference proxy&nbsp; "location ID" to the child.the trigger is set so when i create / change a child record and i fill in "set" a new serial number I would like the parent serial number updated to serial number in the child..I have tried many options&nbsp;I can't seem to find out how to push the new serial number from the child to the serial number field in the parent table.&nbsp;thx-N------------------------------Nic M------------------------------

brittanylipinsk · Answer

Did you ever solve this by the way?&nbsp; Stuck on the exact same issue.------------------------------Brittany Lipinski------------------------------

markshnier__you · Answer

This should be easy.&nbsp; You would trigger a Pipeline when the child record is added or edited and the serial changes.&nbsp;Then search for the parent record based on the&nbsp; field for related parent in your app.The a For Each loop to update the serial.&nbsp; In practise there will only be one parent to update, arising out of the For Each Loop.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

brittanylipinsk · Answer

You're right - that was such a simple fix.&nbsp; Thank you!&nbsp; I was making it way more complicated 🤦‍♀️------------------------------Brittany Lipinski------------------------------

nmarin · Answer

Thank you both. I'll give&nbsp; that a try as well.------------------------------Nic M------------------------------

Forum Discussion

pipelines update parent record from child record