Solved

Is there a possibility to validate a field with regex

  • 28 October 2020
  • 2 replies
  • 57 views

Badge +1

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

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:

 

View original

2 replies

Userlevel 4
Badge +14

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:

 

Badge +1

Thank you for your reply. I will try your suggestions

Reply