Expand all | Collapse all

Field referencing; partial auto-fill

  • 1.  Field referencing; partial auto-fill

    Posted 02-06-2019 14:27
    I have a multi-line text field that includes log entries needed for a certain group to see. Is there a way to create another field that automatically captures the input entry but not the log info? I have one team that needs the log info and one that doesn't. I know once downloaded that could be easily managed in excel, but the managers can't do that/would prefer running it as they want it. Thank you.

  • 2.  RE: Field referencing; partial auto-fill

    Posted 02-06-2019 15:57
    Here are three formulas

    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: Field referencing; partial auto-fill

    Posted 02-08-2019 20:20
    I was so excited I forgot to respond. Thank you so much- this worked perfectly!