Sep 30th, 2014, 6:47 AM
Thanks for the additional information. The determination about one or three database fields can be somewhat arbitrary and might depend on what the process will be after the person fills out the form.
The first question is can the person select just one option or multiple options. If only one, I would suggest one database field and then you would use radio buttons instead of checkboxes. If they can select multiple options, then you could go both ways. If you choose to use just one database field, it will have all of the selected values included in the field. So the field would have to be large enough to store all of the potential values. (If each Field Value is only one character, you would need the database field size to be at least Tiny and maybe Small. I can't remember if it will add any spaces or commas.)
The other option is to go with a database field for each of the three options (Newsletter, Show Me Print, Show Me PDF). Then I would suggest using an Option List with Yes/No as the two Option Fields. You could assign this same Option List to each of the three database fields. Then your results will give you a Yes or No value for each of the database fields.
Regarding the email, which version of Form Tools are you running? It may be a version problem if you are on 2.2.7. Otherwise, it may be related to how your fields and Option Lists are setup. Keep in mind that if the database field isn't big enough to store all the data, then nothing will be stored. I would suggest setting your database field size larger than you think you might need until you know things are working properly.
The first question is can the person select just one option or multiple options. If only one, I would suggest one database field and then you would use radio buttons instead of checkboxes. If they can select multiple options, then you could go both ways. If you choose to use just one database field, it will have all of the selected values included in the field. So the field would have to be large enough to store all of the potential values. (If each Field Value is only one character, you would need the database field size to be at least Tiny and maybe Small. I can't remember if it will add any spaces or commas.)
The other option is to go with a database field for each of the three options (Newsletter, Show Me Print, Show Me PDF). Then I would suggest using an Option List with Yes/No as the two Option Fields. You could assign this same Option List to each of the three database fields. Then your results will give you a Yes or No value for each of the database fields.
Regarding the email, which version of Form Tools are you running? It may be a version problem if you are on 2.2.7. Otherwise, it may be related to how your fields and Option Lists are setup. Keep in mind that if the database field isn't big enough to store all the data, then nothing will be stored. I would suggest setting your database field size larger than you think you might need until you know things are working properly.