Show all when checked?

[pmcfarlain]

I have a search and report for current projects. Some of these projects are on hold and so I want to create a field in the search to display all projects when checked but when not checked just show projects that are not on hold (field should say "Include jobs on hold?" and be unchecked by default). I'm at a loss for how to do this. In my table, the value for "On Hold" is just a checkbox, where checked is true and unchecked is false.

I'm open to any ideas for how to do this, even if it requires shuffling things around. Thanks!

[TellMeWhy]

48 minutes ago, pmcfarlain said:

I have a search and report for current projects. Some of these projects are on hold and so I want to create a field in the search to display all projects when checked but when not checked just show projects that are not on hold (field should say "Include jobs on hold?" and be unchecked by default). I'm at a loss for how to do this. In my table, the value for "On Hold" is just a checkbox, where checked is true and unchecked is false.

I'm open to any ideas for how to do this, even if it requires shuffling things around. Thanks!

It might be better to use Dropdown or Radio button for the On Hold Field so you get Yes, No, and Any option.

If you want to use checkbox, you'll have to use this option

There would be no way to display all records regardless if it's On Hold or Not, though.

[pmcfarlain]

1 hour ago, TellMeWhy said:

It might be better to use Dropdown or Radio button for the On Hold Field so you get Yes, No, and Any option.

If you want to use checkbox, you'll have to use this option

There would be no way to display all records regardless if it's On Hold or Not, though.

Alright, thanks!