Skip to main content
Question

file attachments in synced tables

I've created a public-facing app where people can upload attachments.
In a private app I've created a Quick Base Sync connection to the relevant table.
Is there a way to get the file attachments to come over? Right now it just creates a text field with the name of the attachment.
      This topic has been closed for replies.

      Try this syntax on the public site

      URLRoot() & "up/" & dbid() & "/a/r" & [Record ID#] & "/e11/v0"

      Adjust the 11 to the field ID of the file attachment field.

      That link should work both on the public site and also as a Sync or look up field in another table. Normally you have to click the box to allow that file attachment field to be viewed without logging in but it sounds like it�s an EOTI app anyways.
      You probably want to wrap it in some kind of if statement which checks if there is indeed a file uploaded otherwise the formula should be made to calculate to null.

      That way when users are using the link in the Sync table the link will be blank if there�s nothing to be viewed.
      • SarahClark
      • Author
      • Registered
      • August 2, 2019
      My hero comes through again!
      Have a great weekend.
      Terms & ConditionsAccessibility statement