Discussions

Expand all | Collapse all

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

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

    Posted 08-15-2016 15:01

    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?



  • 2.  RE: How can I import file attachments using QuickBase Sync from one app to another?

    Posted 08-15-2016 17:15
    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.


  • 3.  RE: How can I import file attachments using QuickBase Sync from one app to another?

    Posted 03-30-2017 09:00
    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


  • 4.  RE: How can I import file attachments using QuickBase Sync from one app to another?

    Posted 08-16-2016 15:08
    You have saved my sanity Mark. Thanks for pointing this out!


  • 5.  RE: How can I import file attachments using QuickBase Sync from one app to another?

    Posted 08-16-2016 15:11
    ;)