Forum Discussion

Data_SystemAnal's avatar
Data_SystemAnal
Qrew Cadet
7 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...
App builders
Forms
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 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
    7 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
    7 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 



  • Data_SystemAnal's avatar
    Data_SystemAnal
    Qrew Cadet
    7 years ago
    sorry I mean to say the Date input Only 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I am very confused by your question.  I provided three different formula to use depending on which element of the append only fields you are trying to parse out.

    My formulas only work if the new entries are on the end of the list.
  • JosetteTrux's avatar
    JosetteTrux
    Qrew Member
    6 years ago
    How would write the formula if the new entries are at the end of the list?
  • AustinK's avatar
    AustinK
    Qrew Commander
    6 years ago
    My formulas only work if the new entries are on the end of the list.
    Josette, it should already function that way.
  • JosetteTrux's avatar
    JosetteTrux
    Qrew Member
    6 years ago
    It doesn't though.  I used the formula provided here and it returns the oldest entry.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    This particular set of formuals will work if you have the logging field set to show the new entries at the bottom.