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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

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?

Photo of Rachel

Rachel

  • 192 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
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.
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
Photo of Rachel

Rachel

  • 192 Points 100 badge 2x thumb
You have saved my sanity Mark. Thanks for pointing this out!
;)