Forum Discussion

adi38612's avatar
adi38612
Frequent Visitor
2 years ago

Text Filter Facing conundrum!!

I am using Text Filter Visual to filter out values in a table and the SELECTEDVALUE function shows the output based on it. The input is name of a person in the text filter, and if the name is found ...
Need Help
Tips and Tricks
parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

adi38612 I understood your question and that's why I asked what the behaviour should be, assume someone enters "Johns" only, and what would be the return in case there are two values as listed below:

 

Johnson

Johnsabc

  • adi38612's avatar
    adi38612
    Frequent Visitor
    2 years ago

    In case, user searches for anything that is not available in the column 'name', it should return a 'blank' only.
    So if only John, Johnson and Johny are there in the table, and if I search for johns, it should return a 'blank'.