Forum Discussion

RachelDifiore's avatar
RachelDifiore
Qrew Member
2 months ago

Sending subscription reports to large numbers

My question is twofold:

I have a daily subscription set to send out to a large number of people. It is not every user of the app, so it's a list that's been parsed from the entire user list. Not everyone has been receiving it. Is there a limit to the number of names (or email addresses) that can be added to the delivery list?

Secondly, I have an additional list that needs to be added to the recipients that are all QB users, but not necessarily users of this particular app. Is that prohibiting them from receiving this report as well? There is no other reason to add them to his app, but they have an operational interest in the information coming from the report.

Additionally I don't seem to have any access to Pipelines to go that route.

Thanks for any help!

  • Subscription will only be received by Users who have permission to  to view the Records.  So no access to the app = no email received.  So that explains the second question.

    This is some help text on Quickbase Subscription limits.  Do any of these explain your issue?

    https://helpv2.quickbase.com/hc/en-us/articles/4570306993940-Limits-in-Quickbase

     

    Legacy emails, including notifications, subscriptions, and reminders

    You can't email charts, map reports, or grid edit reports.

    You can't subscribe to chart reports.

    The total number of subscription and reminder emails that you send daily equals three times the number of users on your QuickBase service plan.

    Maximum number of email addresses Microsoft Internet Explorer can have in a mailto link is 100.

    An HTML email notification can have a maximum of 400,000 characters before it is truncated (the length of the entire HTML message, not just the number of characters in the body of the message).

    Email subscriptions are limited to 4,000 recipients.

    Emails can only be sent to verified users. 

    Emails can't contain HTML in the body.

    Emails have a body size limit of 1 MB.

  • Thanks for the quick response. As far as the large list, I think I'll have to set up multiple subscriptions to manage getting it out every day. Not sure how it was picking and choosing from the roster it was given initially.

    The remainder of the recipients I'll have to figure out another solution for. I will be working on a similar sort of subscription for some other reports so I'll work towards that.

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      Some possible strategies for sending out reports on a daily basis to non-users.  If you were willing to open up your app Staples to everyone on the Internet, then one strategy is to have a table of email address recipients for non-users in on that form you would have embedded reports and maybe links to embedded reports that you were trying to distribute. Then he would have a pipeline run to tickle these records every day thus triggering individual Open notifications to those email address recipients. Legacy style notification can go to any recipient even if they are not a user and the new custom email notifications also have an option to go to non-users.  Strangely, but conveniently, there does not seem to be a limit to how many individual email notifications you can send in a day.