1 Reply Latest reply on Jul 12, 2013 11:02 AM by philmodjunk

    "Yes" being evaluated as " Yes" via the Data Viewer



      "Yes" being evaluated as " Yes" via the Data Viewer


      FileMaker Pro



      Operating system version


      Description of the issue

      I was evaluating a checkbox in a script that is using a custom value list.  The custom value list uses "Yes" when the checkbox is checked.

      If checkbox equals "Yes" do something, else do something different.

      One record evaluates the checkbox as " Yes" (extra space) and another evaluates it as "Yes" no space.

      I'm attaching screen shot of both instances of the Data Viewer.

      Steps to reproduce the problem

      I don't know how to reproduce it.

      Expected result

      The Data View should be evaluating "Yes" as "Yes" 100% in all instances.


      I couldn't find a work around.

      My first thought was to evaluate for either "Yes" or " Yes". 

      If the dataviewer picks up a " Yes" with an extra space there does not appear to be a work around.

      For instance if...

      Data Viewer checkbox ABC value reads " Yes"

      If ABC is not equal to " Yes"

      This is IF statement is evaluated as TRUE when it should be evaluated as FALSE


        • 1. Re: "Yes" being evaluated as " Yes" via the Data Viewer

               On your layout, make a copy of the check box formatted field and change the copy's format to an edit box.

               On a record where you see that extra space in the data viewer, click in the edit box formatted copy and see if there is an invisible character, such as a return character present in the field. A return character might produce what you are seeing here but would not keep the check box field from showing "yes" as the selected value.