Hello All,
I have a couple questions.
Item #1
Currently I have s custom code that is below that is in my "On submit" section of the form located at http://mwforms.miworksmo.org/dvop-app:
What I would like to do is have a column in my table that is labeled "Eligibility" that takes the "$qualified" variable and puts it into the code. I am unsure how to tackle this.
Item #2:
Currently there is a text box labeled "ApplicantOSMISID" and I would like to auto populate that based on the following information: take the first 3 letters of {ApplicantLastName}, the first 2 letters of {ApplicantFirstName} and the MMDD of {ApplicantDateOfBirth} and combine them... so if name and birthdate were as follows: John Thomas 12/13/1974 then it would calculate {OSMISID} with JohTh1213
Item #3
I have successfully connected chronoconnectivity to that form, and am able to open and edit all fields that are in the form... How do I open the form so that ALL Data is available, but only certain fields are editable?
Thanks in advance,
Arrick.
I have a couple questions.
Item #1
Currently I have s custom code that is below that is in my "On submit" section of the form located at http://mwforms.miworksmo.org/dvop-app:
<?php
$qualified = 'Ineligible';
/*Question 2a*/
/*Step 1: 2a must be "Yes". If so, proceed to step 2*/
if ( $form->data['DVOP2a'] == 'Yes' ) {
/*Step 2: 2c MUST also be "Yes". If so, proceed to step 3*/
if ( $form->data['DVOP2c'] == 'Yes' ) {
/*Step 3: At least one of 2d, 2e, or 2f must also be "Yes". If so, proceed to step 4*/
if ( $form->data['DVOP2d'] == 'Yes' || $form->data['DVOP2e'] == 'Yes' || $form->data['DVOP2f'] == 'Yes' ) {
/*Step 4: At least one of 4a, 4b, 4c, 4d, 4e, 4f, 4g or 4h must be "Yes". If so, the applicant is to be referred to a DVOP Specialist*/
if ( $form->data['DVOP4a'] == 'Yes' || $form->data['DVOP4b'] == 'Yes' || $form->data['DVOP4c'] == 'Yes' || $form->data['DVOP4d'] == 'Yes' || $form->data['DVOP4e'] == 'Yes' || $form->data['DVOP4f'] == 'Yes' || $form->data['DVOP4g'] == 'Yes' || $form->data['DVOP4h'] == 'Yes' ) {
/*IF eligibility is MET*/
$qualified = 'Eligible';
}
}
}
}
/*Question 2b*/
/*Step 1: 2b must be "Yes". If so, proceed to step 2*/
elseif ( $form->data['DVOP2b'] == 'Yes' ) {
/*Step 2: Either 2d or 2e must also be "Yes". If so, proceed to step 3 */
if ( $form->data['DVOP2d'] == 'Yes' || $form->data['DVOP2e'] == 'Yes' ) {
/*Step 3: Either 4h, 4i, 4j or 4k must be "Yes". If so, the applicant is to be referred to a DVOP Specialist.*/
if ( $form->data['DVOP4h'] == 'Yes' || $form->data['DVOP4i'] == 'Yes' || $form->data['DVOP4i'] == 'Yes' || $form->data['DVOP4j'] == 'Yes' || $form->data['DVOP4k'] == 'Yes' ) {
/*IF eligibility is MET*/
$qualified = 'Eligible';
}
}
}
/*Question 3a or 3b*/
/*If either question 3a or 3b is "Yes", the appicant is to be referred to a DVOP Specialist.*/
elseif ( $form->data['DVOP3a'] == 'Yes' || $form->data['DVOP3a'] == 'Yes' ) {
/*IF eligibility is MET*/
$qualified = 'Eligible';
}
$form->data['eligibility'] = $qualified;
?>
What I would like to do is have a column in my table that is labeled "Eligibility" that takes the "$qualified" variable and puts it into the code. I am unsure how to tackle this.
Item #2:
Currently there is a text box labeled "ApplicantOSMISID" and I would like to auto populate that based on the following information: take the first 3 letters of {ApplicantLastName}, the first 2 letters of {ApplicantFirstName} and the MMDD of {ApplicantDateOfBirth} and combine them... so if name and birthdate were as follows: John Thomas 12/13/1974 then it would calculate {OSMISID} with JohTh1213
Item #3
I have successfully connected chronoconnectivity to that form, and am able to open and edit all fields that are in the form... How do I open the form so that ALL Data is available, but only certain fields are editable?
Thanks in advance,
Arrick.