Field validation based on checkbox

[dfricke10]

I have an order entry form with 2 checkboxes, one for Ship and one for Pickup. There's a shipping address section. What I want to do is have the field requirement be active only if the Ship checkbox is checked.

So if the order is Ship, then the shipping information is now required fields.

Any help pointing me in the right direction would be appreciated.

Thanks!

[mvaughn]

Re: Field validation based on checkbox

David, one way to accomplish this is to add a hidden field named TOGGLE. Change it to Numeric with a default value of 0.
Then, in your checkbox OnClick event, change the value of TOGGLE to 1 as in: {dialog.Object}.setValue('TOGGLE', 1);
Next, in the checkbox's Client Side section, enter TOGGLE = 1 as the value for the Show/Hide proerty.

You can TOGGLE most everything in alpha this way!

Have fun!

[GGandhi]

Re: Field validation based on checkbox

This will not make the fields required, simply show and hide.
You will need to add code in the dialog.validate function to see if that checkbox is selected and the shipping information is filled in.
If not cancel submission and pop up message saying those are required to process.

[dfricke10]

Re: Field validation based on checkbox

I've added this in the Validation Xbasic section of the field.


if e.data.Ship = "true" then
if e.data.Ship_Attention = "" then
validate_Ship_Attention.hasError = .t.
validate_Ship_Attention.errorText = "Ship_Attention cannot be blank."
end if
end if


'Ship' is the checkbox and 'Ship_Attention' is one of the fields I want to validate. And believe it or not, it works. I would have to enter this in each field that I want to validate. And is this clean or will it cause problems down the road?

[GGandhi]

Re: Field validation based on checkbox

the data entry person is an unpredictable entity, you need to control them. they will skip the fields and crush all the efforts you put in.
do the following.
go to clientside events, select canSubmit event and type the following code. this is if your ship or pickup field name is type and it is a character field and address, city, state, zipcode fields are defined and required if the type is ship

var type = {dialog.Object}.getValue('TYPE');
var address = {dialog.Object}.getValue('ADDRESS');
var city = {dialog.Object}.getValue('CITY');
var state = {dialog.Object}.getValue('STATE');
var zipcode = {dialog.Object}.getValue('ZIPCODE');
var msg = "";
if (type == "ship" & address == "") {
msg = msg + "address cannot be blank";
}
if (type == "ship" & city == "") {
msg = msg + "\ncity cannot be blank";
}
if (type == "ship" & state == "") {
msg = msg + "\nstate cannot be blank";
}
if (type == "ship" & zipcode == "") {
msg = msg + "\nzipcode cannot be blank";
}
if (msg != "") {
alert(msg);
return false;
}

this will popup appropriate message and prevent any saving if the required data is not present.

take a look at this video:
http://screencast.com/t/tLKb9jEyth7

[mvaughn]

Re: Field validation based on checkbox

validation.pngValidation Rules will accomplish the same as above. Just check the box "Enable Rules" and "Require Value".
You can then check off your conditions and add your own message in "Custom Message".

[GGandhi]

Re: Field validation based on checkbox

Michael
I did check that to see if this can be enabled conditionally depending on the checkbox value, did not seem to be.
That method is to require value all the time, the method I have suggested depends on the value ship or pickup.
Even though I can popup alert message when the fields are empty, the user needs to go to the field and then only the popup works.
My suggested version is not dependent on the user, it simply controls them to add the required data.

[dfricke10]

Re: Field validation based on checkbox

Perfect! Thanks Gandhi!

My checkbox is a logical field so this is what I used.

var type = {dialog.Object}.getValue('SHIP');
var firstname = {dialog.Object}.getValue('SHIP_ATTENTION');
var lastname = {dialog.Object}.getValue('SHIPATTN_LASTNAME');
var address = {dialog.Object}.getValue('SECSTREET');
var city = {dialog.Object}.getValue('SECCITY');
var state = {dialog.Object}.getValue('SECPROVINCE');
var zipcode = {dialog.Object}.getValue('SECPOSTALCODE');
var msg = "";
if (type == "1" & firstname == "") {
msg = msg + "Ship First name cannot be blank";
}
if (type == "1" & lastname == "") {
msg = msg + "\nShip Last name cannot be blank";
}
if (type == "1" & address == "") {
msg = msg + "\nShip Address cannot be blank";
}
if (type == "1" & city == "") {
msg = msg + "\nShip City cannot be blank";
}
if (type == "1" & state == "") {
msg = msg + "\nShip State cannot be blank";
}
if (type == "1" & zipcode == "") {
msg = msg + "\nShip Zipcode cannot be blank";
}
if (msg != "") {
alert(msg);
return false;
}

[GGandhi]

Re: Field validation based on checkbox

Good job.