Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
2 years ago

Pipeline between two apps

I have two applications both with the same type of field [ID Number] I want to update records in one application [App 2] only when there is a matching ID numbers in both apps. For example, If john smith has ID Number "123" and there is a John smith with the same ID "123" in the other app, then update ...



------------------------------
Phelan Sanders
------------------------------
  •  This seems to be pretty straightforward with a Pipeline.

    The pipeline would trigger when a record is changed or added in app one. 

    The next step would be to search app to filtering where the ID is equal to the ID from the trigger record.

    Then you would do a for each loop to update all of the records that match.  I'm not sure if you also want to do a name match in addition to the ID but that would be part of the search criteria.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------