Forum Discussion
KristofferKeen1
5 years agoQuickbase Staff
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
------------------------------
------------------------------
Kristoffer Keene
------------------------------
MarkShnier__You
Qrew Legend
5 years agoGood 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------