Forum Discussion

NikkiWalters's avatar
NikkiWalters
Qrew Cadet
8 years ago

Formula used for a secondary field for a field tracking changes

I have a multiple choice field tracking changes "SAM (2018)".  I added a second field "SAM (2018)* to act as a clean field for reporting and used this formula:  NotLeft(Right([SAM (2018)],"]"),0) Th...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I suggest logging so that the new changes are at the bottom.  That is the default setting for the logging field.

"Show new entries at the bottom of the field"

Then this will work

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