Expand my Community achievements bar.

SOLVED

CONCAT values from Task Custom Form & Project Custom Form

Avatar

Level 2

Hi all,

 

I've been asked if it's possible to CONCAT a couple of values from different custom forms on 2 different objects.

 

The calculated field is on a Task Report and I hoped some of the values on the Project's Custom Form could be used in the calculation.

 

See attached - Product, for example is on the Project Form but IC - Channel is on the Task Form.

 

Setup (1).png

 

Any thoughts?

 

Thanks

1 Accepted Solution

Avatar

Correct answer by
Level 7

Hi Andy,

 

Yes, that's absolutely possible, though a little trickier. You need to first know the object type of the form you're building (Task), the object type where the field you want to reference exists (Project), and the exact API name of the field on the other object. My very simple example below on a Task form would concatenate the Name of the Task itself, then go to the Project and get the Name field to concatenate that next. 

 

KatherineLa_0-1705602137382.png

 

In your example, let's say that the 'DE:IC - Channel' field were actually on your Project object, you would alter the formula to read as below. 

 

  1. Before:  {DE:Segment},"-",{DE:IC - Channel"}
  2. After:  {DE:Segment},"-",{project}.{DE:IC - Channel"}

 

This can be used for more than one jump, going back to my original example and say I wanted to pull in the name of the Portfolio that the Task's Project lived in, I would do that as below. That can be a little tricker because you have to know the relating object as well, a Task doesn't have a Portfolio, that attribute belongs to the Project the Task is in. 

KatherineLa_1-1705602466028.png

 

 

 

 

 

View solution in original post

3 Replies

Avatar

Correct answer by
Level 7

Hi Andy,

 

Yes, that's absolutely possible, though a little trickier. You need to first know the object type of the form you're building (Task), the object type where the field you want to reference exists (Project), and the exact API name of the field on the other object. My very simple example below on a Task form would concatenate the Name of the Task itself, then go to the Project and get the Name field to concatenate that next. 

 

KatherineLa_0-1705602137382.png

 

In your example, let's say that the 'DE:IC - Channel' field were actually on your Project object, you would alter the formula to read as below. 

 

  1. Before:  {DE:Segment},"-",{DE:IC - Channel"}
  2. After:  {DE:Segment},"-",{project}.{DE:IC - Channel"}

 

This can be used for more than one jump, going back to my original example and say I wanted to pull in the name of the Portfolio that the Task's Project lived in, I would do that as below. That can be a little tricker because you have to know the relating object as well, a Task doesn't have a Portfolio, that attribute belongs to the Project the Task is in. 

KatherineLa_1-1705602466028.png

 

 

 

 

 

Avatar

Level 2

@andy  Please try this calculation in the task calculate field. Try referencing the {project}.{fieldname} to pull project customform data into your task calculate fields.

CONCAT({project}.{DE:Product}, " - ", {DE: IC - Channel})
Hope this helps.