Skip to main content
Question

Can I set up a subscription for a report on a quarterly or semi-annual basis?

  • February 18, 2013
  • 0 replies
  • 50 views

Can I set up a subscription for a report on a quarterly or semi-annual basis?
This topic has been closed for replies.

  • Registered
  • February 18, 2013
The settings are limited to Daily, Weekly and Monthly

Forum|alt.badge.img+6
  • Registered
  • February 18, 2013
What I do is to set an extra checkbox filter on the report such as
if(rem(month(today()),3)=1,True,false)

or just
rem(month(today()),3)=1

So for example, if its April 1st today (Month #4) and you divide 4 by 3 you get a remainder of 1. So it would be True, so the report would have data on it. Then in May, it would be month #5 and 5/3 leaves a remainder of 2 so it won't fire that month because the report will be blank.

It does mean that you need to make a second "copy" of your report just for the purpose of the Subscription.

...P.S. .. for semi annually the formula would have 6 in place of 3.

  • Registered
  • December 5, 2014
Surely this is something that QuickBase is looking at doing.  I think the ease of implementing another radio button for 'quarterly' subscriptions wouldn't be too difficult.  A lot of businesses' report to shareholders and such based on quarterly reports.  So this would be more of a necessity than a want.  Is this something that can be implemented rather quickly?

  • Registered
  • August 15, 2019
I really need a quarterly option. All of our reporting is on a quarter basis. Do we know what it would take for them to add this feature?