Forum Discussion

ChrisDobberfuhl's avatar
ChrisDobberfuhl
Qrew Member
6 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 ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
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
    6 years ago

    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
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      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
      ------------------------------
      • ChrisDobberfuhl's avatar
        ChrisDobberfuhl
        Qrew Member
        6 years ago

        Bellow is a a few complete rows from our database:  

        Last Seen
        Building
        Friendly Name
        Serial Number
        Wifi IP
        MAC Address
        Last Login D&T
        Last Login User
        Last Login Unit
        Last Login Role
        User ID
        OS Version
        Voalte Version
        Hub Version
        MX Version
        Secure Launcher Version
        Asset ID
        Enrollment Date
        Unit Request
        Sched DD
        Completed
        Logon
        Counts
         
        01-10-2020 TCH West Campus WC2CHLDLFE10 - 5872 19021522505872 10.144.49.197 94FB296A2352 01-10-2020 08:59 AM Shelby Eggen {"WC Child Life"} {"Child Life Specialist"} 23929 7.1.2 3.6.3 19.03.0.31 4.0.0.5 4.3.0.41 1ef8ca5538f3944f4abc71b13351d5d1 06-13-2019   09-25-2019   1
        01-10-2020 TCH West Campus WCPERIOP49 - 7397 19058522507397 10.144.48.129 94FB296ED7DF 01-10-2020 08:59 AM Amy Cole {"WC Perioperative Services"} {"Education Coordinator"} 25967 7.1.2 3.6.3 19.03.0.31 4.0.0.5 4.3.0.41 0970b9b2f409d97a60ae17522aef6051 06-13-2019   09-25-2019   1
        01-10-2020 TCH Feigin Tower FC9FAMADVO09  -  7344 19058522507344 10.108.13.173 94FB296ED4FE 01-10-2020 08:59 AM Norma Salinas {"MC Family Advocacy"} {"Family Advocate"} 15316 8.1.0 3.7.9 19.11.1.5 4.2.0.3 4.3.0.41 cdac9e1a32549659f4f5e67beaf0c0ce 10-17-2019   11-11-2019   1
        01-10-2020 TCH Feigin Tower FC19SOCWRK61  -  2714 19112522502714 10.108.14.63 94FB2972DAA9 01-10-2020 08:59 AM Sabrina Morales {"MC Social Work"} {"Social Worker"} 25579 8.1.0 3.7.5 19.06.0.29 4.2.0.3 4.3.0.41 718e415d2ef9e574f5a5b7b52c7af7be 09-10-2019   11-11-2019   1


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