[SOLVED] Search using Checkbox field

Applications Grid / Reports
#1

I have a grid that I’m trying to setup a search for. My field is a Checkbox, so it’s values are 0 and 1. I can’t seem to find a way to get the field to show up as a checkbox, so that either they can check it, or better yet, have the field equal true or false. The search does work if I use 0 or 1, but my users probably won’t know how to make that work.

#2

Use the lookup on the field to display what
You want to display to the user but use a one or zero to the search

Kev

#3

Thanks, I will try that out.
Been a few years since I’ve used SC, little rusty.

#4

Thanks, that worked.