What to do with trailing zeros from SharePoint

Hi everyone!

It’s been a long time since the last post, but sometimes one has to take care of things like the family. Ok, so now when that is done we could start having some fun again 🙂

I would like to start with a small and quick one.

Let’s say you have a drop down (field2) in your form that lists objects from a list in SharePoint. The list has got two columns, Title and Number.

The value for the drop down is set to Number and the Display name is set to Title.

Then you need to set another field (field3) in your form to the value of the chosen object,.

Set the Value of field3 to be same as field2

that’s when you will see that the number of the object will have lots of trailing zeros.

An easy way to get rid of these zeros is to insert a formula in front of the field2 value of sum.

this way the zeros will be gone.

Happy InfoPathing!

CU!

/SPNIAX

Advertisements


Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s