Solved

Include punctuation marks, such as a question mark as part of a text box

  • 16 December 2023
  • 5 replies
  • 58 views
W
Rank
Userlevel 4
Badge

We have a report that has text box with nothing but information on where to call, or order items online. 

The text box reads: Questions? Call 123-456-7890 | (yes that is a pipe symbol included) Order Online at www.company.com. For some reason it is throwing an error. I have tried using single and double quotes in various places but still no joy.

 

icon

Best answer by wmatthews1877 18 December 2023, 13:17

View original

5 replies

K
Rank
Userlevel 2
Badge

@wmatthews1877 I get the same error if I try to validate the expression, but using the characters in the report works fine with my testing on Version 2023 R1. Can you ignore the expression validation and try running the report with the characters?

 

W
Rank
Userlevel 4
Badge

There is another error “Cannot interpret the token “?” at position 11.” when the report is run.

W
Rank
Userlevel 4
Badge

I found the answer by trial and error. For anyone else that would need to include a question mark inside a text box, the formula is  ='Questions?  ' + 'Call 1-123-456-7899 | Order Online www.mycompany.com'. Even the pipe | symbol was accepted. Thank you to all who responded.

W
Rank
Userlevel 4
Badge

Sorry, I forgot to add one caveat; the text line is in the groupHeaderSection1, and not in the detail section.

Chris Hackett
Rank
Userlevel 7
Badge

Thank you for sharing your solution with the community @wmatthews1877!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved