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

Question

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?

QuickBaseCoachD · Answer

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.

Sign up

Login to the community