Forum Discussion
5 Replies
- The settings are limited to Daily, Weekly and Monthly
- 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. - 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?
- 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?
- You could try submitting a User Voice topic and seeing if other people want the feature as well. There is already a post from 2014 that got zero traction for the idea but I don't see a newer one. https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/6872582-enhanced-report-subscription-scheduling
I actually found another one that had a ton of votes but also was never implemented. This one is from 2012, they are requesting the ability to change the time subscriptions are sent out. https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/3345995-schedule-subscription-and-reminders-on-a-specific
I gave both of those links to illustrate the point that if you need this now, don't wait for it to be implemented. It could never happen or it might happen in 6 months, nobody knows. If it is really important to you you can follow the guide above by Mark and have the feature now. I don't see any reason why it would not still work since his solution is native.
