Forum Discussion

ChrisDobberfuhl's avatar
ChrisDobberfuhl
Qrew Member
5 years ago

Counting Date/time field changes

Is it possible to create a formula that will keep a running count of how often a date and time field changes?  I make daily uploads tracking hardware login information and I am attempting to track a fields times its updated.  I found an old formula that will supposedly track a text field change ( I will post bellow) but the text field may not change for some of my users.  In addition this formula does not seem to actually increase in values.

var text value = [Last Login User];

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,"]"),
)



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

15 Replies

  • Are you importing into a text field that has logging enabled?  What does your data look like in  [Last Login User]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • ChrisDobberfuhl's avatar
      ChrisDobberfuhl
      Qrew Member

      On the text field options I have the following:

      Input type: User Input

      Log the edits to this field, and show them on forms. Selected

      Show the name and date on the same line as the entry.  Selected 

      Show new entries at the bottom of the field. Selected
      Show full names instead of user names.  Selected
      Show the time in addition to the date. Selected

      My data is just a list of names.  examples: Bob Smith, Ellen Davis, etc.



      ------------------------------
      Chris Dobberfuhl
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        Can you post an example of what is actually in the field on an example record?

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------