General

Re: How to set a number format for a InfoPath form (when setting fields using rules)

Trevor Arter — Mon, 12 Aug 2013 07:36:24 GMT

Solved it using

number(xdXDocument:GetDOM("FormConfig")/dfs:myFields/dfs:dataFields/dfs:FormConfig/@FieldValue[../@FieldName = "UpgradeFactor"]) div 100

Thanks for your help.

(It was in the InfoPath 2007 client, using a button click to query a SharePoint list)

Do you know where I can find a good description of the syntax of these xPath functions for use in rules?

Regards

Trevor

Re: How to set a number format for a InfoPath form (when setting fields using rules)

Patrick Halstead — Sun, 11 Aug 2013 05:57:01 GMT

Is this happening in a browser form or within the InfoPath filler? What are you using to query the data from SharePoint?

I suspect what may be happening is that SharePoint may be returning region-formatted data (e.g. 0,25) and that you are getting the validation error when the 0,25 value is set to the field, because it is not a valid XML number.

One way to check this is to display the value in an Expression Box with the formatting set to None.

If the number will always be between 0 and 1 (i.e. won't have any thousands separators), one thing you can do is use translate() to convert the commas to periods:

translate(xdXDocument:GetDOM("FormConfig")/dfs:myFields/dfs:dataFields/dfs:FormConfig/@FieldValue[../@FieldName = "UpgradeFactor"], ",", ".")

Could you give that a try?

Incidentally, 25 div 100 should work, but you need to put spaces between the numbers and the div.

How to set a number format for a InfoPath form (when setting fields using rules)

Trevor Arter — Thu, 08 Aug 2013 14:45:39 GMT

Hi Experts

I have an an InfoPath 2007 form (submitting to SharePoint 2007) which needs to work in an international environment where some PC's have European regional settings, and some have US/UK settings.

I have a button which when clicked sets a field's value to a value called UpgradeFactor which is fetched from a secondary data source (configuration list on the same SharePoint site)

xPath for the rule:

(set a fields value to...)

xdXDocument:GetDOM("FormConfig")/dfs:myFields/dfs:dataFields/dfs:FormConfig/@FieldValue[../@FieldName = "UpgradeFactor"]

UpgradeFactor is a decimal value between 0 and 1, currently set to "0.25" and the field which receives it is has type Decimal (Double)

This works fine on a PC with US or UK regional settings, but on a European one I get a validation error because of wrong data format (expecting "0,25").

How can I make the form always work with US number format?

I've already set the SharePoint site to US regional settings. I've added a culture to the form code which works fine for the code but doesn't seem to affect rules or the rest of the form:

CultureInfo culture = new CultureInfo("en-GB");

I've also tried setting the value to 25 and modifying the xPath with something like "25div100" but that didn't seem to work either.

Can anybody help?

Thanks

Trevor