User names in "Show Message"?

[Richard-SNN]

I found:

Extract User Name Text from User Table

Hey Gio, We would like to have the ability to extract the User Name as text from the User Table. Currently, you can only extract the record ID as the generated random string made for each record, but it would be nice to utilize their actual User Name that is displayed without having to create a custom field in the User Table and having to enter their name in a second place. This could be helpful in a lot of situations where the User Name needs to be recorded to another table, list, or connect…

And I wanted to confirm that this has not changed as of LTS 8.2?

Right now I’m trying to pop up a message of the user which has previously checked out an order. Currently the UID is presented instead of a name even though the variable type is set to “User”.

I have tried the following but it only produces “null” for the message:

b ' + @Table Record.Selected_MRB_Record.Work Order Number  + ' successfully checked out to ' + user_id_to_user(totext(@Variable.CheckOutEmployee ))

[Grant]

Hey @Richard-SNN,

That looks right - are you sure that CheckOutEmployee or Work Order Number are not null, which would result in the entire expression being nullified?

[Richard-SNN]

Yes, If I just use CheckOutEmployee then it works fine but shows the UID instead of the User name.

[Richard-SNN]

I tried simplfying the whole expression to user_id_to_user(totext(@Variable.CheckOutEmployee )) and it still produced a null.

[Grant]

Sorry for the confusion @Richard-SNN.

It looks like I was wrong - it might be null because it’s detecting the user id with quotes as "randomID", which you can use TRIM(TOTEXT(user), '"') to replace. However, in show message, it’s still reporting the name as part of the user object. I don’t think there’s an easy way to pull the user’s plain text name without:

1. Using the current logged in user, which you can extract the name of.

2. Using some form of secondary storage where you store the user object and a plain text name representation (i.e. if you pull from a user column in a table you would also store the plain text name).

I’m going to follow up on an open product suggestion we have to extract the user’s name from their user object.

[thorsten.langner]

Hi @Grant ,

maybe you should consider adding a “by ID” option in user-based trigger functionalities.

Then it would be possible to access all of the User Fields.

It would also be useful, to access the User-Table with a record placeholder as all other Tulip-Tables.

[Richard-SNN]

In this case, it’s unlikely to be the currently logged in user. We allowing engineers to “check out” orders from a storage location and keeping a transaction log of who has the order checked out.

[Grant]

Yeah, I think we need a way to extract the name reliably from a user object. That’s how I’m planning to structure the suggestion. Either by accessing the child attribute similar to what is possible with the current logged-in user or through some expression.