function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
ceolstadceolstad 

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!
TCAdminTCAdmin

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.