InfoPath Dev

The input of any currency will work such as 2000000 and it will convert to $2,000,000

However, I am also using the form to view data from a list while using the InfoPath form.

I have wrote a few pattern validation rules, but the error "Only integers allowed" (see below) continues to persist.

 The list may be returning decimal values - which would explain the error. You may need to put the field on the form again, and set it to display the value as text so you can see what the actual value is.

I have just create a validation rule and a XPath Function action.

It's not working on my InfoPath form See conditions below:

Hilary Stoupa:

 The list may be returning decimal values - which would explain the error. You may need to put the field on the form again, and set it to display the value as text so you can see what the actual value is.

Hi Davydcondy,

May we know whay you are using a validation pattern for this field? I'm not sure what you need this validation for since setting the field data type to Whole Number already validates if the value entered aren't numbers.

Hilary might probably be right regarding decimals. Could you also try setting the data type to Decimal instead of Whole Number?

If this doesn't work, kindly attach a sample of your form so we may have a better understanding of what isn't working for you.

Validation Pattern:


DollarCurrency > does not match pattern > Custom Pattern: $?[0-9]+


Run type: Action


Set a field's value = translate(ExternalFieldInteger, "$,", "")


The issue occurs when there are symbols in the field. This happens only when viewing (retrieving) the field from the external list to the InfoPath form. The error still persist when using the decimal (currency symbol format).

donstephen:

Hi Davydcondy,

May we know whay you are using a validation pattern for this field? I'm not sure what you need this validation for since setting the field data type to Whole Number already validates if the value entered aren't numbers.

Hilary might probably be right regarding decimals. Could you also try setting the data type to Decimal instead of Whole Number?

If this doesn't work, kindly attach a sample of your form so we may have a better understanding of what isn't working for you.

I am still unsure why you need a validation to allow numbers only. I am pretty sure you don't need to add the validation rule since setting the data type to Whole Number or Decimal already validates the value inserted. Is there a scenario here that doesn't work without the validation rule?

Are there functions and conditions to create our own currency format? Let me know, thank you!


I will post a solution, once I find one.

donstephen:

I am still unsure why you need a validation to allow numbers only. I am pretty sure you don't need to add the validation rule since setting the data type to Whole Number or Decimal already validates the value inserted. Is there a scenario here that doesn't work without the validation rule?

You can create your own format using a custom pattern. Could you provide me with an example so I can try to create a custom pattern for you?

A pattern for the TEXT date type would be the same as the currency format pattern; however, i do NOT want to use the integer or decimal data type


A $ dollar sign symbol before all number and a comma before any three digit symbol.