Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

Pipeline: Look up a Record based on the Key field?

I'm trying to have a Pipeline step do a "Lookup a Record" action.  It will let me do the lookup for a Record ID, but I have a custom Key field and I want to lookup based on that Key field. Is that...
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
In my use case I was able to solve my roadblock by creating the Record unconditionally if necessary by making a Bulk Record Insert, adding a Row and then Committing the Upsert.  hat way if it already exists, it would have no effect.   But I'm still curious if a record can be looked up by the Key field as the Lookup only seems to offer a lookup based on Record ID#.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
KristofferKeen1's avatar
KristofferKeen1
Quickbase Staff
5 years ago
Mark- It is true that the "Look up a record" step only allows Record ID (regardless of a custom key field).  However, as an alternative, you can use the Search Records step to search for any fields, including a custom key (and if needed, you could add a Limit to only return 1 record).  Then as a subsequent step, you could add a query that if the search returned "empty records" you can create the missing record.



------------------------------
Kristoffer Keene
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Good to know!  I did not realize that you could filter on if the search returned no results.  That is what I was missing.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------