Skip to main content
Answer

Is there a possibility to validate a field with regex

  • October 28, 2020
  • 2 replies
  • 136 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:

 

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+15
  • Superhero
  • Answer
  • 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:

 


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

Thank you for your reply. I will try your suggestions