Forum Discussion

JeffJeff1's avatar
JeffJeff1
Qrew Member
8 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
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
7 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?