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 ...
Forum Discussion
make a new field with the formula
UserToName([Changed By])
https://www.quickbase.com/db/6ewwzuuj?a=dr&r=e6&rl=fgv
UserToName([Changed By])
https://www.quickbase.com/db/6ewwzuuj?a=dr&r=e6&rl=fgv
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.
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.