Importing File Attachments from a Synced Table

  • 0
  • 2
  • Question
  • Updated 1 month 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

  • 354 Points 250 badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,268 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

  • 30,074 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?
Photo of slloydavant

slloydavant

  • 220 Points 100 badge 2x thumb
We use Zapier anytime we are trying to move file attachments from one app to another.