Custom Form Calculation

[HeatherSc2]

Hi,

I'm trying to pull the project owner name into a custom field on a form.  Owner name is not an option in the fields, but ownerID is.  I was able to use syntax for the name and it shows it in the calculation result (see image) but gives an error and won't let me save the expression.

Any ideas on how to bring in the owner name into a field?

[Alex_Di]

Hi HeatherSc2, 

You didn't indicate if this was a Project form, but you have CONCAT at the beginning but that is not formatted correctly.  Try just 
={project:owner:name}

[HeatherSc2]

Hi Alex,

Thanks.  It is a project form.  I did try that at first but when it gave the error I thought maybe it needed a command so I added the concat.  The concat does work for the owner id field so I don't think it is that syntax.

It is telling me that owner name is not a field in my system but I have used that field in reports and it will show in the preview of an existing project.

[JustinRenteria2 · Accepted solution]

Hi, for custom expressions you need to use a period instead of a colon. You also have to introduce the brackets.
The calculation should read:
CONCAT({owner}.{name})

[JustinRenteria2]

here's an article that explains the difference between the syntax and when to use what:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/...

[HeatherSc2]

Perfect!  That worked.  And thank you for the article!