Forum Discussion

JeffJeff1's avatar
JeffJeff1
Qrew Member
9 years ago

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

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 revis...
Formulas and functions
roles and permissions
Tables and fields
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
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.
  • JeffJeff1's avatar
    JeffJeff1
    Qrew Member
    8 years ago
    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?