tleitzke

Better Find

Discussion created by tleitzke on Apr 19, 2017
Latest reply on Apr 20, 2017 by tleitzke

I am trying to make a list be filtered by several fields (by value list), and I want to be able to have some fields just be empty- but still Perform Find and find everything. I tried using an if statement to check if the specific fields are ' "" ' (Which I think is the same as being empty), but, it did not work as I thought it would. Pretty much brings up nothing on any search (even when I put the 3 selector to a known working record).

 

-I want to be able to have empty fields not obstruct finds

-I don't want to have a long script doing every 'empty' scenario with the 3 fields (which is only 9, but that is excessive)

 

I couldn't really find anything for having empty criteria be ignored.

Outcomes