Issue with 'copy field' (checkbox) condition to send emails based on multiple response options.

  • systemisedbydesign
    Asked on February 18, 2019 at 1:19 AM

    Hi guys,

    (form URL: https://form.jotform.co/WarpGroupWA/DRI_Only_Check?whatstate=wa) This will populate a hidden field with 'WA"which will be one of 2 conditions to trigger the emails.

    I have been working on a number of forms for a multi site business where the forms need to be handled differently by the submission location. 

    I have setup a number of conditions on one of their forms for sending emails depending on responses. 

    Since the form has a number of questions where a particular response would trigger an email set, I have used the 'copy field' condition to trigger certain emails by location, rather than building the same number of quite long condition strings to achieve the same result. I have a number of forms for them that require this treatment so want to get it right on this one first. Here are the conditions I've set: 

    Rule 1:

    IF

    - the response to any row in input table 1 is 'no'

    - the response to any row in input table 2 is 'no'

    - the response to 4 other questions is not the ideal response

    THEN

    - copy fields value from item 3 (pre-populated & hidden check box) to item 4 (vacant hidden checkbox)


    Rule 2:

    IF

    - checkbox 4 is empty

    THEN

    - send email (a)


    Rule 3:

    IF

    - checkbox 4 is filled

    THEN

    - send email (b)


    I have heard from the client this morning that since this was implements on Friday, that emails (b) are still being sent even though none of the other conditions from rule 1 haven't been met. 

    I have looked and am confused as to where this is coming from... I have also made a minor change to one of the other rules which shouldn't effect this one and have sent test submission but I'm unable to access email logs for my form so I cant see what was sent... 

    One submission he gave me as an example is submission ID: 4262634323434922940

    The submissions how that 'checkbox 4' has been filled for all recent submissions, however it shouldn't have been based on the conditions.


    Can someone assist me with this please? 


    Jotform Thread 1735753 Screenshot
  • Ashwin JotForm Support
    Replied on February 18, 2019 at 2:46 AM

    I did check the condition you have added in form. It seems you have added condition and if "ANY" of the condition is matched then copy field's value to another field. Please check the screenshot below:

    1550475733insertCondition Screenshot 10

    Do you want to copy the field value when any of the condition is matched or all the conditions are matched? If you want to copy field's value only when all the conditions are  matched then you need to edit condition and set if "ALL" of the if conditions are met (as  displayed in the screenshot above).


  • systemisedbydesign
    Replied on February 18, 2019 at 4:43 AM
    Thanks for your response.
    This should be ‘ANY’ not all. The questions are for separate parts of a vehicle inspection and any of them could trigger the need for action or attention on the vehicle, hence that email needs to be sent.
    I have checked a lot of the recent responses from today and NONE of them should have triggered the ‘copy field’ condition.
    Cheers,
    Adam Gardiner
    0466 890 282
    Autocorrected by my iPhone
    ...
  • roneet
    Replied on February 18, 2019 at 7:40 AM

    On checking your conditions, I noticed since you have written a condition that if "Fire Extinguisher" is not equal to "Yes Extinguisher, Yes tag" so due to this whenever the Form is loaded it thinks the condition is true and due to this it is always copying "Compliant" to "Non Compliant" field, this is the reason emails are always triggering.

    Please replace the above condition to

    if "Fire Extinguisher" is equal to "No Extinguisher" and also equal to "Yes Extinguisher, No tag"

    Let us know how it goes.

    Thanks.

  • systemisedbydesign
    Replied on February 18, 2019 at 8:43 AM
    Ahh, ok great! I’ll get on that and then test. Thanks very much!
    Is there any guidance anywhere about which conditions render at which point in the process? This particular one (is not equal to...) seems to take the initial state at the opening of the form as the trigger point then ignores the same condition when that question is filled in and ‘submit’ is pressed- this seems strange.
    Is there any other nuances with these conditions like this that users should know?
    Cheers,
    Adam Gardiner
    0466 890 282
    Autocorrected by my iPhone
    ...
  • roneet
    Replied on February 18, 2019 at 10:03 AM

    Other conditions seems to be in place. Please make the change related to that condition and let us know how it goes.

    Thanks.

  • systemisedbydesign
    Replied on February 18, 2019 at 5:43 PM
    This seems to have done the trick - The 'non-compliant' field is now empty,
    I just need to check with the client to see if the emails were sent
    correctly.
    Thanks for your help on this.
    Should the conditions be validated upon submission rather then on opening?
    It seems some will be validated upon opening (like the issue above) and
    others will be validated upon submit, or maybe some other trigger
    throughout the filling in process..
    Cheers anyway! All sorted now!
    Kind Regards,
    *Adam Gardiner*
    0466 890 282
    ...
  • jonathan
    Replied on February 18, 2019 at 6:38 PM

    Should the conditions be validated upon submission rather then on opening?

    Post submission related conditions will indeed triggers only upon submission. i.e. email conditions.

    Conditions within the form like show/hide, calculations, and validations mostly will trigger already while form was not yet submitted.

    Thank you for the confirmation that all is good now.