Skip to main content
Solved

Is there a possibility to validate a field with regex

  • October 28, 2020
  • 2 replies
  • 122 views

Forum|alt.badge.img+2

I would like to validate if the input is valid, using regex.

In my case it's a text field where the user can enter an IBAN number.

 

Is there an option in the SF to do that?

 

Thanks, Regards,

 

Peter

Best answer by René W

You can use a default concept, which can use T-SQL regular expressions or call some function found somewhere. With a default you can verify the user input. Additionally you should also apply a check constraint or a trigger to make sure the default logic isn't bypassed.

There is also an idea posted about the HTML pattern tag, which might be interesting to keep an eye on:

https://community.thinkwisesoftware.com/ideas/html5-input-validation-with-the-pattern-attribute-1431

 

View original
This topic has been closed for comments

Forum|alt.badge.img+15
  • Superhero
  • October 28, 2020

You can use a default concept, which can use T-SQL regular expressions or call some function found somewhere. With a default you can verify the user input. Additionally you should also apply a check constraint or a trigger to make sure the default logic isn't bypassed.

There is also an idea posted about the HTML pattern tag, which might be interesting to keep an eye on:

https://community.thinkwisesoftware.com/ideas/html5-input-validation-with-the-pattern-attribute-1431

 


Forum|alt.badge.img+2
  • Vanguard
  • November 16, 2020

Thank you for your reply. I will try your suggestions


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings