Forum Discussion

BobFaulk's avatar
BobFaulk
Qrew Member
2 years ago

How to create a field that provides the recent user log info

How do I create a formula that will retrieve the most recent user and date log out of a notes field and put that in a separate field so we can see who was the last one to communicate in the notes and ...
BobFaulk's avatar
BobFaulk
Qrew Member
Just figured it out...

Trim(Left([my update field],"]"))

Thanks again!

------------------------------
Bob Faulk
------------------------------
BobFaulk's avatar
BobFaulk
Qrew Member
2 years ago
I have another question...How to I take that date I extracted and now turn it into the number of days from that last contact to today?

------------------------------
Bob Faulk
------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    2 years ago
    Bob,

    You need a Duration field

    Today()-[Calculated Note Date]

    Then make it display as Days in the format section

    ------------------------------
    Don Larson
    ------------------------------
    • BobFaulk's avatar
      BobFaulk
      Qrew Member
      2 years ago
      So if I add that to my formula...

      Trim(Left([my update field],"]"))

      What does that look like?

      ------------------------------
      Bob Faulk
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        2 years ago
        the answer that I initially provided was professed with the comment that the newest entries are being logged at the bottom. If you have your field set to log the newest entries at the top then this is the formula for a formula date field type to extract the date.

        ToDate(NotLeft(Left([append at top], " "),1))

        If you are looking to know the integer number of days between Today and that extracted date, then you could make a formula numeric field with this formula. 

        Todays(
        Today() -  ToDate(NotLeft(Left([append at top], " "),1))
        )

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------