Forum Discussion

TammyTammy's avatar
TammyTammy
Qrew Member
7 years ago

Field referencing; partial auto-fill

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.
Quickbase Automations
Tables and fields

2 Replies

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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))
  • TammyTammy's avatar
    TammyTammy
    Qrew Member
    7 years ago
    I was so excited I forgot to respond. Thank you so much- this worked perfectly!