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

Question

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 Possible? It just offers me Record ID# to look up on.

I'm looking for a way to know if a value for the Key field from a previous step already exists in a table so I can create it if needed.

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

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community