Importing File Attachments from a Synced Table

  • 0
  • 2
  • Question
  • Updated 12 months ago
  • Answered

We are trying to import File Attachment fields using QuickBase Sync (from one QB application to another). Anyone found a way to make this work? The only work around that I can think of is to capture the file link in the original table and use that in the Synced table for the user to download the file. Would prefer to import the actual file though.

Thanks!

Photo of Leanne

Leanne

  • 262 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,696 Points 50k badge 2x thumb
The only way I know is to have a link to the file like this

URLRoot() & "up/" & [_DBID_PROJECTS] & "/a/r" & [Related project] & "/e30/v0"

where fid 30 in the source table has the file attachment.
it could be made fancier by showing this as an href link with the name of the file to click on.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,604 Points 20k badge 2x thumb
This can probably be done in script using Blobs and FormData. I may look at it but I don't have a lot of extra time right now.
Photo of Meredith Moore

Meredith Moore

  • 556 Points 500 badge 2x thumb
Are there any updates on this?