Forum Discussion

JulieMeeker's avatar
JulieMeeker
Qrew Cadet
6 months ago

Working with Text Multi Line Field

Is there a special character at the end of each comment when using the "Log the edits to this field, and show them on forms"?  I would like to use a formula text field to peel off the last entry logged.  

  • There are some useful formulas for peeling off information about the most recent entry assuming that you have the newest entry at the bottom.  

     

    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))

    • SteveLaurel's avatar
      SteveLaurel
      Qrew Cadet

      MarkShnier__You- Using this formula - Trim(Right([my update field],"]"))

      How do I remove the -------------- that come after the ]

      Thanks

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        When you ask for the entries to be on separate lines, it adds those dashes.

        try this

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