Form - validation rule

[optimizsql]

Hi Community,

My goal:

Use a form / validation rule to find if in a long text the first word is for instance “SELECT”, if the first work is not that word, I will block the submit button with an appropriate message.

Have tried:

• Pipe with “startwith” - Didn’t work
• Equation text function - Didn’t work.

How to:

• How to do it ?

Regards
Eric

[SafetyUniversity]

Hi Eric-

The validation rules in the form Page Builder only allows the starts with…not “does not start with” option.

I am not sure if a work around…I also don’t know how your app is created for this functionality.

If you are unfamiliar with for validation rules you can go into your form in the Page Builder, selecting “Rules” then selecting the text filed and then “starts with”. This will default to “custom” and then a form filed you can type in your word.

Add a message when it doesn’t start with select

[moe]

You can reference this similar post:

Record validation with regex

Hi @alex! Welcome to the community. I’d be happy to show you. Install the “Tadabase Text Utiltiy” pipe. [image] Open a form where you want to add validation and add a new pipe: [image] Add the Regex Checker and set all 4 Parameters: Set the Regex to whatever regex value you wish. In my case, I’m testing to make sure that “Moe” is entered. (This is a simple example, you can achieve without regex, but trying to keep it simple here). Next where setting the value to be checked, whi…

For the regex value, simply use this:

/^(SELECT|select)/