Solved

Is there a possibility to validate a field with regex

  • 28 October 2020
  • 2 replies
  • 111 views

Userlevel 1
Badge +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

icon

Best answer by René W 28 October 2020, 11:34

View original

This topic has been closed for comments

2 replies

Userlevel 5
Badge +15

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:

 

Userlevel 1
Badge +2

Thank you for your reply. I will try your suggestions