Discussions

Expand all | Collapse all

Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

  • 1.  Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

     
    Posted 03-29-2017 02:30
    We are interested in sending invoices to our customers from Quickbase.  Our thought is to attach an already created invoice to an individual QB record.   We would use a Quickbase notification to send an email to the customer and attach the invoice to the Email?  Is that possible for Quickbase to do?  If so, how?  If not, any other suggestions welcome.  Thanks


  • 2.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 03-29-2017 04:02
    You can do all of this, with one caveat.  QuickBase does not allow you to send the actual file attachment.
    But, you can send a link in the email that once clicked it will automatically download said attachment.

    Do you already have the table set up?  
    Do you already have a way to create the invoice file? or are you using an outside system, then just attaching?

    I can help walk you through this, but I need to know where you are so far so I don't duplicate details. 


  • 3.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 03-29-2017 10:49
    Or... you can do it all with Add Ons.

    Juiced Technologies offers the ExactFormsPlus! tool which you can create Invoices with and store them either in QuickBase or in Amazon S3 and they also have the QBCourier tool which is great for sending out professional emails (fully customized) with attachments from files stored in QuickBase or from Amazon S3.

    If you go the route of creating Invoices within QuickBase from data stored there, they also have a Batch Processing tool to generate them all at once.

    Highly recommend talking to them about your situation to see what's right for you.

    Neil's option is valid - but you can't send a physical file attachment from QuickBase and the email notification is limited in its formatting, depending on what you want your email to do.


  • 4.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

     
    Posted 03-30-2017 01:31

    Hi Matthew, thanks for the response.  Your idea sounds interesting.  Yes, we already have a whole quickbase aging set up for our specific customers.  Each record has a unique bill# transaction on it.  A few of our team members are responsible for creating and attaching the unique invoice pdf to each record.  We�d create a quickbase report that filters only the customers we�d send to daily, one criteria being maybe �days past due�, and create a checkbox for email sent, etc...

    Our idea, if a unique link could be created for each invoice...would be to set up a daily automated job to run and email out these invoices to customers.  The invoice link would be part of a collections reminder notification, per se.  We would likely set up automation using the Quickbase Desktop application which we use regularly.  Would that be possible? 

    One other question about the link for the invoice � would clicking on that �invoice link� require the recipient to register with Quickbase, or would they be able to view the invoice straight from the email?

    Thanks much for your time, and help



  • 5.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

     
    Posted 03-30-2017 01:37

    Hi QuickBasePros...thank you for your response and idea. We don�t really want to have this go through a third party. We actually have a third party we probably could use for this, but we wanted to try and manage this effort ourselves if possible. �If� we can�t find a solution ourselves, we�ll likely go with them. But greatly appreciate the feedback about the ExactFormsPlus option! :o)



  • 6.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 03-30-2017 02:40
    Lee,,

    There is another option for you to consider which has not been raised so far on this discussion three.

     There's a checkbox to click on he field properties your file attachment field. If you check the box it will enable that file attachment to be downloaded without the user logging in  to  QuickBase  

    Then there is a way to format an attractive link which you can include in your automated email which says  "Click here to download your invoice".


  • 7.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 04-13-2017 21:50
    Can you elaborate on this?


  • 8.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 04-13-2017 22:13
    What is your question?


  • 9.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 04-13-2017 22:27
    How do I enable a download of say a pdf file via your suggestion above as opposed to a link to a file on quickbase where it's viewed in a browser and the recipient can see a quickbase url? And thank you for responding. 


  • 10.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 04-13-2017 22:37
    On the file attachment field there is a checkbox called 

    Allow open access    Allow access to this file attachment from a QuickBase link without signing in

    You can make a URL formula field like this

    URLRoot() & "up/" & dbid() & "/a/r" & [RecordID#] & "/e30/v0"

    where 30 is replaced by the field ID# that holds the attachment.

    Give the field a link name like "Click here to access your invoice"

    Then you can make an email Notification of Type Open and include that field in the body of the email.  Then whoever receives the Notification can click the link to get the file.


  • 11.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 03-30-2017 05:20
    Looks like the direction you are going is going to be staying native, and sending the file attachment as a link.  (and yes as Mark stated, you can make the attachment available without a login)

    If so, let me know and I can provide some screen shots to help direct the process.

    ***One Warning:  If you make that file attachment field available without signing in.  People could easily manipulate the url and access other invoices.  ****  If there is confidential information going out in those files, you will want to consider the use of an add-on from a 3rd party.


  • 12.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 03-15-2019 17:08
    Are we suppose to see the button on the notification or only the link? I was under the impression that I will be seeying the button on the notification but can only see the link.



  • 13.  RE: Creating Invoices as Attachments to Emails from Quickbase - Is it Possible?

    Posted 03-15-2019 20:57
    It will appear as a link with the words of the label as the link text.  If you want to have a button appearance then the code is much more complicated.