columns (fields) created using out-of-the-box column types

learn more… | top users | synonyms (1)

1
vote
1answer
49 views

Search center show custom column name

I created a document library with a few columns. One of them is a custom column named 'document title'. The search center seems to show the results as: document name, description and link. How to ...
2
votes
1answer
152 views

Workflow Setting People/Group Field Skipping Values

I have a workflow that sets the value of a person/group field in a document library. The field is set to multiple users/groups. The problem is that the field will skip every other user set by the ...
2
votes
2answers
335 views

Create unique number with ListItem [ID] and [Today] age in Calculated Column Formula

Without a Workflow, How is it possible to make it works this Formulas: =TEXT( [Created] ,"YYYYMMDD") &"-" & REPT("0",4-LEN([ID])) & [ID] =Today() - [Created]
1
vote
1answer
63 views

Renamed title (display name) column randomly reverts back to title - SP2010

Something weird has happened this week on our SharePoint server. In various sites and sub-sites renamed "title" columns have randomly reverted back to the display name "Title". I realize that when you ...
1
vote
2answers
129 views

How to set only positive number in sharepoint 2013 column

The column Title has default setting as single line text. I would like to set validation as only positive numbers allowed, no decimal. I've tried with =ISNUMBER(PurchaseQty+0) but I still can key in ...
3
votes
2answers
154 views

Create auto generate sequence number column

How do I change the default "Title" column in SharePoint 2013 into a column which have sequence number generate automatically? Example as below: PO-15-2001 PO-15-2002 PO-15-2003
0
votes
1answer
45 views

Column validation based on another column

I have a list where users can fill a column named "External effort (m/d)" (type of column is number). After that column, I have "External resource cost" column, which type is currency, and where users ...
0
votes
1answer
97 views

Efficient way to get all the field (column) values in an array from SharePoint List

I have to get all the field (column) values in an array from a SharePoint list. Right now I am looping through all the items in the list and creating an array. But it is very inefficient if I have ...
1
vote
0answers
52 views

List Content types not getting updating while adding a site column to already deployed site content type using elements.xml

I have a site content type deployed through element.xml and is used inside lists. I added one site column and referenced that in content type. So my element.xml looks like below <?xml version="1....
1
vote
1answer
158 views

Add column to sharepoint list instance in Visual Studio

I would like to add a column to a sharepoint list which is created in visual studio. am not using list definition, only list instance. I could open the list xml and add new items, but how can I add ...
0
votes
1answer
294 views

How to Migrate from List Column to Site Column on existing Document Library

I work for a company that creates third party software that interfaces with SharePoint. The way we setup SharePoint now to work with our software is to use content types and site columns. However ...
0
votes
2answers
76 views

Text Column not sorting correctly alpabetically

I've created a list with two columns. It contains Country Name (first column) and their 2 character abbreviation (second column). Example: Italy - IT Sweden - SE United Kingdom - UK I've ...
0
votes
1answer
81 views

InfoPath 2007 into SharePoint 2007 Form Library columns not updating

I have an InfoPath 2007 form that I have created as a content type and attached to a form library. The content type has some specific fields that should be populated when I have completed the form and ...
5
votes
1answer
296 views

Multi line text field with unlimited length in document libraries allowed

What I am doing: Migrating Documents to SharePoint Online using PowerShell Script. Once document is uploaded I am simultaneously setting property values. Case: In a Document Library, I have a field ...
1
vote
1answer
183 views

How to make a SharePoint:FormField required in custom NewForm?

I'm looking for a simple way to make a SharePoint:FormField required. I want to do it using C# or SharePoint options but not using JQuery or Javascript because I already know how to do it with JS an ...
0
votes
1answer
409 views

Compare two int columns in a Sharepoint list

I´m doing a course catalog app for SharePoint. And I have a list called Courses. In that list I have two columns called: Seats and FreeSeats. When you make a new course the boss decide how many can ...
3
votes
4answers
2k views

