OPTIONS

[collenr123]

Hello,

Below I have code to trigger an email when FollowUpdate is true, this MUST terminate if STATUS is either ACCEPTED or REJECTED!

It's not doing so, can anyone please tell me why?

My STATUS field is a radio button with 3 opetions:
OPEN-NEW, ACCEPTED, REJECTED

Thanks

SELECT @Date(@TextToTime(@Text(FollowUpDate))) = @Today & (STATUS != "ACCEPTED" | STATUS != "REJECTED"

manager := Collen;

text := "ESTIMATE NUMBER: " + @Text(NUMBER) + @NewLine
+ "ESTIMATE STATUS: " +@Text(STATUS) + @NewLine
+ "---------------------------------------------"
+ @NewLine
+ "ESTIMATE FOR: " +@Text(Customer_Name) + @NewLine
+ "ESTIMATE DATE: " +@Text(Date_Created) + @NewLine
+ "FOLLOW UP DATE WAS SET: " +@Text(FollowUpDate) + @NewLine
+ "----------------------------------------------"
+@NewLine
+ "You\'re receiving this notification as this Estimate was set to remind you to follow up and to confirm the Estimate status! "
+ "-----------------------------------------------"
+ @NewLine
+"Click DocLink below to access this estimate ¬"+ @NewLine;
@If(From="";"";@MailSend( From; manager; ""; "Follow up required on Air Export Estimate #" + @Text(NUMBER); text; "";[IncludeDoclink]) )

 

[pmonett]

First remark : what does the variable Collen contain ? My guess is that you wanted to write "Collen", which is going to be a bad idea anyway, if indeed you want a name. You are dealing with development, so shortcuts are not on the option list. That means that, if it is a name you want, you will be better off taking the full hierarchical name (i.e. lastname firstname/orgunitx/org). You can find that full name in the Server NAB, in your Person document. Or, the easier version, use @username.
Second remark : on a hunch, I feel that telling Notes to mail the From is going to get it all queasy. I would first load the From contents into a temp variable and use that variable as SendTo parameter.