-
WiltonMillAsked 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!
Page URL: https://form.jotform.com/72064751597161 -
Mike_G JotForm SupportReplied 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:
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.
-
WiltonMillReplied on July 28, 2017 at 10:55 AM
Works like a charm thank you!