How to create web-related lookup field to 'pages' list?

I have SharePoint site collection 'http://microsoft.com/' with few child webs ex: http://microsoft.com/news/ I want to create lookup field to 'Pages' list. On each child web lookup field should ...
3
votes
2answers
139 views

How to seen all JSOM internal fieldnames not DisplayName of Column of the list?

I know to get the Internal Fieldname from URL. But that takes long time and status bar is not always full with the url, so you have to open ze field and see in the top url what the internalfield name ...
0
votes
1answer
401 views

New line break in SharePoint column description

I am provisioning a list declaratively in Visual Studio. In the schema for the list I want to include a field that has multiple lines of text for its description. Currently I have this in the schema....
3
votes
1answer
34 views

Field name changes when I add a number

I use the shortest words possible when creating fields in a custom list. I go back and rename it sometimes, but the URL retains the shorter name. I have created a list, and have fields IS1 thru IS10....
1
vote
2answers
117 views

Filter Lookup from another lookup

I have a list of projects. Inside the project list you can select a Client. I have a list of Clients. I have another list, a list of Contacts, they have a lookup column called Client to specify from ...
0
votes
0answers
26 views

When Uploading numbers with comma, sharepoint removes the comma

We have an Office 365 environment - with SharePoint Online. Language is set to Danish, and everything looks okay. if i upload a document and write meta-data to the documents fields like: Number1: ...
0
votes
1answer
2k views

How do I add a Publishing HTML column to pages?

On our site I need to have an extra column on pages where users can enter teaser content. The teaser content is displayed on our homepage. I've created the teaser column with the 'Multiple lines of ...
1
vote
1answer
619 views

Rest API - Get list items by column value

Assuming there is a list of Students with their zip-codes in one of the columns, what is the query string needed to get only students with a certain zip-code? So far here is what I've got: site.com/...
0
votes
2answers
113 views

Sharepoint 2013 Custom List Calculate difference between Today and Column Value

I'm attempting to use update a Column [Days Since Last Contact] by calculating the different between =TODAY() and a Column [Date of Last Contact]. I've been trying to use [Day Since Last Contact] as ...
0
votes
0answers
117 views

Sharepoint 2013 to Outlook 2013 field mapping?

I have created a contact list using the app in SharePoint 2013 and all is well - but when I link it to Outlook 2013 some of the data and fields I need are missing along with some of the field titles ...
0
votes
2answers
93 views

Different Users ID on each sites

I actually have a site we will call "Team" and one we'll call "Direction" And a list "Projects" in each of those sites. I wrote scripts to make save of each sites, looking if there are new entries in ...
0
votes
0answers
27 views

Programmatically add new field to each project site that has an XYZ list

I'm new to using Visual Studio to create lists for SharePoint. Can anyone guide me to add new fields programmatically to all lists with a given title?
0
votes
0answers
47 views

Change Choice {Allow Multiple Selections} Column Width

We have a choice column with the following options: L100 L200 BAAA CZZZ SRRR What the end user is asking is if someone select 3 or more options, can we present the data in view mode such as there is ...
1
vote
1answer
59 views

List column auto update with specific format

I need to have a Project ID column in a project named list. The format would be PROJ0001 PROJ0010 PROJ0099 PROJ0100 and so on. These I'd will be auto populated while creating any new item in ...
1
vote
0answers
69 views

Is it possible to add existing site column to list using REST?

Is it possible to add an existing site column to a SharePoint list with REST? The MSDN documentation shows that a field can be added using /fields/addField but all the examples I have seen just create ...
0
votes
1answer
47 views

Column Validation help

I am struggling to get my column validation to be accepted. This is the logic I am trying to replicate: IF "Status" = "Successful" THEN "Date Completed" must be populated AND "Date Completed" IS ...
0
votes
0answers
21 views

Can the same Column have two column default values?

I'm setting up a Search experience using Column Default Values. These CDVs are filters on the Search Results page. Can I give a folder two different column default values on the same column, and have ...
0
votes
0answers
78 views

