Formula Issue for Name Concat

关注

Ashley Brandow

• 2024年09月20日 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

  • 2024年10月07日 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

  评论操作 固定链接
• 

  Jason Wells

  • 2024年10月15日 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

  评论操作 固定链接
• 

  Ashley Brandow

  • 2025年07月07日 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

  评论操作 固定链接
• 

  Bindhu

  • 2025年07月08日 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

  评论操作 固定链接
• 

  Ashley Brandow

  • 2025年07月08日 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

  评论操作 固定链接

请先登录再写评论。