Easy way to just show user's first name

Need help
1

Is there a way to show just the first name of a user? In my database I have USERS which obviously have a name associated with it. Is there a way I can format the display to only show the first name?

2

Yes, there is a Regex expression you can use but it would be better to have 3 name fields in the User table.

  1. fullName
  2. firstName
  3. lastName
3

Hi there, @iamjoshgreen… if the name field in your User data type stores a user’s full name, you can use the :split by operator to split the name by a space character and get the first item, and you should be good to go. So, something like this…

split
split876Ă—286 17.4 KB

Note that you literally type a space character in the Text separator field.

Hope this helps.

Best…
Mike

3 Likes
4

Perfect! THANKS @mikeloc

1 Like
5

This topic was automatically closed after 70 days. New replies are no longer allowed.