Discussions

Expand all | Collapse all

How can I hide log entries information in my form

  • 1.  How can I hide log entries information in my form

    Posted 03-04-2019 21:14
    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


  • 2.  RE: How can I hide log entries information in my form

    Posted 03-04-2019 22:03
    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))


  • 3.  RE: How can I hide log entries information in my form

    Posted 03-04-2019 22:04
    ... ie in View mode just show the formula for 
    Most recent value (formula text field type)

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



  • 4.  RE: How can I hide log entries information in my form

    Posted 03-05-2019 17:12
    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 





  • 5.  RE: How can I hide log entries information in my form

    Posted 03-05-2019 17:15
    sorry I mean to say the Date input Only 


  • 6.  RE: How can I hide log entries information in my form

    Posted 03-05-2019 17:40
    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.


  • 7.  RE: How can I hide log entries information in my form

    Posted 04-30-2019 19:11
    How would write the formula if the new entries are at the end of the list?


  • 8.  RE: How can I hide log entries information in my form

    Posted 04-30-2019 19:15
    My formulas only work if the new entries are on the end of the list.
    Josette, it should already function that way.


  • 9.  RE: How can I hide log entries information in my form

    Posted 04-30-2019 19:37
    It doesn't though.  I used the formula provided here and it returns the oldest entry.


  • 10.  RE: How can I hide log entries information in my form

    Posted 04-30-2019 20:14
    This particular set of formuals will work if you have the logging field set to show the new entries at the bottom.