Forum Discussion

Re: Exporting Attachments

Is there anyway to make it perform as a link on download? So that the user does not have to change anything in the Excel, for best user experience.

------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------

1 Reply

  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    Since it downloads as a CSV, I don't know that you're going to completely get away from the user having to do some type of formatting, but you can get around the issue of the formula in the download. You'll want to create a 2nd field for the URL, but this one will just be a plain text field. Then, you'll want to create an Automation that runs when the record is created. This automation will just need to copy the value of the URL formula field over to the new Text field. You can then use the Text field in the download and it should have no associated code in it.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------