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?