Formula Issue for Name Concat

Follow

Ashley Brandow

• September 20, 2024 15:23

I have a pretty basic formula on a form that is taking the first name and the last name and putting it together like : ${GuestLecturerLastName},  ${GuestLecturerFirstName}. Generally, it works just fine. When the last name has a dash it does not work, though. The dash seems to be throwing it off. I've tried grouping it like (${GuestLecturerLastName},  ${GuestLecturerFirstName}) but that doesn't work either. 

Is there something else I could be trying to get this to work with names with dashes? 

Thank you for any suggestions!

0

• 

  Jason Wells

  • October 07, 2024 15:50

  Hello Ashley,

  Sorry for the delayed response, have you tried using quotation marks around them?

  If we are unable to find a solution, I will help you raise a ticket so we could investigate it further as a potential bug.

  Thanks,

  Jason Wells

  0

  Comment actions Permalink
• 

  Jason Wells

  • October 15, 2024 17:39

  Hello Ashley,

  For the formula control, the dash indicates subtraction or removal. Therefore, we have to include the addition operator for the proper concatenation.

  Resolution: See the image below how to achieve the correct result per the ticket:

  

   

  Thanks,

  Jason Wells

   

  0

  Comment actions Permalink
• 

  Ashley Brandow

  • July 07, 2025 17:07

  Hello again!

  This solution was working for awhile, but something changed. Now even with the addition operator and the quotes around the field, any name with a dash or apostrophe doesn't work within the formula. I have tried using parentheses around the field, around the whole name then around both the fields and the whole formula, but so far nothing will work with names with special characters. Did something change/?

  0

  Comment actions Permalink
• 

  Bindhu

  • July 08, 2025 09:08

  Hi Ashley,

  I tested the same scenario in V8 SU2.5 environment and was unable to replicate the issue. The formula solution was working fine for me. Please refer to the screenshot below for reference.

  If you are still facing this issue, I would suggest you to raise a ticket with Agilepoint Support team, they will be able to help you with this issue.

  Formula config screen

  

  Runtime Screen

  

   

  Thanks

  0

  Comment actions Permalink
• 

  Ashley Brandow

  • July 08, 2025 14:41

  Hi Bindhu, 

  In your sample it does work. However, did you try it with a last name that has a dash or an apostrophe? Such as Mc-Daniel or O'Neal(?) - that's where the issue is.

  0

  Comment actions Permalink

Please sign in to leave a comment.