Forum Discussion

JordanJordan's avatar
JordanJordan
Qrew Member
10 years ago

Username to text field

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.

Forms
Tables and fields

13 Replies

Sort By
    • WendyShoef's avatar
      WendyShoef
      Qrew Cadet
      6 years ago
      Is there a formula that returns the username not the user's name?
    • JordanMcAlister's avatar
      JordanMcAlister
      Qrew Captain
      6 years ago
      Can you give an example? From what to what are you wanting converted?
      There are other functions like "ToUser(text)" or "UserToEmail(User)" or "User()"

      ToUser (Text t)

      Description: Converts a screen name or e-mail address to a user value. A "user" is an individual with whom you've shared your application. You'd translate something like an e-mail address into a user value so that QuickBase recognizes the user. When you do so, you can take advantage of user fields to design permissions and/or views. For example, show a user only those tasks that have been assigned to her. 

      Example: ToUser([Email Address]) takes the values in the Email Address field and returns their corresponding user values.
      ToUser("jsmith") returns the user with the screen name "jsmith". 
      ToUser("jsmith@example.com") returns the user possessing that e-mail address.  

      ----------------------------------------------------------------------------------------------------------
      UserToEmail (User x)

      Description: Returns the user's e-mail address.

      This function won't work for users who have hidden their e-mail address.

      Example: UserToEmail([Last Modified By]) returns the email address of the QuickBase user who last modified a record.

      ----------------------------------------------------------------------------------------------------------
      User ()

      Description: Returns the user currently accessing the database. 



      Example: With this function you can create a view that selects only the records modified by the user who is currently viewing the database.



    • Gesco_QBAdminis's avatar
      Gesco_QBAdminis
      Qrew Member
      6 years ago
      Try ToText([my userid field]) to see a text field of the users username or their email address if they have not chosen a username.
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    10 years ago
    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's avatar
    ArchiveUser
    Qrew Captain
    10 years ago
    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.