Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How do I show Portfolio and Program names in a custom calculated field?

Avatar

Level 2

I'm trying to add a field to my custom forms that creates a project name automatically. We include the Portfolio Name and Program Name in our file naming convention, but all I can get is the ID for my calculated form.

The current string is:

CONCAT(Reference Number,"_",Quarter,"_",Portfolio ID,"_",Program ID,"_",Type of Creative)

That gives me an output of this on the custom form:

12345_22SP_70b85d45115f8c4b4eb494394c2e98fd_39b85d4b005e8d02763aj93eb10ccbi0_Email

How do I get it to show the actual name of the portfolio and program instead? I tried the following, which did not work:

CONCAT(Reference Number,"_",Quarter,"_",Portfolio Name,"_",Program Name,"_",Type of Creative)

CONCAT(Reference Number,"_",Quarter,"_",Portfolio.Name,"_",Program.Name,"_",Type of Creative)

CONCAT(Reference Number,"_",Quarter,"_",Portfolio.name,"_",Program.name,"_",Type of Creative)

CONCAT(Reference Number,"_",Quarter,"_",portfolio.name,"_",program.name,"_",Type of Creative)

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 2

Have you tried this:

CONCAT(Reference Number,"_",Quarter,"_",Portfolio,"_",Program,"_",Type of Creative)

Avatar

Community Advisor

You didn't mention the non-working behavior. Is it possible that you might not be recalculating the calculated field every time you make a change to it? (if so, it would retain the answer to the initial calculation so that no matter what you do it shows the GUID)