CiviCRM Community Forums (archive)

Hi all,

I have a custom data field. Which is Alphanumeric - CheckBox.
I have a profile that searches the value of this checkbox.

All the data I importing from another database has the output values to -1 or 0.
-1 means the option was selected
0 means it was not

I want the profile search to return any Organisations that have this box checked.

The question is, how do I make the custom data checkbox read the data as -1 = shows this result and 0 = dont show this result.

I hope that made sense, and any help would be GREATLY appreciated.

edit: So I seem to have worked out that creating a new field for each checkbox means I dont have an issues with setting the same values for each checkbox. However it wont allow me to set -1 as a value. Even if I could... Is this how I should be doing it? Because I am not using the profile as a means to enter the data. Only for searching.

What about the 0's? Will they just be ignored (not returned as search results) if the Value is set to 1?

And am I going at this the right way?

Right thats working. How do I get fields that have the 0 in not to show on the search results page? I only want the ones that have a 1 in to show.

Same question for other fields too.

eg. Organization comes up through a search on Organization Name. But theres no Postal Code entered. So can I make the Postal Code data field not show?

So I can choose which fields get included in selector.

But theres no way to set fields that are blank to not show when hitting the view button of the organization? Every data field that is included in the profile will show up there whether its blank or not?

Thanks for replies btw.