Discussions

Expand all | Collapse all

Is there a way to send a 'subscription' in Excel or CSV format?

  • 1.  Is there a way to send a 'subscription' in Excel or CSV format?

     
    Posted 07-02-2014 14:44


  • 2.  RE: Is there a way to send a 'subscription' in Excel or CSV format?

    Posted 07-02-2014 14:59
    Sort of.

    QuickBase cannot send any attachments in a subscription, so "no".

    But you can set up a report and choose the format at the bottom of the report configuration to be Comma Separated Values. What will happen is that the user will receive the email and it will have that "Click here" button to see the report in QuickBase and it will open up as a CSV, typically in Excel as most users have Excel the default program for opening CSV files.


  • 3.  RE: Is there a way to send a 'subscription' in Excel or CSV format?

     
    Posted 07-02-2014 15:19
    Thanks! I'm testing now. The customer is looking to import the CSV file into their data base (not  QB).


  • 4.  RE: Is there a way to send a 'subscription' in Excel or CSV format?

    Posted 01-14-2016 23:59
    Thanks Mark.

    What you describe is the closest I've been able to find too.

    I would like the Subscription Notification to send the .CSV file, but it sends the nice formatted version in the e-mail.

    The Click-Here link engages the open or save dialog box.

    Excel tampers with the data (changes a long account number into exponent notation, even in a .CSV that is not supposed to have any formatting.   So saving it directly is best.

    Thanks for the confirmation.

    - David in Tucson


  • 5.  RE: Is there a way to send a 'subscription' in Excel or CSV format?

    Posted 04-11-2017 18:36
    In Zapier you can go from Gmail to Drive. The notification contains the html payload as an attachement you put in the Drive step File, Step1: attachment... In Drive you have an .html file (use that as an extension) you can download and open in a browser. Or open in Excel. (also use the setting Convert to document: no). In the Gmail step use New Attachment. Also you might want to limit it to a label so you can just get the attachments you're interested in. I used this template to get started... https://zapier.com/app/editor/template/9245


  • 6.  RE: Is there a way to send a 'subscription' in Excel or CSV format?

    Posted 04-12-2017 13:50
    3rd party add-on XL Docs for QuickBase allows you to click a single button in QuickBase to generate a csv or excel file that can be stored in a file attachment field, Google Drive and/or Dropbox.
    demo here...from dashboard report on bottom left...click buton to generate csv file
    https://juicedtech.quickbase.com/db/bj446yrpq