Forum Discussion

dbryant4891's avatar
dbryant4891
Qrew Trainee
6 years ago

Formula Date Field to Extract Date from Log Entry Field?

Is there a formula, or a way, to have the date from a log entry field pulled into a separate field or into another formula?  Here's my setup and what I'm trying to accomplish: 1. A hearing is com...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
I only have time right now to provide you with the formulas to extra out the three parts of an append only field.  These formula assume that the newest entries are at the bottom

Parsing Append Only Fields

so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry. I am also assuming that you are logging the date and not the date and time.

Most recent value (formula text field type)

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

Date of most recent update (this needs to be a formula date field)

ToDate(Left(Right([my update field],"["),9))

Who did the most recent update (formula text field type)

Trim(NotLeft(Left(Right([my update field],"["),"]"),9))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
BryanHelgeson's avatar
BryanHelgeson
Qrew Member
3 years ago
What do you do if the most recent entry is at the top of the list?

------------------------------
Bryan Helgeson
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    This formula will probably work to parse out the most recent entry. But I have not tested it in years.


    Trim(Right(Part(NotLeft([append at top],1),1, "["),"]"))

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      Where is a complete set of formula is when the append only newest entries are at the top is at the top.  

      Most Recent Entry
      Trim(Right(Part(NotLeft([append at top],1),1, "["),"]"))

      Date of Most Recent Entry
      ToDate(NotLeft(Left([append at top], " "),1))

      Name who did the most recent entry

      NotLeft(Left([append at top], "]"),11)

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