Jun 10th, 2012, 6:43 AM
Hello michatmaster7, thanks for your interest and replies.
The three fields that would store numbers such as 1777456 I had wanted to specify as an INT type in the mysql table simply to keep them as pure integers with no alpha text characters or even commas allowed.
I had hoped that if the Custom Fields Module allowed integer types as a field type selection that it would have the Validation Rules included to automatically restrict the entries for these three fields to number and nothing but numbers.
Of course, as you say, the validation rules to pre-parse the user entries to warn them and thereby prevent them from entering anything other than pure integers are the most important part of the form.
It was my hope that a Custom Fields Module would have those rules already and that I would have access to them automatically if I could choose an INT field option instead of a varchar.
Ben has kindly replied to me in the past days and told me that the INT type is not available in this module.
So, I will have to modify the form code to apply to those three fields, with some sort of jquery parsing to make sure I get just integers without letters or commas.
Thanks for your interest!
The three fields that would store numbers such as 1777456 I had wanted to specify as an INT type in the mysql table simply to keep them as pure integers with no alpha text characters or even commas allowed.
I had hoped that if the Custom Fields Module allowed integer types as a field type selection that it would have the Validation Rules included to automatically restrict the entries for these three fields to number and nothing but numbers.
Of course, as you say, the validation rules to pre-parse the user entries to warn them and thereby prevent them from entering anything other than pure integers are the most important part of the form.
It was my hope that a Custom Fields Module would have those rules already and that I would have access to them automatically if I could choose an INT field option instead of a varchar.
Ben has kindly replied to me in the past days and told me that the INT type is not available in this module.
So, I will have to modify the form code to apply to those three fields, with some sort of jquery parsing to make sure I get just integers without letters or commas.
Thanks for your interest!