Change Record / Log Entries

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
Hello,
i have a text field, with entry logging turned on. Then i am using a quick base action to write certain information into the flied as the record changes.  

The table that the record lives in managers purchase orders. 

So i am looking at the purchase orders status. [ PO , RFQ, PAID ] 

Also looking at some trigger fields that send notification out. 

The actions write information into the text field based on various criteria that we want to track. Its working but i the log entries function on the text field put in the user name of the person who owns the action, i have also notified that it changes the last modified by on the record to the action owner. 

Is there a way for me to either gen rid of the text between the [ ] or to log entries with the username/email of the action owner? 

Photo of Sumedha Weerasuriya

Sumedha Weerasuriya

  • 366 Points 250 badge 2x thumb

Posted 7 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
The Action runs under the userid of the Action Owner.
But you can write the value of the [Last Modified by] field on the original record  into a field on your log table so that you know who actually made the change.

As for the parsing out of the data in that field, I an not understanding why you need to turn on the Log changes attribute' of the field in the log table as the log table itself is recording the date and the time and can record who made the change by recording the last modified by.

I can help you write a formula to parse out the info you need, but why create that problem in the first place?
Photo of Sumedha Weerasuriya

Sumedha Weerasuriya

  • 366 Points 250 badge 2x thumb
Hi Mark! Thanks for your speedy reply.

So, i do not have a log table. i am trying to get a way with just using a log changes field on the record. I can see how having a log changes table, with a quickbase actiion to create a record every time a record is changed would create history. I am looking to just find a light weight way of doing this.

IF i could just get rid of the text in between the [ ] then it would work :) 

 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
The formula to parse out the most recent entry is

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

so this would be a new formula text field.