Log edits of another field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

created a QA section with Question and Answer in the same table as 2 separate fields.  I tried to log the answers with user and date but they end up so cluttered.  So I'm wondering if its possible to created a separate field that will log the edits.  So if there's an answer and I want to change, the log field will have the original answer and log the new one while the answer field will just have one.  How can this be done?  


-Thx

Photo of Yang

Yang

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,332 Points 50k badge 2x thumb
It will probably be cleaner to have a two table setup where 1 Q has many As.

But in a 1 table setup, you can make a new formula TEC field with the formula

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

That will parse out the most recent update. So show that field in reports alongside the question.
Photo of Yang

Yang

  • 0 Points
was this a separate Formula Text field?  Because I tried to copy and paste the code and it says I don't meet the requirements of the function "Right".
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,332 Points 50k badge 2x thumb
I think I had a syntax error
Try this.

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