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?

Are you just looking for the URL to open up the most current file attachment on a record regardless of the file name?

Yes, and I did check using an ordinary URL field with a static default value, and it seems to grab the latest revision. But I'm not 100% sure.

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.

Mark, if I am calling this record from dashboard using URL, how would I modify the code?

Is it always the same record? If so, just copy the URL.If not, how are you going to know which record you are looking for?

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

QuickBaseCoachD
Qrew Captain
9 years ago
Are you just looking for the URL to open up the most current file attachment on a record regardless of the file name?
GB_DirectorOfOn
Qrew Trainee
9 years ago
Yes, and I did check using an ordinary URL field with a static default value, and it seems to grab the latest revision. But I'm not 100% sure.
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.
ArshadKhwaja
Qrew Commander
8 years ago
Mark, if I am calling this record from dashboard using URL, how would I modify the code?
MCFNeil
Qrew Captain
8 years ago
Is it always the same record? If so, just copy the URL.
If not, how are you going to know which record you are looking for?
QuickBaseCoachD
Qrew Captain
8 years ago
Arshad, Mathew is correct. Just expose the code from that URL on a form by removing the link name. Then copy that code that you see to your clipboard. Then make a dashboard button which is a URL and paste it in.

Then put the link name back on that field on your form.
ArshadKhwaja
Qrew Commander
8 years ago
Yes there are 4 records, each has a file attachment. I would like the user to click on the button and if possible open the file and if not download it. So not only I need to direct it to the right record but the attachment field. Not too sure if this what is addressed by Mark's solution.
- MCFNeil
  Qrew Captain
  8 years ago
  QuickBase doesn't have a native "Document Viewer", (CirrusOps does however), to view it with native QuickBase, you will always have to download the file.
  As far as finding all 4 child records and attachments from a dashboard button... Don't' think that'll happen.
  
  My suggestion is to have the parent record on the dashboard, then with one click they can open it, and see all the relating child attachments.
  
  Again this depends on your work process flow.
QuickBaseCoachD
Qrew Captain
8 years ago
This syntax will open the file - ie, cause it to be donwloaded, not just land the user on a record.

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

The 11 is the fid of the file attachment field.
The 99 is the record ID#

Mark
ArshadKhwaja
Qrew Commander
8 years ago
Thanks Mark. And how could I use this to be a URL to directly get to download menu, I would like to use a button in the dashboard.
QuickBaseCoachD
Qrew Captain
8 years ago
Sorry, I am not understanding your question.

If you click this link it will download, and yet you have no permission to that app.
https://gesco.quickbase.com/up/7j6hiif8/a/r624/e10/v0

Iis that what you are trying to achieve?

You can see that the format is similar to the URL formula format just above this post. So you build that link, and look at the result on the form and then copy it and then make a dashboard button of type URL and just paste in the link.

Forum Discussion

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