Hi, folks. I hope this finds you well.
I have a J.O. Program that sends out a survey e-mail but it’s failing to fetch some participants due to the sender e-mail field being null. I have another e-mail field that could be used in case the one that is being currently used is null, but I don’t know whether it’s possible to create some kind of condition as a if/else clause.
That way, if the data from the sender e-mail field is null, use the other field.
Thanks in advance!
Hi
While you cannot configure an IF/THEN type scenario on the mapping screen you’ve pictured, you could fashion an IF/THEN scenario if you’re pulling your Participants by query.
I’m thinking somewhat high-level here, but in theory you could build your query and include a CASE statement therein, so that IF you have an email address in a certain field, THEN use it, and IF you don’t THEN fall back to some other field.
With that IF/THEN logic built into your query, you then would have a final dataset that always included a sending email address in a designated field. You can map that sending email address into your Digital Journey Program, and have less risk of skipping Participants.
Thank you for that insight
I will try and follow those steps on a brand new J.O. Program to see how it behaves and then apply it to the actual one.
I appreciate your help once again.
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.