Controls

Re: Whole Number (integer) for Currency Format

davydcondy — Sat, 10 Oct 2015 16:38:04 GMT

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.

Re: Whole Number (integer) for Currency Format

donstephen — Thu, 08 Oct 2015 23:28:52 GMT

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?

Re: Whole Number (integer) for Currency Format

davydcondy — Thu, 08 Oct 2015 16:20:39 GMT

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?

Re: Whole Number (integer) for Currency Format

donstephen — Sat, 03 Oct 2015 06:43:11 GMT

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?

Re: Whole Number (integer) for Currency Format

davydcondy — Wed, 30 Sep 2015 14:59:09 GMT

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.

Re: Whole Number (integer) for Currency Format

donstephen — Fri, 25 Sep 2015 06:37:50 GMT

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.

Re: Whole Number (integer) for Currency Format

davydcondy — Thu, 24 Sep 2015 18:34:58 GMT

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.

Re: Whole Number (integer) for Currency Format

Hilary Stoupa — Wed, 23 Sep 2015 19:58:37 GMT

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.

Whole Number (integer) for Currency Format

davydcondy — Wed, 23 Sep 2015 15:37:48 GMT

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.