Conditional Validation, Dropdown List Value Equal To 1

I want to set up a conditional validation where when the value of a drop-down list (Number of Appointments Set: ) is 1 then I want a text field (Company: ) to be required.

user_times_Insert.php

Not sure how to go about doing this with Validation Toolkit. Anyone have any ideas?

Thanks

this will take a little hand coding in the Server validation interface, but it can be done.

Select required/ not blank for the validation type.

for the server variable, click the lightning bolt icon and select the number of appointments form element.

the code for the server variable will look like this:

((isset($_POST["APPTS"]))?$_POST["APPTS"]:"")

change it to:

(((isset($_POST["APPTS"]) && $_POST["APPTS"] == "1"))?$_POST["apptCompany"]:"NA")

this will validate the apptCompany form element if 1 is selected in the APPTS form element, otherwise it will pass "NA" to the validation to pass the required validation.

Not completely following here. I should add this and then a validation to check if the "company" field is black or not?

no, when you add the required validation for the select list, make the change to the server variable as i suggested, this will check the select list value, and if it is 1, it will validate that the company element is not blank.

Looks like you may have misunderstood what I was asking for. The drop down list (APPTS) has values of 0 and 1, when that is selected I would like to requite the text field (apptCompany) to be a required field. I think what you did was you changed the dynamically populated field to equal NA which is not at all what I am trying to do. Everything, as the page is set now works exactly as I want except what I described above which I have added nothing for yet.

so you want validation to occur if either 0 or 1 are selected?

then change the code to:

(((isset($_POST["APPTS"]) && ($_POST["APPTS"] == "1" || $_POST["APPTS"] == "0")))?$_POST["apptCompany"]:"NA")

the NA value is just there to force it to pass validation of the apptCompany field does not need to be validated.

Sorry for the delay in responding I had to table this for a bit but am back at it now.
This is not working as expected.

I have made the changes as you suggested, but for some reason this change causes the APPTS form field to submit to the database as blank and does not require the user to fill out the apptComapny field which is what I am going for.

Also, currently the field "Number of Appointments Set" is being used to populate "Appointment Type" using the Dynamic Dropdown Extension (which is working) so I'm not sure if that is some how interfering.

I want for the user to be required to enter a value in the Company field (apptCompany) if the user selects a 1 from the Number of Appointments Set (APPTS) which already set as a Select required/ not blank for the validation type.

Thanks

please send a copy of the page.

It's attached.

i dont see any server validations on this page.

it looks like you took the code i gave and added to the Insert Record behavior, this is not what i had suggested.

i had suggested that you add server validations to the page, and using the required validation type, use the code i provided for the server variable