How to hide field logging details?

  • 0
  • 1
  • Question
  • Updated 1 month 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 1 month ago

  • 0
  • 1
Photo of Everett Patterson

Everett Patterson

  • 762 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

  • 52,786 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

  • 762 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

  • 52,786 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

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

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

Photo of Everett Patterson

Everett Patterson

  • 762 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

  • 762 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

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

QuickBaseCoach App Dev./Training, Champion

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