Forum Discussion
BlakeHarrison
5 years agoQrew Captain
Formulas in Quick Base cannot do what you're describing. Instead, I would recommend looking into using Pipelines to perform the search. This allows you to define the trigger and parameters for the search.
You may also want to consider an alternate structure for your application where you have a single table of people - possibly "Resources". You can then setup a looping relationship for both "Referred by" and "Primary Leader" so that instead of someone typing in a name or email, these are presented as drop-downs.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
ChristinaDerhay
5 years agoQrew Member
That's a bummer. Do you know how I would do this with Pipelines? I attempted it, but I am still a beginner.
------------------------------
Christina Derhay
------------------------------