"yes" and "no" are text, not the numbers needed for a boolean value. To set a boolean value via script:
Use 1 for true and 0 for false
Use the keywords True or False without quotes.
I had just read in another forum for an older version of Filemaker that if you enter a value starting with either Y,N,T,F in a number type field FMP would automatically treate that value as a either a 1 or 0 for calculations using that field...
I don't know if this isn't true or if there are some specific stipulations that govern it or if it just isn't supported on FMP 11 but I couldn't figure it out
"I had just read in another forum for an older version of Filemaker that if you enter a value starting with either Y,N,T,F in a number type field FMP would automatically treate that value as a either a 1 or 0 for calculations using that field..."
That was correct till v 6
Do you know what would be the best way to achieve the same effect with FMP 11?
I've got a Y/N button that I want to return a numeric value to use in a summary in another field on the same table.
I've worked around it with separate dummy field that returns the needed numeric value based on an IF function but this seems messy. Is there a way that's more tidy?
How do you enter that text into that number field ?
1) Chosing by a value list in a drop-down list
2) Chosing by value list in a radio button set
3) Simply entering that text into an edit box
It's a value list in a pop-up box..
but a radio button set would be fine too.
A radio button with a value list of 1/0, a text color white ( or the background color ) and text labels Yes/No, could solve your problem ( nobody will see the numbers ).
That's great! Thanks!
Although FMP's documentation states that if you create a field and assign "Number" to it's type, then Enter "Yes", "No", "True" or "F" in the field, that the field will then hold either a 1 or a zero as it's value. See here http://help.filemaker.com/app/answers/detail/a_id/4973/~/filemaker-pro-boolean-tips
However, if you attempt to create a report layout and use summary fields to display totals, it instead displays nothing in the summary fields. Change the field data to 1's or zero's and the report layout then correctly displays summary data. This is clearly a bug in the software as it does not act as described OR it is an error in their documentation.