Forum Discussion

GB_DirectorOfOn's avatar
GB_DirectorOfOn
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 and contract language, and I need them to appear in the respective sections of the project form. The two table are not related, nor do i think they need to be in that only admins will have the ability to update these controlled documents. When I use a simple URL, I can only set a static location in the default value that points to a specific document, not necessarily it's revision, nor does it populate for existing records. 

What i would love to do is create a button that will direct to say the latest negotiation document (this is a field that will be static while the revision may change.) Any ideas? 

Forms
Tables and fields
User and group management
  • ArshadKhwaja's avatar
    ArshadKhwaja
    Qrew Commander
    8 years ago
    Sorry for not being too clear.  In one of my app, we are trying to allow users to directly download a few reports from the dashboard.  Its a shame we cannot display or open a PDF.  So I have created a documents table which will only ever be a set number of documents which will continue to be updated. As a button in the dashboard would  use a URL (I think) to download such file, my question was how to use the statement you have put together to be used as URL.