Skip to main content
Question

Button to send subscription

  • July 5, 2018
  • 0 replies
  • 187 views
Since Quick Base natively doesn't  allow to send subscriptions at a specified time period, I tried create a URL button that sends out notification only when it is clicked on. The code for the button is URLRoot() & "db/bnhq7nc5j" & "?a=SendSubscription&ID=XX"

However, I noticed that this works only when the subscription is activated. Well, if I keep the subscription active it will automatically trigger at a particular timeframe and I do not want that to happen. 

Are there any alternative solutions to this? I want to trigger a notification (which is basically a report) to multiple users at a particular time only. I do not mind doing this using the native functionality available or some coding logic. And also i do not want to plug this button at a record level, I want to create this button on the homepage

Feel free to propose any suggestions. Thanks ,
    This topic has been closed for replies.

    Put a filter on the report where today is not Sunday. 

    dayofweek(today())<>6

    Then set up the subscription to be active and run every Sunday. it will be blank and hence will not be sent.
    • AngelAngel
    • Author
    • Quickbase Alumni
    • July 5, 2018
    didnt think it would be so simple. Thanks.

    To that point, do you know if there is a way we could have multiple recipients in the To and have CC as well instead of sending out individual emails?
    Each recipient will receive the subscription report email as a TO. There is not a way to indicate who else received the email.
    • QuickBase9
    • Quickbase Alumni
    • August 1, 2018
    Guys, this all works so perfectly! Thank you both!
    Terms & ConditionsAccessibility statement