Home / QIN / Knowledge Base / What time of day are report subscriptions emailed?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

What time of day are report subscriptions emailed?

A specific report subscription is always emailed at the same time of day (or time of week). However, this time is chosen at random when the view subscription is created.

Currently, the time is randomly chosen in the range from 08:00 to 15:00 UTC time. Depending on daylight savings, this translates into:
Eastern Time: 3AM to 11AM
Pacific Time: 12AM to 8AM

If you are unhappy with the specific time the e-mails are sent, you can delete the report subscription and recreate it. This will choose a new random time which may be more (or less) to your liking.

[Note that the specific time ranges may change in the future.]

Caution: If the subscribed report has a filter criterion that selects records related to the date Today(), the report would not show records related to 'yesterday' as might have been expected since the report would have been run only in the morning hours of Today(). The workaround is to use Today() - Days(1) instead of Today() in the filter formula if the intent is to select records related to the day 'previously ended'.

Tags:

Comments

Reporting on a time field

Submitted by Suresh Iyer (not verified) on Thu, 03/22/2012 - 06:17.

Hi 

I am creating a report, and I want to track all those records which were last modified after 3:00 PM yesterday. Is this possible to do ?

Regards

Suresh

date/time fields filter only on date portion

Submitted by sshearin on Fri, 03/23/2012 - 09:46.

Hi Suresh --

Thanks for writing! I did some testing of my own, and it looks like the options to filter on a Date/Time type field like Last Modified are limited to dates only -- there are no options to filter on the time part of the field. I've also brought this to the attention of the development team, so perhaps that won't always be the case.

I suspect you could get around this limitation by creating a formula field to extract the time portion of the Last Modified field, then filtering by that field.

Regards,

--Sybil

 

Using Time of Day as Delivery

Submitted by Scott (not verified) on Sun, 10/04/2009 - 10:16.
I have a task list with a target date to complete task. I have no problems setting up email subscriptions based on the target date to complete. But what I want to do is as follows: 1. It's 9:00AM on October 5, and I want to add a task due at 4:00PM that day (or for that matter, be reminded at 3:00PM in a couple of days). 2. I want to set up an email reminder, and a criteria is to email me at the time I have inputted in that field. Issue: Whether I am setting up an email reminder, report, subscription, etc., that field for time gives you a blank field to input criteria. I would think there would be a similar drop down as you get with dates (e.g., current date). What do I put in this blank field so that if I want an email reminder at 3:00PM (or anytime) that I get it at that time? Thanks, Scott

Using Time of Day as Delivery

Submitted by QB_Support_Karis (not verified) on Mon, 10/05/2009 - 09:51.
Hi Scott, Sorry to report, but there is not currently a way to send a reminder email at a specific time of day. Reminder emails are sent during the hours of lowest activity in QuickBase, after 5pm Pacific time and before 7am Eastern time during the night. Sorry for this limitation of the current product! Thanks, Karis QuickBase Support

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Rate This

0
No votes yet
Your rating: None

© 1997-2012 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit