Jump to content
  • 0

"Show All" and "Match blank values" for the same field



I am seeing more and more of posts sharing their discoveries so I figure I share something I found out about as well. This may not be a common workflow and some people might know this already but here it is:

So when creating search forms, we can only select either one of these options for a field.
But some scenarios calls for both of them. Like in my case, I have records without a value in a certain field and for us, that means the record is still unassigned and at times, we need to search for unassigned records but other times we also need preview the entire list to see which needs to be prioritized as it is sorted out by the date.

So for that, I need both "Show All" and "Match blank values". To create this,

1. Add two criteria for the  field.

2. Set the first criteria's Form element to "Dropdown" and add the options as you normally do. Add a default option with a blank value to show all records. In Advanced tab, set "If left blank:" > Ignore field in search criteria.

3. For the second criteria, change the label to "Unassigned" or any preferred label for records with blank values on that field. Then change the comparison type to "Is Blank". The Form Element should automatically change to "Checkbox".

4. Create a Rule to avoid users from ticking unassigned and selecting a value at the same time.
Criteria: (Criteria 1) is not blank
Actions: (Criteria 2) disabled

I hope this somewhat helps. 

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...