Mail send only after condition met

Hello Designers…

I have approval form, It has 5 fields & 1 button :

Author

Approver1 : Yes/No Selection

Approver2 : Yes/No Selection

Approver3 : Yes/No Selection

Approver4 : Yes/No Selection

1 button (only Approver1 has access to press button)

@If(Approver2 & Approver3 & Approver4 != NULL;

@Do(@MailSend(Author);“”; “”; “Procedure - Approved”; “This Procedure has been Approved by Approver 1,2,3,4 .”; “”; [IncludeDoclink]);

When Author submits the Approval Form, the mail will be sent to all approver 1,2,3,4.

Approver 1,2,3,4 can select yes / no option.

Approver1, if he press button. it has to check whether remaining approver has selected any option or not. If remaining approver selected the yes/no option, then mail has to send to author or if any one of the approver missed to select yes/no option then mail should not be sent to author.

I have wrote above, its not works. Please help me in correcting the formula

Thanks

Vj

Subject: Mail send only after condition met…

@If(Approver2 = “Yes” & Approver3 = “Yes” & Approver4 = “Yes”;@mailSend (…);

@return(“”))

Should do the e-mail if all have approved and do nothing if they aren’t all “Yes” also, remember text strings are always case sensitive.

  • if the choices are Yes/No - the <> Null would send e-mail whether they “Yesed” or “Noed” - and I have never been able to convince notes in formula language to do the multiple field = “Yes” thing.

Now, if you want to so something about e-mailing the NULL people to get to work, you can work that in to the @If as well.

Subject: RE: Mail send only after condition met…

Thanks Thomas H. Snelham,