Forum Discussion

RachelJones's avatar
RachelJones
Qrew Cadet
9 years ago

How can I import file attachments using QuickBase Sync from one app to another?

I have a large complex internal app for employees, and I'm trying to create a smaller client-facing app for a particular client. I used QuickBase sync to import only the client's records and relevant fields from the internal app to the client-facing app. Some of the fields are file attachments.

I was able to create a URL formula field that links directly to the file attachment in the internal app, but I am only able to download it if I am logged into QuickBase as an internal user. If I am logged in as a client, I receive an access denied error.

I don't want to open permissions in my internal app selectively to clients. Managing field-specific permissions is too tedious and we add new fields all the time to our internal app so that's not an option. How can I actually sync file attachments from the internal app to the client-facing app?

Data import and export
Formulas and functions
Quickbase Sync
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    The file link that you built in the client app probably looks like this



    URLRoot() & "up/" & "xxxxxx" & "/a/r" & [Record ID#] & "/e103/v0"


    Where 103 is the field ID# of the file attachment field.

    On that file attachment field in the main app, look for the setting box 

    "Allow access to this file attachment from a QuickBase link without signing in"


    That is a recent enhancement from QuickBase to deal with your situation.  That checkbox should allow the access you need.
    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      8 years ago
      Great :) This will work for me. As far as I know we can't sync any attachment fields but through your solution we can access it.

      Thank you mark :)

      Gaurav