How to hide field logging details?

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
I have a couple of fields with logging enabled.  Although I need the logging details, I want to display those fields values on a different screen/report without it also including the logging details.   Think of initial search results screen (dont show logging details) and details screen (show logging details).

Can I mask or hide the logging details when needed for better readability?
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb
One option is to use a formula text field to show the last logging details, and you can use that field on a different screen/report.

If using a form, you can use form rules to hide/show fields based on a checkbox.





Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
Ok, thank you for the response. Let me zone on this and see if I can reproduce what you have shown me.

Thanks,
William
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,792 Points 50k badge 2x thumb
These are the three formulas you will need.

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 William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
I already have a second formula text field for each of the fields I am logging.  The formula displays only display the latest/current value.  But because logging is turned on for the 2 primary fields, even when displaying the current value in the formula text field the logging info is also displayed.  That is what I would like to hide or surpress somehow.
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb

Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
the 3 columns with logging details are the formula text fields only showing current value which is what I want.  But, I don't want to see the logging info in these fields, I only want to see the logging info in the original field the formula field references.   Does this make sense?
(Edited)
Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb
Are you talking about the [Date - Name] part? You don't want to see that in the formula field references?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,792 Points 50k badge 2x thumb
Sorry, I'm not understanding.   Maybe give just one example of what is in a field and how you want it to show.
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
Yes, I am talking about the Date - Name part.  In the screenshot I shared above, the logging details makes it hard to read the actual values in that list view.  In the subsequent details page, then I do want to see the logging details of Date - Name.
Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb
Ok, you can just make two formula fields. Use one on the list view and use one on the details page.

Last Log Without Date/Name = Trim(Right([My Field],"]"))

Last Log With Date/Name = If([My Field]="", "", Left([My Field], " ") & "] " & Trim(Left(NotLeft([My Field],"]"),"[")))



Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
struggling with syntax.  Below is my attempt to do the Last Log Without Date/Name:

Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb
Try it without the If Statement

Trim(Right([Status],"]"))
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
That works, but it now is showing the history of values rather than only the most recent.
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
This is what it was prior to this last change:

var text LogField = [Phase];

If(Trim($logField)<>"", 
"[" & Left(NotLeft($LogField,"["),"["))
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
Actually, its showing the last 2 values. Strange! 

Current value and the prior value.  There are a total of 4 values historically in the field its referencing.
Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb
Is the logging field set to show new entries at the top or bottom?

Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
At the top.
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
just as your screenshot, I deselected "show entries at the bottom of the field"
Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb
This one should work

Trim(Left(NotLeft([Change Log],"]"),"["))

Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb
This one should work

Trim(Left(NotLeft([Change Log],"]"),"["))

Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
Yes, this works.  Only thing is that it leaves the "-------------" from the log info separator.

Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb
If you don't have a preference, change the logging field option to show data & time on the same line as the entry and you should not see those dashes going forward
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
Got it!!  Thanks!!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,792 Points 50k badge 2x thumb
I suggest using the formulas I provided above.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,792 Points 50k badge 2x thumb
My formulas work when logging is done with the newest entries last, the default way of logging