Jump to content

Count of settings to use in a calculation


This topic is 4405 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Brief question:

Got an object. One field (field A) is a checkbox set. Another field (field B ) is a calculation. What I need, and can't seem to figure out, is this:

In the calculation in field B, for filemaker to count the amount of checkboxes. I.e. if three boxes are checked, return value 3, if four are checked, return value 4, etc.

any idea how this is possible?

Thanks!

OP

Link to comment
Share on other sites

If that didn't work, then your checkbox field is not defined as you first described it.

A field formatted as a checkbox set, with a value list of choices will contain a return-delimited list of values, one for each item checked. Place a copy of this field on your layout, formatted as an Edit box so that you can see the values in the field.

How do you define your field and the value list that is assigned to it?

Link to comment
Share on other sites

I never know what to reply to that...

Does this work for you?

Yes it does! Thanks!

If that didn't work, then your checkbox field is not defined as you first described it.

A field formatted as a checkbox set, with a value list of choices will contain a return-delimited list of values, one for each item checked. Place a copy of this field on your layout, formatted as an Edit box so that you can see the values in the field.

How do you define your field and the value list that is assigned to it?

From the example which was posted by consultant, I found my mistake - the checkbox was fine, i.e. it was in the same format/definition as the one in the uploaded file. The issue was that I had field B defined not as a calculation, but as a numeric field which I had validated by calculation (which, oddly, worked for other fields, which were numeric. I.e. the calculation of (field c) x 2 worked perfectly. But valueCount did not.)

Thanks - it works now!

OP

Link to comment
Share on other sites

This topic is 4405 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.