0

Jet Scheduler - How not to send a report which did not run well ?

Julien

July 11, 2018 07:42

None

Follow

Hello,

I made a report using NL("Table") + some pivot tables. This report is sent automatically via email, on a daily basis, thanks to Jet Scheduler, which is great.

However, on rare occasions, all the Nav licenses are taken, so the report cannot update (#VALUES! error instead of the Table), but it is still sent via email, with old data in the pivots, which can be misleading.

Is there a way to not send the report if it did not run well ?

Thanks,
Julien

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis July 16, 2018 14:14

  Hello Julien -

  You could base the addresses of the email recipients on a condition within the report.

  Then, if that condition fails, simply do not put anything in the named range that contains the email addresses.

  More information on doing this is in the videos (especially Trigger-based Email & Dynamic Text) in the article on How to Use the Jet Professional Scheduler