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

  • Profile Image
    WiltonMill
    Asked on July 27, 2017 at 02: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 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!



    This is a re-post of a comment on Smart Forms Using Conditional Logic

  • Profile Image
    Mike_G
    Answered on July 27, 2017 at 04: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:

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

    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.

  • Profile Image
    WiltonMill
    Answered on July 28, 2017 at 10:55 AM

    Works like a charm thank you!