The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
39 views

Best practice for autonumber

What is in SharePoint 2013 on premise the best way to create an autonumber system? It's for an expense note system and it should be nice to have something like 2014/0001. I know there are different ...
2
votes
1answer
21 views

How do I get a placeholder of 0?

I want my InfoPath form to have numbers formatted like "010" instead of "10" to then sync with SharePoint. How can I get my form to show the zero placeholder instead of two digits?
1
vote
1answer
44 views

Currency Data in a Workflow variable rounds to nearest dollar, want to have cents, too

I have one list called Capital Projects with Orig Budget, Amount Spent, Amount Left. I have another list with invoices with Invoice number and TotalAmount. I wrote a workflow that runs every time an ...
1
vote
2answers
337 views

Display “NaN” instead percentage value

I'm using SharePoint 2007 and developing a custom view using SharePoint Designer 2007. I've a column of a table that should display numbers as percentage. Minimun value is 0, maximum 100. In SP ...
0
votes
0answers
48 views

Calculated Column returns excessive amount of zeros

In a Purchase Order form I'm putting together, I have line amount and total amount as calculated columns. However, when displayed in the InfoPath form, they show with a ridiculous amount of zeros at ...
0
votes
1answer
25 views

Making a number of items in one list by the entered value in another list

I have two lists. In one list I have a variable that is a number. When I put certain number (for an example 5) in that variable, I want to make that many (in this case 5) items in another list. The ...
0
votes
1answer
169 views

Programmatically adding a sequence number to the 'Title' column during item creation in SP List

As per the title above, I have a list that stores IT support requests. I need a sequence number that matches with the item ID and I want to add this sequence number to the Title of the request. I ...
1
vote
1answer
201 views

User input issue with Locale change of Site SP 2010

My site is running under SharePoint 2010. Everything is Ok except when I change the locale of my site from Regional settings from US (English) to Malay. The my web part pages where user has number ...
1
vote
2answers
3k views

Creating an Autonumber Column

Is there a way to create an autonumber column in the lists and libraries? For example I want to have a list and when a user wants to add a new value, it automatically generates a new autonumber.
3
votes
1answer
2k views

Converting number field to text field results in data loss

I have the following scenario: A standard generic list with a number column. There is a large number of list items in the list - 200000. All list items have an integer number value (no floating ...
0
votes
1answer
1k views

XSLT for summing Number column where there are cells with no value

This is akin to this question but I couldn't get the suggested sumAll function to work. I also have several different columns to sum and it just seems silly to have a separate template for each ...
2
votes
2answers
142 views

Should I use SharePoint Number column types to store monetary values?

In SharePoint I can create a list column of type 'Number'. I need to store monetary amounts and would like to be able to use this column type rather than having to create a new one. Are values of ...