Lotus Notes formula not working

25 pts.
Tags:
Lotus Notes
Lotus Notes Formulas
Agent formula will work when document(s) are select but will not work when set to run on new or modified document. @If(PCDSSamplLogDate=@Now&PCDSFreeChlor<0.1);@MailSend("Name";"";"";"CHLORINE RESIDUAL";+@NewLine+"LOCATION: "+PCDSSamplePointName+@NewLine++@NewLine+"Free Chlorine Residual Reading: "+@Text(PCDSFreeChlor)+@NewLine+"";[ReturnReceipt]:[Sign]);"";SELECT @All
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Stiletto
    What does the agent's log say? Are you sure you want to use @Now and not something like @Today? Did you cut and paste that code (I'm guessing not), because there are a couple typos in there. Does it work if you remove the [sign] flag?
    5,545 pointsBadges:
    report
  • Dougiec

    Started running agent 'Free' on 10/22/2015 07:44:18 PM

    Running on new or modified documents: 865 total

    Found 865 document(s) that match search criteria

    865 document(s) were modified by formula

    Done running agent 'Free' on 10/22/2015 07:45:07 PM. I've tried both @Now and @Today and yes I've removed [sign] flag.

    25 pointsBadges:
    report
  • Stiletto
    So, according to the log, the agent ran.  I'm guessing that you just aren't getting the mail. Check that the TO address is correct. Is the mail sitting in the mail.box on the server?  Since you seem to have re-typed the code here, it's hard to tell, but you may have a syntax problem (the code above is missing a parameter).  Is your agent set to "run as" a particular ID?
    5,545 pointsBadges:
    report
  • Dougiec
    Oh yes I got the mail when I ran the agent manually all 865 of them. But there should have only be 1 that met those perimeters.
    25 pointsBadges:
    report
  • Stiletto
    Okay, so just as a basic troubleshooting step, change the @MailSend to include @Text(PCDSSamplLogDate) some place - like the subject line. Then, you can at least see what the system thinks the value is.
    5,545 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: