Forum Discussion

Qrew Trainee

9 years ago

How can I create a formula to count the number of times a field has been modified?

I have a multiple choice field, [ISR Calling Status], that logs the entries. I want to create a formula field that counts the number of times that field has been modified (timestamped). Is there a fo...

Formulas and functions

Tables and fields

Qrew Trainee

8 years ago

Mark, is there a way to do this for a file field? I would like to count the number of revisions that have been uploaded to a file field, in order to use that revision count number for another formula.

PAULPAUL
Qrew Trainee
8 years ago
Figured out my own answer. What I did was create a new text field title [PDF Revision History] which is logged. I then created a form rule that read as follows:

When the record is saved and [File] has been changed
Change [PDF Revision History] to the value in [File].

Note: Thanks again Mark! I found this formula from a question you answered previously in:
https://community.quickbase.com/quickbase/topics/how-to-track-revisions-to-a-pdf-file

I then created a new field with the forumula you had listed above and modified it:

Count(
Part($value,2,"]"),
Part($value,3,"]"),
Part($value,4,"]"),
Part($value,5,"]"),
""

This counts the number of times the [PDF Revision History] field has been modified which directly correlates to my [File] field.
- FrancescoSpiga1
  Qrew Cadet
  6 years ago
  What if the Attachments are saved in a separate table?
  How do you get the count? (excluding the summary fields here, as the file will be replaced and not added in the child table)
  
  ------------------------------
  Francesco Spiga
  ------------------------------