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.