Getting a Filter to Show "Other" Number

  • 1
  • Question
  • Updated 5 years ago
I am trying to set up a filter based on a number field. For the most part the numbers will be 3, 6, 9, 12, or 24 representing months). It is possible however for a user to enter a custom value. I have a filter working now that lets them show the specified values but I would like to have an option to filter by any values that are not the above stated list. I created a second condition that the Length Field is not in the set of values (3, 6, 9, 12, or 24) and set it to "can be modified by filters, but is off by default" Added an Other Option and Set it to be affected by Other Conditions and defined my new condition but It is not working so Obviously this is not correct.

Is having this other option possible with numbers? If so how can I get it working?
Photo of Jessica Shier

Jessica Shier

  • 208 Points 100 badge 2x thumb

Posted 5 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Jessica, unfortunately right now we do not allow a filter to activate a condition that has more than one value in it.  We are working to improve Skuid to enable this feature in our filters, but it doesn't work yet. 

The only way I can think to get the feature you are interested in is to create a formula field on your object that is a simple boolean.  It will be off if the numbers are correct, and on otherwize.  Then you can create a filter that shows all records where the boolean is on.  You can even add that entry to the end of your existing Number Field filter drop down list by adding a new filter source (add a truck icon) and lable (tag icon) and a source effect (coffee cup icon).  The source type would be manual,  the label would  Affect another condition.  And in the coffee cup area you would activate the condition that filtered based on that boolean. 

I'm sorry if that that sounds like greek.  If you need a more step by step review let me know. 
Photo of Jessica Shier

Jessica Shier

  • 208 Points 100 badge 2x thumb
That worked! Thank you for the good work around!
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Well, two thumbs up for you.  One for getting it to work, and another for being able to read my convoluted instructions!  Glad we got you to success!