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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
Try this

var text value = [My text field which is logging the changes];

Count(
Part($value,1,"]"),
Part($value,2,"]"),
Part($value,3,"]"),
Part($value,4,"]"),
Part($value,5,"]"),
Part($value,6,"]"),
Part($value,7,"]"),
Part($value,8,"]"),
Part($value,9,"]"),
Part($value,10,"]"),
Part($value,11,"]"),
Part($value,12,"]"),
Part($value,13,"]"),
Part($value,14,"]"),
Part($value,15,"]"),
Part($value,16,"]"),
Part($value,17,"]"),
Part($value,18,"]"),
Part($value,19,"]"),
Part($value,20,"]")
)
  • Laura_Thacker's avatar
    Laura_Thacker
    Qrew Commander
    6 years ago
    This was hugely helpful; my only comment (for others who see this) is that if I leave in the first Part($value,1,"]"), I get an extra-count; so I commented that line out to get an accurate count.  I also switched the ] to a [ because I found that in some cases the logging field had copied the original Note entry again; but without the first/opening [, so by looking for that I got a more accurate count.  This might just happen to apply in my case.
  • ChrisDobberfuhl's avatar
    ChrisDobberfuhl
    Qrew Member
    6 years ago
    Is it possible to modify this formula to count the number of times a date / time field is updated?  I have a database of logins to a number of hardware devices and I keep track of the date and time they are logged into.

    ------------------------------
    Chris Dobberfuhl
    ------------------------------