Value does not fall within the expected range when try to get field values

I try to send the selected documents in my library to the RMA. I got the following exception Value does not fall within the expected range What is my issue? Do I need to get the field by ...
0
votes
1answer
38 views

Unable to send emails to address stored as a String

I am having trouble with a helpdesk we are using. It had been set for internal staff to use and so when they raised a ticket, it remembered who they were and could then send email updates out nice ...
0
votes
0answers
42 views

Color code Columns?

we have imported a spreadsheet into a new list on a SharePoint 2013 site and as a result have a lot of data with many columns. What we want to do is colour code it as per the original spreadsheet - ...
0
votes
0answers
33 views

Sharepoint 2013 filter (required) column values depending on previous column selection

Perhaps you can help me with an issue I have setting up an new SharePoint library: We have (among others) 2 required columns for the users before they are allowed to upload their document. The first ...
1
vote
1answer
227 views

Cannot edit column type or delete it in Sharepoint 2013

I have imported an excel file into SharePoint 2013. One of the columns I imported was PolicyType. It is currently set as a text field but I need to change it to a choice from a menu field. I don't ...
1
vote
0answers
18 views

Managed Metadata Column Visibility

Having an issue where tags in managed metadata columns will not display in DispForm.aspx for a non-admin user, but display normally for admins. I have tried adding "NT AUTHORITY\authenticated users" ...
-2
votes
1answer
42 views

Change SharePoint 2010 Library field values at the time of Approval

How to changes SharePoint 2010 library form values at the time of Approval, I have one UnderReview library, While Uploading the document there is one status column and the column values in Draft, Once ...
0
votes
0answers
44 views

Sharepoint Workflow - Column Value

I have the following conditions: WorkflowCheck = Shared document Item Column to hold strings of In Progress,Rejected,Complete Status = Shared Document :A calculated column to show images based on ...
0
votes
1answer
254 views

Restore a deleted field (site column)

I had to add a Content Type to a list. The Content Type contained Site Column Priority which was a drop down, and the list already had. After I added the content type I removed the old Priority column ...
0
votes
1answer
200 views

New column content not appearing in search results (with use of managed property filter)

I followed the instructions here to add a new property in advanced search, and to be able to search based on the custom column I made (which are metadata tags). It worked well last week; but this ...
1
vote
2answers
91 views

Site column validation - not allow to use slash / backslash / questionmark / \?

Got a script that creates new site collection based on a template (clone site collection). Problem is that some users type in slash / backslash in the title site column, that makes the url wrong. ...
1
vote
2answers
1k views

Powershell - Change display format in SharePoint Site column from friendly to standard

How can I change the display format from friendly to standard? I want to change this on all lists in the solution $sites = Get-SPSite "http://company.com/sites/testdelete/" $created = "Created" ...
0
votes
1answer
155 views

How to query current user created items?

I have many lists in SharePoint site. I want to retreive all the items from the list and display on a site. The current user should only see his/her created items not other users items from the lists. ...
3
votes
4answers
874 views

Want to link document to TITLE NOT to name

Ok, when I do as suggested by @users1100 This is the result I get, the column names goes away totally, and Title is still not acting as an url/linked to document.
0
votes
1answer
311 views

Custom List Calendar View to display Multiple Columns' Data

I am trying to display a custom list in a calendar view. I want to display more then just the title or one of my columns data. I want to show data from a few of the columns, one being a Name. ...
0
votes
0answers
173 views

The formula cannot refer to another column

I was attempting to add a content type that was syndicated from the Content Type Hub, to a list on a subscriber site, when something went wrong. The formula cannot refer to another column. ...
0
votes
0answers
19 views

Possible to have validation on selecting all checkboxes for a choice column in SP Online?

I have a column titled "Team Eligibility Requirements" which is a choice (checkbox) column. I want to see if it is possible to write validation to explain to a user they need to be able to ...