Skip to main content
Question

Username to text field

  • October 24, 2014
  • 0 replies
  • 881 views

I am working on a way to log changes to specific fields. I have created a history field that records all the information I want to track when it is changed into an entry in that field. My problem is there are 2 user fields that have Full Name in them and when I attempt to pull than information out and into the new History field it only prints some id number associated with that user, I want it to print the Full Name of the User. My history field is a multiline text field.

Below is the action to my dynamic form rule. It states:

When the record is saved

Action change history to <br><b>Status:</b> [Status] <br><b>Changed by:</b> [Changed by] | <b>Changed Date:</b> [Date Changed]<br><b>Tested By:</b> [Tested by] | <b>Tested Date:</b> [Tested Date]<br><br>

Again, everything in this prints beautifully with the exception of the [Changed by] and the [Tested by].

Here is what an output would look like:

-- [OCT-23-14 4:19 PM Jordan] --------------
Status: New
Changed by: -58508613 | Changed Date: 10-23-2014
Tested By: -58082747 | Tested Date: 10-24-2014

Any guidance is greatly appreciated.

This topic has been closed for replies.

make a new field with the formula



UserToName([Changed By])


https://www.quickbase.com/db/6ewwzuuj?a=dr&r=e6&rl=fgv



  • ArchiveUser
  • Registered
  • December 11, 2014
It logs the text name, but what the name was, not what it was changed to.  I have built an identical logging field that captures when a "ticket" (i have ticket app) is assigned to a new user. So it logs the person reassigning the ticket with the date time via the logging feature, but also lists the user it was reassigned to as the actual change.  Again, it updates and lists a new historical record, but the name it displays is what it was before I changed it, not what I changed it to. Sounds like the history record is created before the formula picks up on the change. Any thoughts on rearranging the actions of at the time of saving?  I'm going to try and delete the history field and readd it to see if it makes a difference. I already have the name formula field in a higher order on the form, so I know that wouldn't change anything. My thought is that I created the history field first. Maybe if I switch the creation order it will process the forumla before logging the historical change.
  • ArchiveUser
  • Registered
  • December 11, 2014
I found out the problem.  It uses the last Submitted name IF you hide the formula value. I found that I actually had to show the formula field, in the edit view, because if not the value would not update real-time while editing. Once I clicked save, it actually logged what I change the name TO, not from.
Terms & ConditionsAccessibility statement