Hi, I currently have reports on both Jet Scheduler and Jet Hub. Trying to centralise them all in the Hub. I have a few tricky ones which I can't recreate in the Hub. Below is a brief.
I have a report that runs to return a list of customer created in the last 7 days. I then have a named range called "EmailTo" which gets populated using an IF statement if the total count of customer records is greater than 0. I then setup a jet Scheduler job to run the report on a weekly basis and email to the named range "EmailTo" If the Emailto is populated, then it will send an email, otherwise doesn't send anything out.
In the Hub, there is no way of calling the Named range "EmailTo" in the Email distribution option. Any ideas of how this can be achieved in the Hub?
Date
Votes
2 comments
-
CascadiaDataworks Unfortunately, the Hub scheduler is fairly basic and does not support using a named range nor conditions to send emails.
You can either always send it and the recipient can ignore the blank report, or you can always have it email it to yourself and then forward the report as needed.
-
Ajit Vaghjiani Hi BobRoss, Thanks for the feedback. It's a shame that Jet Hub is a downgrade from Jet scheduler in terms of features. I will keep on using Jet Scheduler for the smart features.
Please sign in to leave a comment.