You need to sign in to do that
Don't have an account?
ceolstad
Find the values of a field when you only have an ID?
Maybe this isn't possible with a simple formula...
I have a Contact lookup field on an object. I want to setup a custom link to create a new Task and pass the Name from the Contact field to the Comments field on the Task.
The problem is that since the Contact is a lookup field, only the ID is passed when the new Task is created and I want the actual text name. Since I have the ID, is there a way to create a formula that will find the First and Last Names?
Thanks!
I have a Contact lookup field on an object. I want to setup a custom link to create a new Task and pass the Name from the Contact field to the Comments field on the Task.
The problem is that since the Contact is a lookup field, only the ID is passed when the new Task is created and I want the actual text name. Since I have the ID, is there a way to create a formula that will find the First and Last Names?
Thanks!
Hello ceolstad,
As you stated, you can only access the ID of the object in the lookup field with formulas. The only way I know of to do this would be to utilize a custom s-control which can query the system utilizing that ID value. This is not as easy as formulas and does require the API to be enabled.