Skip to main content
christinequick
Level 3
Sep 12, 2024 11:58 PM UTC
Solved

Quotation marks in the output of a calculated field

 

Does anyone know how to include quotation marks in the output of a calculated field?

 

For instance, I want the field to display: Say "hello".

The text inside the quotation marks will change based on a custom field.

 

Here's what I've tried in my calculation:

CONCAT("Say "",{DE:Greeting},""")

 

This calculation isn't working because Workfront doesn't handle the extra quotation marks properly. Is there a specific value or method to represent quotation marks in the calculation?

 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Rafal_Bainie
Rafal_BainieAccepted solution
Community Advisor
Sep 13, 2024 8:12 AM UTC

this seems to work:

CONCAT('Say ','"',{DE:Designer Name},'"')

 

4 replies

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity AdvisorAccepted solution
Community Advisor
Sep 13, 2024 8:12 AM UTC

this seems to work:

CONCAT('Say ','"',{DE:Designer Name},'"')

 

Translate
christinequick
Level 3
Sep 13, 2024 7:46 PM UTC

That worked!

 

I had to remove the apostrophes from the names of any custom fields that I wanted to use. But it was a small price to pay.

 

Thank you!

Translate
Adobe Employee
Feb 17, 2025 4:00 PM UTC

For anyone seeing this answer later, there is another way to do this as Workfront can have issues with Single Quotes in calculated fields.

If you really need to have the quotation marks you can create a single select dropdown with only a single answer available that is the quotation mark ".Then set that as the Default selection and add it to your form.

Or a calculated field with only the calculation of '"'.

Either way you can reference that field in your concat to add the quotation mark in wherever you need it. It's a bit of a hassle but it's reliable as your calculated field gets longer.

I.E.

CONCAT("Say ",{DE:Quote},{DE:Designer Name},{DE:Quote})

 

Translate
christinequick
Level 3
Feb 19, 2025 5:34 PM UTC

Clever! I'll definitely try that. Thank you!

Translate