Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthorequita
    • CommentTimeDec 28th 2011
     
    Hi,

    I'm on the professional plan and I'm having some trouble setting up the conditional email notification.

    I have a question in my form which uses six check boxes.

    If the user selects any of the first four boxes I want the notification to go to email address 1. Whether or not the user ticks either the fifth or sixth option will not matter.

    If the user selects either the fifth or sixth options but does NOT tick either of the first four options, then I want the notification to go to email address 2.

    I would also like the notification to go to email address 3 regardless of which options are chosen.

    I have a reasonable level of knowledge using the 'IF' function in Excel, but I just can get it working in my form.

    Any help would be very much appreciated. :-)

    Thanks
    Shane.
    • CommentAuthordbuschho
    • CommentTimeDec 29th 2011
     
    Hello Shane,

    I'm not quite sure I follow the logic you've listed above, as it's a bit convoluted with checkboxes able to have multiple options selected. Can you confirm that this is basic logic:

    if( %%tfa_checkboxoption1%% OR %%tfa_checkboxoption2%% OR %%tfa_checkboxoption3%% OR %%tfa_checkboxoption4%%)
    email: email address 1
    else if (%%tfa_checkboxoption5%% OR %%tfa_checkboxoption6%%)
    email: email address 2

    Always email address 3

    You may run into trouble with our length limits on the formula aliases if you go this route. Can you show me the formula you've come up with so far?

    Drew
    FormAssembly.com Support