How to send a mass email to non Quickbase users

  • 1
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I need help setting up a way how to send a pdf from Quickbase to non QuickBase users. And this is for a group of users.

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,630 Points 50k badge 2x thumb
Does the PDF need to be generated from a QuickBase record?  ie are you needing to send a PDF version of a record?
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
The PDF is an attachment in the QuickBase and I want to send the PDF to  non QuickBase users to view. Can you send a pdf version of a record?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,630 Points 50k badge 2x thumb
QuickBase cannot send out an actual attachment.  With a recent enhancement however, you can mark a file attachment field

"Allow open access Allow access to this file attachment from a QuickBase link without signing in", so that would let you send an email Notification to users which has a link to open the file.

If you want to actually generate a PDF and have it sent as an attachment, then there are third party QSPs who have add on tools for that.  Juiced Technologies, for one does that well.
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
But can QuickBase allow you to send the attachments to several non QuickBase users at a time (mass distribution list)

I would like for people to go to a record and add the attachment then use 1 field to list the non Quickbase email addresses, and then use the notification feature to send the attachment to all the listed users
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,630 Points 50k badge 2x thumb
You would need to use Juiced to do that.  The alternative, would be to construct a mailto URL button which would invoke the user's email client (for example Outlook or gmail - whatever they use ...), populate the TO, CC, BCC Subject and Body of the email automatically, and then the user would attach the pdf manually.
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Can you help me with the code to the URL button
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,630 Points 50k badge 2x thumb
The general syntax is like this
"mailto:" & [To:]
& "?cc=" & [CC]
& "&bcc=" & [BCC]
& "&subject=" & URLEncode([Subject])
& "&body=" & (URLEncode([Body])
&"%0A%0A"
&"more body goes here"



The email addresses should be semi colon delimited and you need to URLEnde anything that might have special characters.

To get a carriage return carriage return to create a space between lines you do this.

&"%0A%0A"
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
"Allow open access Allow access to this file attachment from a QuickBase link without signing in", where in the settings can I find allow open access
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,630 Points 50k badge 2x thumb
This is a field property on the file attachment field
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
thanks
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
How do I create a space between fields (trying to create the body of the email)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,630 Points 50k badge 2x thumb
To make a horozonal space between fields you just build up the formual like

... "&Subject=" & URLEncode(
[my field 1] & " " & [My field 2])