Field referencing; partial auto-fill

Question

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.

QuickBaseCoachD · Answer

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

Sign up

Login to the community