Forum Discussion

Data_SystemAnal's avatar
Data_SystemAnal
Qrew Cadet
6 years ago

How can I hide log entries information in my form

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
App builders
Forms

9 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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))
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      6 years ago
      ... ie in View mode just show the formula for 
      Most recent value (formula text field type)

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

    • Data_SystemAnal's avatar
      Data_SystemAnal
      Qrew Cadet
      6 years ago
      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