InfoPath 2010

Re: Custom Pattern Validation Rule - Unable to use Apostrophes?

Hilary Stoupa — Tue, 15 Dec 2020 15:53:29 GMT

Wonderful! Glad we could come up with a work-around!

Re: Custom Pattern Validation Rule - Unable to use Apostrophes?

Nerge — Tue, 15 Dec 2020 09:42:57 GMT

That seems to work perfectly and just what I needed - thank you. :)

Re: Custom Pattern Validation Rule - Unable to use Apostrophes?

Hilary Stoupa — Mon, 14 Dec 2020 15:33:38 GMT

Here is a copy saved as 2010 compatible.

Re: Custom Pattern Validation Rule - Unable to use Apostrophes?

Nerge — Mon, 14 Dec 2020 08:58:11 GMT

Thank you, although I can't open that in design view as it says it was created with a newer version of InfoPath - I'm on 2010 right now - is it a 2013 version?

Re: Custom Pattern Validation Rule - Unable to use Apostrophes?

Hilary Stoupa — Fri, 11 Dec 2020 15:48:37 GMT

That's because I forgot to attach it! ;)

Re: Custom Pattern Validation Rule - Unable to use Apostrophes?

Nerge — Fri, 11 Dec 2020 09:01:27 GMT

Hi Hilary.

Thanks for that.

I'm new to posting here so may be missing something, but I can't see the linked file you mentioned.

Thank you.

Re: Custom Pattern Validation Rule - Unable to use Apostrophes?

Hilary Stoupa — Thu, 10 Dec 2020 19:35:28 GMT

Oh, interesting! I wonder about using two validation rules - your stricter rule if the subsubstring-before the "@" does not contain an apostrophe, and a different pattern that allows any character if it does. Clunky, but I'm not thinking of another workaround offhand.... I've attached a sample, just right click the linked file and save it locally, then right click the saved file and select Design to open in design mode....

Custom Pattern Validation Rule - Unable to use Apostrophes?

Nerge — Thu, 10 Dec 2020 11:27:10 GMT

Hi Everyone, I'm having a problem with a validation rule that we're using on text fields that we're using for email entry on some forms. We're using the following custom pattern to try and ensure people are entering emails in a standard format, if they don't they get the usual red outline/advisory text on the field: [a-zA-Z0-9._%+\-]+@[a-zA-Z0-9.\-]+\.[a-zA-Z]{2,4} The issue we have is this rule can't handle form users who have an apostrophe in their name, they'll get the invalid email text etc. I have tried to add an apostrophe in here but it always shows as an 'Invalid pattern' on the 'Data Entry Pattern' window; there's also no option for apostrophes in the 'Insert a special character' drop-down on the same window. I assume this is because an apostrophe may be some sort of reserved character in InfoPath, is there any way around this without resorting to code etc? Thank you.