Extract User Name Text from User Table

Support, Troubleshooting, & Help
1

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 connector as a text field and not a user field type.

Thank you!

Eric Singer

3 Likes
2

Hey @Esinger5, thanks for posting!!

I agree that this would be really useful to have, I have created a ticket for our product team to evaluate getting this feature added to the platform. @kevin.kononenko will be reaching out with questions that may come up and updates .

thanks again!!

gio

1 Like
3

Any news about this, Gio?
Need this too.
Regards
Chris

4

Hello there,
Do someone know a workaround for this problem ? I need to send an email mentioning the user name but I cannot extract it from the user field that Iā€™ve previously stored.
Thanks for the follow up,
Patxi

5

Hiā€¦ Any update on this topic??

6

Hey @vch -

It looks like the users name is available in app info now for the logged in user-

image
image2922Ɨ718 90.3 KB

Or any user-
image
image2928Ɨ718 94.6 KB

Does this solve your problem?
Pete

7

Hi @Pete_Hartnett

I want to extract user name (from a table record) to form a message using the expression
So after selecting a specific user from the users table,

image
image864Ɨ361 21.3 KB

I want to send a message to that user with this trigger:

trigger
trigger1447Ɨ185 18.2 KB

but this is what it turned out

image
image471Ɨ557 13.7 KB

Any suggestion?

Thanks

8

Hey @vch -

Gotcha! Right now this isnā€™t possible but I just wrote a feature request to expose all user attributes within expressions in this format:

@variable.userVar.name
@variable.userVar.badgeId
@variable.userVar.customField1
...

In the meantime, the way I usually get around user table limitations is with the use of a dedicated user lookup table:

image
image1704Ɨ556 63.4 KB

Its a bit of a workaround, but it does a decent job filling these gaps temporarily.

As a little more context-
A team was just formed internally in the engineering organization to take on a ton of work around user management. This is probably the team that will take up this request, but it might take a little longer than usual because it is looped into this larger initiative.

Hope the context helps!
Pete

9

Hi @Pete_Hartnett

Looking forward to the new featureā€¦ Thanks!

1 Like
10

Hey @vch -

On a whim, I tried to see if this was possible with a custom widget, and lo-and-behold, it is!

Attached is the widget. Instructions on how to install are here:

Setup on this widget is quite simple. Pass it the user you want the name of, and it will update the name field. So when I pass the custom widget a user it will set the name variable, to the value of that user.

image
image704Ɨ970 63.5 KB

customWidget-Get User Name.json (1.9 KB)
NOTE: This widget hasnā€™t gone through our standard code review process, so use it with caution.

Pete

11

Hello @Pete_Hartnett

your ā€œget user nameā€ custom widget is not working for out instance, any idea why? Maybe has to be updated for newer version of tulip ?

image

12

Hi Jan,

Here is the JSON file, exported from R249.

Thanks,

Aaron

customWidget-Get User Name (2).json (2.0 KB)

13

Hey @Pete_Hartnett , Any updates on this? I looked for the Product suggestions topic about this, but couldnā€™t find it.

1 Like
14

User customer widget to finish it ,
The js will be like this:

getValue(ā€˜UserInā€™, (UserIn) => {
fireEvent(ā€˜show nameā€™, UserIn.name);
});

image
image765Ɨ306 6.91 KB

image
image1037Ɨ488 16 KB

15

Giving this feature another nudge as this would be very helpful to have.

2 Likes
16

Hi all,

This feature is very helpful and we have many use cases for this. Please let me whenever this feature is available in tulip.

17

Hi all,

I would also like to see a name instead of "Hi o74ramPsKcXq3ugvK "

1 Like
18

Hi folks - Iā€™m a new PM who recently joined Tulip. Quick note that this is not currently on the roadmap, but I appreciate the re-flag. Iā€™ll triage with the team to see if a quick win is feasible, and will update this thread.

Appreciate the Community & active voice of the customer!

  • Olga
3 Likes
19

If we really want this to get some attention I think we should vote on the product suggestion Richard-SNN linked to this thread: