Hi all,
We want to disable users to enter new line character (Enter) and comma in a text data type member in a PBCS web form. Because these are causing data import into Service Now and data export issues. Currently we have implemented conditional formatting and colour change if an user enters 'Enter' and 'Comma', but still some users submit the test with these characters. We want to throw an error while saving or submitting the form and disable to enter the characters.
I have tried with a calculation script like below and unable to find how to identify text characters (new line and comma) in the script.
FIX("FY19","Jan","OEP",@Relative("Account",0))
"OEP_Working"(
if(("Budget_item")==0)
@return(@hspMessage("Reminder"),ERROR);
ENDIF
)
ENDFIX
Can anyone help me with this? Really appreciate it.
Thanks