Forum Discussion

Qrew Trainee

9 years ago

How do I make my formula-URL link to a specific record?

I have a table in which I am storing revision controlled documents, and a table which manages project steps. These documents help guide users through the stepped process with things like negotiation ...

Forms

Tables and fields

User and group management

QuickBaseCoachD

Qrew Captain

9 years ago

try this URL

URLRoot() & "up/" & [_DBID_DOCUMENTS] & "/a/r" & "99" & "/e11/v0"

In this example obviously you need to put in your own _DBID_ and then in place of the 99 insert the record ID and in place of the 11 you put the field ID of the file attachment field. The V0 means to pull the zeroth (most current) revision in the file attachment field. Note that this will work regardless of the file name.