Skip to main content
Question

Formula text field to return ID of a user

  • October 18, 2019
  • 0 replies
  • 83 views

Forum|alt.badge.img+5
#field #Formulasandfunctions 

Hello,

We have a record with Agent Name, ID, Supervisor and Manager. The field "ID" returns the ID of Agent Name. What I want to do is add another field called "Supervisor ID" which should return ID of the Supervisor of that specific Agent. I'm thinking of a formula text field with this logic:

ToText([ID] of [Supervisor])

What should be the appropriate formula for this?

------------------------------
Isabel Gumanid
------------------------------
​​​
This topic has been closed for replies.

EverettPatterso
Forum|alt.badge.img+10
Try it like this

ToText([ID]) & " of " & ToText([Supervisor])​


------------------------------
Everett Patterson
------------------------------