Oct 1st, 2014, 2:53 AM
Thanks for the screenshots! They are very helpful.
Since you are using a separate database field for each choice, you probably want to have just a single checkbox (for each database field) that will record a null value (nothing) if it is not checked, and some other value if it is checked.
For that, you want an Option list with just one line. I would suggest naming the Option List something generic like: Single Checkbox. That way you can easily use it across multiple database fields without getting confused. The Field Value should be something that makes sense for when you print out (or display) the data. I would suggest setting it to something like: "selected" or "yes". You can leave the Display Text blank since it's probably not needed in this case (it would probably just be a duplicate of the database field Display Text).
After saving this Option List, assign this Option List from the drop down that is shown on the Checkboxes Settings tab (your 3rd screenshot) for the three database fields. Use this same Option List for all three of the database fields. I would probably delete all the other Option Lists to avoid confusion. (Note, don't delete any Option Lists that you might need for other parts of your form, or other forms.)
One thing that might help to remember is that Option Lists are independent from any particular database field, or from any form. One single option list can be used for multiple database fields in multiple forms. They are simply a list of choices. So keep them as generic as possible so that you can easily reuse them as needed without confusion.
Using this setup, your form should end up with:
A line that says: CEN with one checkbox next to it
A line that says: ShowmePdf with one checkbox next to it
A line that says: Showme Print with one checkbox next to it.
These labels are based on the Display Text value that you have entered in your database fields as shown in your first screenshot.
If this doesn't end up working for you, here are some additional questions that might point us in the right direction. (Maybe I should have asked these earlier instead of making some assumptions.)
What version of Form Tools are you using?
Is this an Internal, Form Builder, or External form?
At this point, what's not working right?
Since you are using a separate database field for each choice, you probably want to have just a single checkbox (for each database field) that will record a null value (nothing) if it is not checked, and some other value if it is checked.
For that, you want an Option list with just one line. I would suggest naming the Option List something generic like: Single Checkbox. That way you can easily use it across multiple database fields without getting confused. The Field Value should be something that makes sense for when you print out (or display) the data. I would suggest setting it to something like: "selected" or "yes". You can leave the Display Text blank since it's probably not needed in this case (it would probably just be a duplicate of the database field Display Text).
After saving this Option List, assign this Option List from the drop down that is shown on the Checkboxes Settings tab (your 3rd screenshot) for the three database fields. Use this same Option List for all three of the database fields. I would probably delete all the other Option Lists to avoid confusion. (Note, don't delete any Option Lists that you might need for other parts of your form, or other forms.)
One thing that might help to remember is that Option Lists are independent from any particular database field, or from any form. One single option list can be used for multiple database fields in multiple forms. They are simply a list of choices. So keep them as generic as possible so that you can easily reuse them as needed without confusion.
Using this setup, your form should end up with:
A line that says: CEN with one checkbox next to it
A line that says: ShowmePdf with one checkbox next to it
A line that says: Showme Print with one checkbox next to it.
These labels are based on the Display Text value that you have entered in your database fields as shown in your first screenshot.
If this doesn't end up working for you, here are some additional questions that might point us in the right direction. (Maybe I should have asked these earlier instead of making some assumptions.)
What version of Form Tools are you using?
Is this an Internal, Form Builder, or External form?
At this point, what's not working right?