Browser Forms

Re: Powerful Declarative Logic: Phone Number Parsing

Lotti — Thu, 02 Apr 2009 12:23:20 GMT

Please help in infopath

The Following expression is not valid

Expected value type

string-length(translate(translate(., "()- 0123456789", "")) = 0

Re: Data Validation Not working In Browser Form

swathip — Sat, 17 Jan 2009 07:00:35 GMT

Hi,

Use he following expression to validate the text box to fulfill your requirement.

not(xdUtil:Match(string(.), "\d*")) and not(xdUtil:Match(string(.), "\d*\.25")) and not(xdUtil:Match(string(.), "\d*\.0")) and not(xdUtil:Match(string(.), "\d*\.00")) and not(xdUtil:Match(string(.), "\d*\.5")) and not(xdUtil:Match(string(.), "\d*\.75"))

Re: Data Validation Not working In Browser Form

aggiejustin03 — Fri, 16 Jan 2009 17:47:23 GMT

Okay, that does work. When previewing in the browser it works well and if I enter an invalid sequence of numbers it throws the red box around the control. However, once I publish this as a web form to MOSS it no longer places the red box around the error. Is the by design in a browser enabled form or is something else going on? It would be nice to have the red box since that is very easy to recognize as an input error for a user with basic computer skills or one without working knowledge of how the form was designed.

Re: Data Validation Not working In Browser Form

swathip — Thu, 15 Jan 2009 05:28:53 GMT

Hi,

Sorry for the late. Try the following expression.

\d*\.0|\d*\.00|\d*\.25|\d*\.5|\d*\.50|\d*\.75|\d*

Hope it will solve your problem.

Re: Data Validation Not working In Browser Form

aggiejustin03 — Mon, 12 Jan 2009 17:32:44 GMT

I have it set to auto as well as having the post back to always. However it will not allow a user to enter a whole number. If you just enter "2" or any other number it is requiring that you enter "2.0" or "2.00". If anyone knows how to require quarter hour increments while still allowing a whole number to pass through, please let me know what the custom pattern is to allow this functionality.

Re: Data Validation Not working In Browser Form

swathip — Fri, 02 Jan 2009 05:06:23 GMT

Hi,

I have tried this by setting the format to auto and its working fine for me. Once try by setting the post back settings to Always in the Browser forms tab of text box properties.

Data Validation Not working In Browser Form

aggiejustin03 — Wed, 31 Dec 2008 22:41:42 GMT

I have a per diem expense reimbursement form that has a text box for hours which is used in a calculation with a rate field to determine how much is owed to the individual. I'm trying to restrict the text box to accept hours in quarter hour increments (i.e. 2.25, 2.5, 2.75, 3). I am able to restrict it by using the following custom pattern:

\d*\.0|\d*\.00|\d*\.25|\d*\.5|\d*\.50|\d*\.75

However when you enter a whole number such as 2, 3, etc. it throws a validation error. When you enter "2.0" its fine. Also if you enter 2 it will append 2.00 (due to format being set to 2 decimals) to it but still gets a validation error. I have tried setting the decimal value to auto but still have the same problem. I also tried to add \d* without a decimal but that opens it up to any and all digits/decimal combinations. Any help with telling me how I can achieve this would be greatly appreciated! I'm about to pull my hair out!