Thanks for getting back to this.
We don't have "Supervisor ID" field as we only have the "ID" field which is the ID of everyone regardless of their position. So, for each record, we have the agent's full name and the ID would reflect that of the agent's. In that same record, the agent has the Supervisor name and I wanna add a formula field "Supervisor ID" beside Supervisor that should show the ID of the Supervisor. Is that possible?
------------------------------
Ma. Isabel Gumanid
------------------------------
Original Message:
Sent: 10-21-2019 11:16
From: Everett Patterson
Subject: Formula text field to return ID of a user
Then just change the ID field to be the Supervisor ID
ToText([Supervisor ID]) & " of " & ToText([Supervisor])
------------------------------
Everett Patterson
Original Message:
Sent: 10-18-2019 20:10
From: Ma. Isabel Gumanid
Subject: Formula text field to return ID of a user
Thank you.
Still, it returns the ID of the agent instead of the agent's supervisor in that specific record.
------------------------------
Ma. Isabel Gumanid
Original Message:
Sent: 10-18-2019 15:58
From: Everett Patterson
Subject: Formula text field to return ID of a user
Try it like this
ToText([ID]) & " of " & ToText([Supervisor])
------------------------------
Everett Patterson
Original Message:
Sent: 10-18-2019 05:36
From: Ma. Isabel Gumanid
Subject: Formula text field to return ID of a user
#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
------------------------------