Response in Checkbox Field Generates A "1" or "0"

[Josh Gagnon]

Hello,

I am working on a database that has a checkbox field "Ethnicity" that has the following options:

Hispanic or Latino

N.A. or Alaskan

Asian

A.A. or Black

White

N. Hawaiian or P.I.

This works fine for our staff entering data needing to identify students. However, when we prepare a report for the government each year each checkbox needs to reported separately as a 1 or 0 (for yes or no). Here's an example:

Hispanic or Latino if selected needs to report "1" in the Ethnic field. If not selected it needs to report a "0" in the Ethnic field. Similarly, if N.A. or Alaskan is selected it needs to report "1" in the Ethnic2 field or a "0" if not selected. This continues through Ethnic6. Ethnic1 through 6 need to be labeled that way because that's how we must upload them to the government report. Can these fields auto populate based on a calculation looking at what is/is not selected in the "Ethnicity" checkboxes?

[jbante]

Yes. If you give the Ethnic[x] fields auto-enter calculations that over-write the field, or just calculation fields, you can use a calculation like this:

 

not IsEmpty ( FilterValues ( "Hispanic or Latino" ; Table::Ethnicity ) )

 

This calculation will return True (1) when "Hispanic or Latino" is one of the selections in the checkbox. 

[eos]

 

Hello,

I am working on a database that has a checkbox field "Ethnicity"

 

Shouldn't that be a radio button set …?

 

See if the attached file helps you.

RadioButtons_eos.fmp12.zip

[jbante]

Shouldn't that be a radio button set …?

 

I'm pretty sure a checkbox set is correct for this one. Ethnicities are not mutually exclusive, and the government's requested export format seems to be consistent with that.