Forum Discussion

DawnDawn's avatar
DawnDawn
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
PAULPAUL's avatar
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's avatar
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
------------------------------