This topic is locked

Check Box

4/9/2011 2:58:01 PM
PHPRunner General questions
H
horsey_kim author

I have created some online registration forms that store the data in a database. PHPrunner has been working great for that. But I have one problem with the check boxes.
I have a liability statement(agree field) that the registering person must agree with in order to finish their registration. I want it to be a check box. If I use the checkbox feature on the data field it does not give me the option to make it required. I can with a radio button, but I don't want a radio button, because most people are accustomed to clicking a box.
How do I get the check box (which only allows one choice agree)to become required. If they don't agree then the registration does not go through.
Any ideas?
Kim

H
horsey_kim author 4/10/2011

Figured out what I needed, under Edit As - do not use checkbox, instead:
select Lookup wizard; choose list of values and only put in 1 value, then make it required. Leave the default value empty. Then if they don't check it, it will stop registration.
something I learned
I wanted a statement like Yes I am over 18 years old and concent to the liability agreement next to the check box.
But I only wanted the word Yes to be stored in the database. So I set the field size to 3 in the table. I then added the entire statement in the lookup wizard's list of values. When it saves it chops off all the statement except the first 3 characters to fit the table. HOWEVER, be sure you do not put special characters in your statement. If you do, then you get "Ye instead of Yes. I think Quotes are automatically put around anything with special characters in it.