Forum Discussion

WilliamLatimer's avatar
WilliamLatimer
Qrew Cadet
7 years ago

How to hide field logging details?

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?
Forms
Formulas and functions
reports and charts
  • EverettPatterso's avatar
    EverettPatterso
    Qrew Captain
    7 years ago
    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.





  • WilliamLatimer's avatar
    WilliamLatimer
    Qrew Cadet
    7 years ago
    Ok, thank you for the response. Let me zone on this and see if I can reproduce what you have shown me.

    Thanks,
    William
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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))
  • WilliamLatimer's avatar
    WilliamLatimer
    Qrew Cadet
    7 years ago
    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.
  • WilliamLatimer's avatar
    WilliamLatimer
    Qrew Cadet
    7 years ago
    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?
    • EverettPatterso's avatar
      EverettPatterso
      Qrew Captain
      7 years ago
      Are you talking about the [Date - Name] part? You don't want to see that in the formula field references?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Sorry, I'm not understanding.   Maybe give just one example of what is in a field and how you want it to show.
  • WilliamLatimer's avatar
    WilliamLatimer
    Qrew Cadet
    7 years ago
    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.
    • EverettPatterso's avatar
      EverettPatterso
      Qrew Captain
      7 years ago
      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],"]"),"[")))



    • WilliamLatimer's avatar
      WilliamLatimer
      Qrew Cadet
      7 years ago
      struggling with syntax.  Below is my attempt to do the Last Log Without Date/Name:

    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      My formulas work when logging is done with the newest entries last, the default way of logging