How can I hide log entries information in my form

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I have a text Multi-line filed that I set up with log entries for tracking purposes. I am trying to hide user and date on the form; I am looking to show in my form only the information not who make de edit record
Photo of Data System Specialist (Administrator)

Posted 4 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,894 Points 50k badge 2x thumb
Here are three useful formuals

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))
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,894 Points 50k badge 2x thumb
I am very confused by your question.  I provided three different formula to use depending on which element of the append only fields you are trying to parse out.

My formulas only work if the new entries are on the end of the list.
Photo of Josette Trux

Josette Trux

  • 70 Points
How would write the formula if the new entries are at the end of the list?
Photo of AustinK

AustinK

  • 1,054 Points 1k badge 2x thumb
My formulas only work if the new entries are on the end of the list.
Josette, it should already function that way.
(Edited)
Photo of Josette Trux

Josette Trux

  • 70 Points
It doesn't though.  I used the formula provided here and it returns the oldest entry.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,894 Points 50k badge 2x thumb
This particular set of formuals will work if you have the logging field set to show the new entries at the bottom.