11 Replies Latest reply on Sep 15, 2014 2:54 PM by philmodjunk

    If Checkbox Selected Enter "1" Into Field

    JoshuaGagnon

      Title

      If Checkbox Selected Enter "1" Into Field

      Post

      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 those in the field 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?