111
Views
7
Comments
Allow user to enter only those Special characters that are saved in database
Application Type
Reactive

Hi All,

I got a requirement where there are some Accent names with some special character like (&*@.,')  in database and when user is entering the text in inputbox I want to allow user to enter text 
+ number and if any special character then only those special characters or accent words are present in database  are allowed to enter in inputbox.

EG: If there are À, & in database then the user can enter hdcbGYY À & other then this special character are not allowed.

Is there anyway to resolve this issue. I have even shared the .oml file.

SpecialCharacter.oml
2025-12-12 06-45-53
Nandhakumar Sureshbabu

So, your expectation is, other that the alphanumeric only the special characters that are stored in database should be allowed. Am I missing something?


2025-12-12 06-45-53
Nandhakumar Sureshbabu

If the above case was the issue then you can validate the field using JS by using the below code,

function validateTextWithSpecialChars(inputText, allowedSpecialChars) {  const pattern = new RegExp(`^[A-Za-z${escapeRegExp(allowedSpecialChars)}]+$`);  return pattern.test(inputText);}function escapeRegExp(string) {  return string.replace(/[.*+?^${}()|[\]\\]/g, '\\$&');}$parameters.IsTextWithAllowedSpecialCharacters = validateTextWithSpecialChars($parameters.UserText, $parameters.SpecialCharacters)

here, the thing is you have to pass an input parameter which contains the special character you have stored in the database.

Hope it helps.

2021-05-13 04-25-29
Vinay Jangam

Hi Nandhakuma,

No, the user can enter alpha numeric text but if user wants to enter special characters or accent number

Eg: text:-  hdhe& is allowed cause & it is there in database

Text:- gigd* not allowed cause * sogn is not present in database.

Regards,

Vin j.

2021-05-13 04-25-29
Vinay Jangam

Really,

No one in the community has the idea of resolving this issue.


Regards,

Vin J.

2025-12-12 06-45-53
Nandhakumar Sureshbabu

Hi @Vin J,

Somehow, I've tried to solve your problem. The thing is, instead of storing the special characters in database, I've directly used the input box and a variable. kindly replace that with the database. other than that, it it's totally fine, I guess.

I've attached the OML take a look at it.

Hope it helps.

mySpecialCharacter.oml
2021-05-13 04-25-29
Vinay Jangam

Hi Nandhakumar S,

Thank you for your efforts but it didn't work like my requirement  mentioned above.

Regards,

Vin J.

2023-04-17 05-19-55
Vaishali Shrivastava
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.