Skip to main content
Topics#Data ManagementTim Holland's Question
Tim Holland (Tower Rock Oil & Gas) asked in #Data Management
Jun 4, 2015, 4:39 PM

Flow dynamic choice lookup using only non-null inputs

Hi!  Question relevant to Flows, but perhaps to SFDC queries in general.  I have a screen where I have 10 different input fields for possible search filters.  The user might enter 3 of them, leaving the other 7 blank.  I then take this information and use it in a dynamic choice lookup to create a list of matching objects.  How can I do this?

 

Without any 'magic', the dynamic query looks for objects with the 3 matching fields AND for objects where the remaining 7 fields are null.  This isn't what I want...the 7 other fields can be ANYTHING.

 

I've tried setting up the dynamic choice/query to reference formulas instead of the actual input fields, with the formulas for each of the 10 input fields saying if(isblank(A),"*",A).  It didn't work...I don't think you can use wildcards for entire fields...ie, wildcards from what I read only work after the first character is provided.

 

Any ideas or suggestions?  Thanks!
3 answers
  1. Emily McCowan (Mav3rik)
    Jun 8, 2015, 10:20 PM

    Nice one Tim, I feel like these tricky workaround "hack jobs" are required more often than the straightforward use cases :) at least in my experience!

Write an answer...
0/9000