How to make Multipicklist value filter for null values in the record.

Prateek,

What have you tried? Does a condition where Field__c = null not work for you?

Hi Matt, I have tried multi picklist filter and it does not allow me to add custom condition. Please tell me how to achieve this as the requirement is to use multi picklist with checkbox and the None value in the filter will return the result for Null/None both. Thanks

I believe this is a solution: https://community.skuid.com/t/how-do-i-filter-a-reference-field-using-a-multi-select-pick…

You may also want to take a look at this: https://community.skuid.com/t/filter-table-using-or-a-value-entered-by-the-user

and this: https://community.skuid.com/t/make-filter-field-look-like-a-table-filter

Thanks! Matt So, the listed picklist values for multi select filter are Apple Mango Banana None If I select None then the data displayed on the table should be with None and Null values also. So, the solution which you provided above will work. Right?

Assuming you set up your condition and ui-only multipicklist field to do that, then yes. 🙂

Thanks! Matt If you don’t mind I am very new to this Skuid. I would love if you help me to tell me more about the steps to create the UI onlly field and condition to work with it. I am stuck with this task and not able to solve this.

Sorry, I don’t have extra cycles to do your work for you at the moment. Go ahead and see what you can do with the threads that I linked to. Maybe then when you’ve gotten a start you can send your xml so we can take a look and suggest specific next steps.

Here’s one more similar thread: https://community.skuid.com/t/filter-table-by-multiple-values-of-string-fields-entered-by…

Thanks! A lot Matt. Sure, I will try from my end to do this. If still I found any difficulties I wil let you know.

Hey, Matt

I tried the creating a UI only multipicklist with the values, and created the condition and used that UI only field for filter on that page but it doesn’t returns anything.

Thanks

If you show us your setup, we might be able to identify where you’re going wrong.

I created a UI only Multi picklist with Picklist Source as Manual and values where 

Apple
Mango
Banana
None

And the added condition which was looking for the original field value with UI only field.

After that I just added the filter on the table with multi picklist value and when I select any of them 0 results are returned.

Can you just tell me a very simple steps.

Like 

If I created the UI only field with the picklist values,

Now how this will have the value which will work in the filter, as the UI only field is not having any existing values.

You need to do this:

1. Create your multipicklist in its own ui-only model.
2. Create a filterable default off condition on your table’s model, in multiple values mode (but don’t fill anything in)
3. Create a model action on your ui-only model so that when your multipick field is updated, it activates and sets the value of your table model’s condition to the value of the multipick.
4. Add a field editor to your page to display your multipicklist field.

Also, you may need to use some branch logic in your action sequence when the ui-only multipicklist is changed, to decide whether to deactivate the condition (if the field doesn’t have a value).

You may also want to use a “none” branch so that if the value is “None” you also activate a Field__c = null condition.