Two Options Field returns Yes, No and blank in advance finds

(0) Share

Report

Posted on by Community Member

We have a Two Option field on our Opportunity forms. When that field is included in advanced finds, it returns three results: yes, no, blank. How can I get it to return just yes/no?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

Create on-demand workflow that will set that field to "No" value.

Create advanced find where that Two Option field "Doesn't contain value", on results retrieved run on-demand workflow.

That's it.

Explanation is pretty simple - it seems that you created that "Two Option" field after some data was created. So for those records data was not populated and when you added field - for existing records value for a field was null (even you set 'default' value for it).

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report

Hello Robert,

Seems this is data issue , As you are in on premise just go to the table and update all null to some default value.

Also I am not sure what kind of customization you have for the entity , it's not expected value. Two options always contains 0 or 1.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

that explains it! thanks...

Was this reply helpful? Yes No