Forum Discussion

NMarin's avatar
NMarin
Qrew Member
12 months ago

pipelines update parent record from child record

hello,

I have two tables. 

parent named location has a field serial number
child named equipment also has a field new serial number 

they are related by parent - Record #ID with a text reference proxy  "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

 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. 

thx

-N



------------------------------
Nic M
------------------------------

4 Replies

Sort By
  • BrittanyLipinsk's avatar
    BrittanyLipinsk
    Qrew Trainee
    11 months ago

    Did you ever solve this by the way?  Stuck on the exact same issue.



    ------------------------------
    Brittany Lipinski
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew #1 Challenger
      11 months ago

      This should be easy.  You would trigger a Pipeline when the child record is added or edited and the serial changes. 
      Then search for the parent record based on the  field for related parent in your app.
      The a For Each loop to update the serial.  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's avatar
        BrittanyLipinsk
        Qrew Trainee
        11 months ago

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



        ------------------------------
        Brittany Lipinski
        ------------------------------