I want to send a notification email only when a certain column

  • WiltonMill
    Asked on July 27, 2017 at 2:26 PM

    -send email only when certain column is chosen in an input table.

     

    Hello, I want to send a notification email only when a certain column in an input table has a check.

     

    The table has two columns labelled "Satisf" and "Unsat".

     

    The logic currently is

    IF (table field)

    STATE (Contains)

    TARGET (Value)

    VALUE (Unsat)

     

    The example email logics I've seen on this thread have a STATE of "is Equal to". I don't know what the functionality of the Contains state is in regards to the input table columns. As it stands right now simply putting the VALUE as the name of column of the input table, for which it sends the notification email when someone answers in that column, does not work.

     

    Thank you!

  • Mike_G JotForm Support
    Replied on July 27, 2017 at 4:11 PM

    If I'm understanding your concern correctly, you have an Input Table field in your form and you would like to send an email conditionally if that input table has a value equal to "Unsat" or if any of the rows in the input table has that value.

    If that is the case, I suggest you pass the value of the Input Table first into a textbox (Short Text Entry) field conditionally. Please see screenshot below:

    I want to send a notification email only when a certain column Image 1 Screenshot 30

    Then, create another condition and use the textbox (Short Text Entry) field to check if the table contains "Unsat" value(s).

    I want to send a notification email only when a certain column Image 2 Screenshot 41

    Please do not forget to hide the additional textbox (Short Text Entry) field in your form — How-to-Hide-Form-Fields

    I hope this helps. If you have other questions or concerns, please feel free to contact us again anytime.

  • WiltonMill
    Replied on July 28, 2017 at 10:55 AM

    Works like a charm thank you!