Discussions

Expand all | Collapse all

How to hide field logging details?

William Latimer10-30-2018 19:19

QuickBaseCoach Dev./Training10-30-2018 19:54

  • 1.  How to hide field logging details?

    Posted 10-30-2018 17:31
    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?


  • 2.  RE: How to hide field logging details?

    Posted 10-30-2018 18:53
    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.







  • 3.  RE: How to hide field logging details?

    Posted 10-30-2018 19:05
    Ok, thank you for the response. Let me zone on this and see if I can reproduce what you have shown me.

    Thanks,
    William


  • 4.  RE: How to hide field logging details?

    Posted 10-30-2018 19:13
    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))


  • 5.  RE: How to hide field logging details?

    Posted 10-30-2018 19:15
    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.


  • 6.  RE: How to hide field logging details?

    Posted 10-30-2018 19:19



  • 7.  RE: How to hide field logging details?

    Posted 10-30-2018 19:21
    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?


  • 8.  RE: How to hide field logging details?

    Posted 10-30-2018 19:41
    Are you talking about the [Date - Name] part? You don't want to see that in the formula field references?


  • 9.  RE: How to hide field logging details?

    Posted 10-30-2018 19:27
    Sorry, I'm not understanding.   Maybe give just one example of what is in a field and how you want it to show.


  • 10.  RE: How to hide field logging details?

    Posted 10-30-2018 19:53
    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.


  • 11.  RE: How to hide field logging details?

    Posted 10-30-2018 20:22
    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],"]"),"[")))





  • 12.  RE: How to hide field logging details?

    Posted 10-31-2018 14:55
    struggling with syntax.  Below is my attempt to do the Last Log Without Date/Name:



  • 13.  RE: How to hide field logging details?

    Posted 10-31-2018 15:02
    Try it without the If Statement

    Trim(Right([Status],"]"))


  • 14.  RE: How to hide field logging details?

    Posted 10-31-2018 15:07
    That works, but it now is showing the history of values rather than only the most recent.


  • 15.  RE: How to hide field logging details?

    Posted 10-31-2018 15:09
    This is what it was prior to this last change:

    var text LogField = [Phase];

    If(Trim($logField)<>"", 
    "[" & Left(NotLeft($LogField,"["),"["))


  • 16.  RE: How to hide field logging details?

    Posted 10-31-2018 15:15
    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.


  • 17.  RE: How to hide field logging details?

    Posted 10-31-2018 15:25
    Is the logging field set to show new entries at the top or bottom?



  • 18.  RE: How to hide field logging details?

    Posted 10-31-2018 17:04
    At the top.


  • 19.  RE: How to hide field logging details?

    Posted 10-31-2018 17:08
    just as your screenshot, I deselected "show entries at the bottom of the field


  • 20.  RE: How to hide field logging details?

    Posted 10-31-2018 18:16
    This one should work

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



  • 21.  RE: How to hide field logging details?

    Posted 10-31-2018 18:16
    This one should work

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



  • 22.  RE: How to hide field logging details?

    Posted 10-31-2018 18:56
    Yes, this works.  Only thing is that it leaves the "-------------" from the log info separator.



  • 23.  RE: How to hide field logging details?

    Posted 10-31-2018 19:47
    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


  • 24.  RE: How to hide field logging details?

    Posted 10-31-2018 20:03
    Got it!!  Thanks!!


  • 25.  RE: How to hide field logging details?

    Posted 10-30-2018 19:54
    I suggest using the formulas I provided above.


  • 26.  RE: How to hide field logging details?

    Posted 10-31-2018 15:57
    My formulas work when logging is done with the newest entries last, the default way of logging