Forum Discussion

SarahClark's avatar
SarahClark
Qrew Cadet
6 years ago

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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.