Formula text field = list user fields

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Why can i not include a [user] or [user list] type field in a formula text field?  I want to make the text field = user field.  

What are the limitations when working with user fields?
Photo of Geoffrey

Geoffrey

  • 2,020 Points 2k badge 2x thumb
  • frustrated

Posted 2 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
I think you have to explicitly convert them to text:

ToText([user])
Photo of Kipp

Kipp

  • 258 Points 250 badge 2x thumb
This produces the user's email address when I include it as a part of my text formula field. Do you know how to make it display the user's name instead?
(Edited)
UserToName([User]) will work for a User field
Photo of Geoffrey

Geoffrey

  • 2,020 Points 2k badge 2x thumb
That worked perfectly.  Now how good are your webhook skills?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
I have mad webhook skills. However, tonight I am giving a 5 minute lightning talk on Service Workers at my local JavaScript meetup and all my time today is going into trying to fit my presentation into such a short time frame. Ask about webhooks in another thread and either someone else will answer today or I will answer tomorrow.

Service Workers coming to Empower 2017. Be there!

https://www.youtube.com/watch?v=wl3kKBw-MGk&feature=youtu.be&t=1m15s