How can I use the revision history of a file attachment in a formula for another field?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I want to use the revision number of a file attachment in the file name of the attachment, so maybe a "last revision number +1" in creating the file name for the attachment.  How do I access the revision number in a qb formula?
Photo of Jeff


  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of Eric


  • 40 Points
The API Guide contains an appendix describing the file attachment path, and specifically how to access various revisions:
Photo of Kevin O'Boyle

Kevin O'Boyle

  • 602 Points 500 badge 2x thumb
has anyone solved this yet?  I have the same question.  looking at the API guide, it would be nice fi there were a formula for VID like DBID, but that isn't the case
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
I know you can reference the version # when you are creating a formula field to read the value of the file attachment.

URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e240/v0"

Not sure about pulling the number of revisions.

Maybe consider using a child table as the "Document" storage location, and then you can count the number of child documents, and have all sorts of control of revisions that way.
Photo of Jeff


  • 10 Points
I'm somewhat ignorant to html, how does the v0 become the actual version # in this example?  wouldn't it always show as v0 as in quotes?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
The version information of a file attachment is only available through the API_DoQuery method with the format structured (ie &fmt=structured) being requested.

<field id="6" field_type="file" base_type="text">

If you need access to the version information you have to use script or mockup your own versioning system using a child table as Matthew suggested.