Forum Discussion

AngelAngel's avatar
AngelAngel
Qrew Assistant Captain
7 years ago

Button to send subscription

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 ,
App builders
Ask about Quickbase functionality
NotificationsEmail
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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's avatar
      AngelAngel
      Qrew Assistant Captain
      7 years ago
      the other issue I am facing with this is - firstly only the owner of the subscription can send those out. In addition only admins can be owners. Any suggestions?
  • AngelAngel's avatar
    AngelAngel
    Qrew Assistant Captain
    7 years ago
    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?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Each recipient will receive the subscription report email as a TO. There is not a way to indicate who else received the email.
    • QuickBase9's avatar
      QuickBase9
      Qrew Cadet
      7 years ago
      Do you happen to know know the best way to add in authentication to this call? When an Admin presses the button, it goes off, but when a user with limited permissions hits it it says " you can only send your own subscription" and does not fire. I've added in the app token, but I'm thinking it needs an additional API authentication - any suggestions? Thanks!
    • QuickBase9's avatar
      QuickBase9
      Qrew Cadet
      7 years ago
      Sadly, no. Does this call (SendSubscription) work in Webhooks? I have a timestamp action I can use to trigger the webhook if so....