SharePoint Integration

Re: sharepoint "numbers" come in as "decimal"

Gracie — Wed, 08 Apr 2015 20:20:52 GMT

Hi Clay,

I have a similar situation. But I can't change the field type in SP to text because it is being used for calculations. Further, my field is a text field, but it is a drop-down list box. When the field was not a drop-down list box, I used the substring function to format, but this does not work for drop-down list boxes. Do you know how to get rid of the decimal and trailing zeroes in all of the numeric values in a drop-down list? I am using SP 2007 and InfoPath 2010. Thank you!

Re: sharepoint "numbers" come in as "decimal"

Kanji — Fri, 22 Nov 2013 06:18:53 GMT

Or you can try it number() it works for me in inforpath 2013.

Re: sharepoint "numbers" come in as "decimal"

sema atavi — Tue, 01 Mar 2011 16:54:05 GMT

you don't need to set the limit to decimal. just setting the decimal places to auto does the work.

Re: sharepoint "numbers" come in as "decimal"

Jennifer Walts — Mon, 28 Feb 2011 21:37:25 GMT

Hi, Acaspita - are you running into an issue? If so, let us know what your scenario is. I'm not able to replicate bharvey's original problem from 2008, using InfoPath 2010 and SharePoint 2010. I set my data type to Decimal and decimal places to 0. I may be misunderstanding Sema's suggestion, but setting a character limit of 3 does limit the user from entering a four-digit number ("1,500"), which may not work in your case. Thanks

Re: sharepoint "numbers" come in as "decimal"

sema atavi — Thu, 24 Feb 2011 01:25:54 GMT

following worked for me

1. Set the field as a decimal

2. In the decimal format set the decimal places to Auto.

3. Set the number of character limits to 3

Re: sharepoint "numbers" come in as "decimal"

Acaspita — Mon, 06 Sep 2010 19:21:21 GMT

Hi,

Did somebody find a solve for this?... Is there a variant... ? ...

Re: sharepoint "numbers" come in as "decimal"

khaos — Mon, 22 Mar 2010 16:58:11 GMT

Neil, Did you ever find a solve for this?

Re: sharepoint "numbers" come in as "decimal"

Neil McCaffery — Sat, 03 Jan 2009 17:32:37 GMT

Ok, I got excited for a second because both of those worked.

However, the other rules I have built on that dropdown box no longer worked. For instance, I have several rules that set the values of other fields based on the selection made in this dropdown box that I'm struggling with. Using either the 'round' or 'floor' function returns only the integer (dropdown box still displays all of the zeros when the dropdown is activated, but switches to an integer once a value is selected), but infopath can't seem to resolve that integer with the other rules.

Still stumped....

Re: sharepoint "numbers" come in as "decimal"

swathip — Sat, 03 Jan 2009 08:39:46 GMT

Hi,

Use substring-before function instead of substring-after.

Re: sharepoint "numbers" come in as "decimal"

swathip — Sat, 03 Jan 2009 08:01:19 GMT

Hi,

 I think there may be some setting in the sharepoint. One workaround is add a whole (integer) type field to the schema. And set the default value of that field is substring-after(dropdownfield,"."). So that you will get the value which is there in the SharePoint. When you compare the values use this value instead of drop down value.

Re: sharepoint "numbers" come in as "decimal"

Shiva — Sat, 03 Jan 2009 06:08:23 GMT

Hello,

We have round and floor function in InfoPath to get only integer part for those fields. You can add the rule to set the same value using round function then you will get only integer part for that field.

Re: sharepoint "numbers" come in as "decimal"

Neil McCaffery — Sat, 03 Jan 2009 04:32:57 GMT

Thanks for the welcome.

When I try to change the properties of the drop-down box which is pulling the numbers from SharePoint, I have several options under 'Data type:' - Text (string), Whole Number (integer) Decimal (double), and several others which I'm certain won't help.

It would seem that 'Whole Number' is the logical choice, but if I choose that, I still get a bunch of zeros after the decimal place. When I pick 'Decimal (double)', I have the same problem.

This seems like a simple fix, yet I can't figure it out. Frustrating! :)

Re: sharepoint "numbers" come in as "decimal"

Shiva — Sat, 03 Jan 2009 03:54:01 GMT

Hello Welcome to the Forums,

You have to do setting in InfoPath, we have formatting option for decimal field in InfoPath. We have to set decimal places value 0 then first we will get the values from database with decimal after reaching the InfoPath form it will get update with our formatting.

Re: sharepoint "numbers" come in as "decimal"

Neil McCaffery — Sat, 03 Jan 2009 03:26:50 GMT

I have the same issue. When I try to format the SharePoint numbers column as text, however, it reorders everything so that all the numbers beginning with '1' appear before all of the numbers beginning with '2', etc.... (for example, 1, 10, 100, 101, 102, 2, 20, 200, 201, 202, etc...)

Re: sharepoint "numbers" come in as "decimal"

Clay Fox — Wed, 27 Feb 2008 23:31:59 GMT

You can change the format of the fields in SharePoint to text.

Or you can use the num function or a substring to remove the extra decimals in InfoPath.

You can also format text fields as to how many decimal places to show, etc.