Hi,
I am trying to add reference links (to document files in a Dropbox folder) to a spreadsheet of transactions to be uploaded to Quickbooks Online, using Business Importer. I am trying to find a solution where the links can be generated (for automatic insertion into each spreadsheet). A copy and paste link would look like this: https://www.dropbox.com/s/uq6vvmx8cv50abc/CN006005261CA.pdf?dl=0. The sequence in italics would seem to be a folder security code that is changed each time. It is impractical to copy and paste each file link into the spreadsheets. Is there any way to provide links (based on a formula) to multiple files in a Dropbox folder without having to copy and paste each document file link?
Thanks!