Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to filter a data set by relationship: Related or Unrelated.
My data set does not have this parameter included however the logic to determine this is if "rel" is located in the Name.
I am trying to write an expression in a list box to have this behave accordingly.
If Related is selected, then I would like to see that logic applied to the other selections and vice versa if Unrelated is selected.
Any help would be greatly appreciated!
write this in your listbox in general tab Field - Expression
= IF(WildMatch(clientname, '*rel*')>0, 'Related', 'Unrelated')
What is the field name for your listbox and what are the values this lisbox holds now? Are there only two values like Related and Unrelated or you want to search a string in this field for Rel and Unrel values? Can you elaborate with an eg so that we can help you quickly. ?
Field Name is clientname
The table for this field looks something like this
clientname|
abcdrel
abcrel123
xyz321
I would like two values in the List Box: Related and Unrelated
If I select Related, I would like to results for all client names with "rel" in it.
Thanks so much the help!
write this in your listbox in general tab Field - Expression
= IF(WildMatch(clientname, '*rel*')>0, 'Related', 'Unrelated')
Many thanks!! Worked like a charm