Newbie Questions

Re: Numeric field in a SharePoint List being brought back with decimals

cheason — Wed, 29 May 2013 09:47:17 GMT

Hilary,

Many thanks - I've used substring before, but I'm not actively creating forms every hour of the given day to remember all the permutations possible in InfoPath - so thanks for refreshing mind - an explanation to my old age maybe?! ;o)

Jason.

Re: Numeric field in a SharePoint List being brought back with decimals

Hilary Stoupa — Tue, 28 May 2013 15:30:24 GMT

Actually, SharePoint stores the data as a decimal type. There are display options in a view to allow you to not display the decimals, but they are there.... And InfoPath is just brining back the data.

So - generally, if the decimals are making a mess for me, I use substring-before to get rid of everything before the "." if I am using the data to set another field's value....

Numeric field in a SharePoint List being brought back with decimals

cheason — Tue, 28 May 2013 14:55:21 GMT

This is really probably a daft question, but why would a numeric field with no decimal places in a SharePoint list (read from data connection) import into a form with many numerical places?

So this in the list : 4

Becomes this in InfoPath 2007 : 4.00000000000000

In infopath the field is simply a text field, which is fine as I'm concatenating it with other information.

Bizarre weirdness going on somewhere....