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
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))
... ie in View mode just show the formula for 
Most recent value (formula text field type)

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

Thank you so much work beautiful so now you helped in the past to only show the first input see in another formula the formula below

var text LogField = [Is the goal measurable?];
If(Trim(($logField))<>"", 
"[" & Left(NotLeft($LogField,"["),"["))

but the formula above shows the date and QB user who made the input

"[MAR-05-19 pba@nextsteppcs.org] second input

How can I trim the first par with is the log entry ("[MAR-05-19 pba@nextsteppcs.org]) that only show me the date input (Second Input)

overall  First value (formula text field type) is what I am looking for help 

Thanks 



sorry I mean to say the Date input Only 
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,074 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.
This particular set of formuals will work if you have the logging field set to show the new entries at the bottom.