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?
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.
If you click this link it will download, and yet you have no permission to that app.
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.