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

learn more… | top users | synonyms (1)

0
votes
0answers
15 views

columns are not showing when adding from “Add from existing list or site columns”

I want to add some columns to content type from a specific column group. I click on "Add from existing list or site columns" and choose one column group. But below in the available columns list, I am ...
1
vote
0answers
13 views

Getting hyperlink URL and description in custom XSLT with Content Query Web part

I'm having trouble getting the URL and description to show as separate items in SharePoint 2013. I'm trying to display the description as the text of the Link and the URL as the HREF value in the a ...
0
votes
0answers
25 views

Version System column and word information panel

In SP2010 library I have Version system column based which shows version of document. I want to add this column to content type of document, because I want this field to be shown in Word information ...
0
votes
1answer
22 views

Get schema name of specific field in list

How to get Schema name of specific field in a SharePoint list? I'm using SPservices to get list items from the list but one field is missing in the result. I want all field values of the list
2
votes
1answer
31 views

How to limit End Time to within +8 hours?

I am trying to limit the End Time of a Calendar Event to be within +8 hours of the creation time. I've used this formula =AND([End Time]>=TODAY(),[End ...
0
votes
1answer
17 views

Workflow: how to UNSET (or set to NULL) a date/time type value in a custom column?

Trying to build a workflow that clears a date column when the task "Completed" box is unchecked. Have tried several different approaches but have not gotten anything to work. The workflow completes ...
3
votes
0answers
25 views

Multiple validations in a single column in 2013

I have been working on something I feel should be very simple for far too long. I have a single line text column in a list and would like to employee multiple validations to the column. The ...
1
vote
0answers
18 views

Wrapping text in list

I need to wrap text in my row data. I have found how to do it for the column headers and that is not what I need. I need the data inside the list itself to wrap text. How to do it?
3
votes
1answer
46 views

Can I prevent duplicates to a SP2013 list with a validation formula?

I have a SharePoint 2013 list and want to use 2 columns as sort of a natural key on the list, so when a user enters a new entry, if these 2 columns combined match an entry already in the list, it ...
2
votes
1answer
19 views

SharePoint List CreateBy column storing date value

we discovered some very strange behavior in a list. within the last couple weeks, the Created By column for all items was replaced by a date: 35;#2014-12-23 23:17:51 I got this using powershell, ...
1
vote
2answers
39 views

SharePoint New/Edit Form Separator

I would like to have some headlines/separators between columns in the New/Edit form in a SharePoint List. Basically, I would like to have a separator in between the categories to which the columns ...
3
votes
1answer
190 views

Check if a Date field is greater than another Date field

I am working on an issue tracking list and I added two custom fields of type Date/Time which allows date only, as follow: Plan start date. Plan end date. How can I check that the start date is ...
1
vote
0answers
12 views

Using the One Column with Sidebar and wish to reduce the width of the toolbar

I am currently using the One Column with sidebar Text Layout and the sidebar contains 3 web parts within it and having reduced the width of the web parts, I wish to reduce the width of the sidebar in ...
0
votes
0answers
27 views

Creating a RYG Colour Coded Sharepoint 2010 column that is affected by dates

A current issue I'm having is creating a column that changes from green to yellow to red based on how much time has passed from when the document was added to the list. I already know how to create a ...
0
votes
2answers
114 views

Show/Hide columns based on dropdown selection

When adding a document I want to show or hide colums based on a dropdown selection. In this case, the value of "Document type" is leading. If a Travel Document (Column name "Travel Documents") is ...
0
votes
0answers
17 views

Lookup field getting value instead of text

I have departments list ,I want to use departments list in another list by using visual webpart it works fine but I am getting values instead of text in the list after saving the list item. in ...
1
vote
1answer
40 views

Hour calculation

I have list with two date fields. It is also containing time information. It is based on leave request so I need to calculate hour basis for half a day leave. If user enters 8/1/2016 08:00 AM as ...
2
votes
1answer
38 views

Powershell to export all the columns with their data values in a sharepoint 2010 list

I have to export all the columns in a particular sharepoint list along with the data contained in the columns. I am currently able to get all column names but not data. Need help with that. Below is ...
1
vote
2answers
53 views

Delete one column from large list

I have a column in a list of over 15,000 items. The column we want to delete was recently created, and we were going to populate it/backfill the values, but then decided to split it into 3 fields ...
0
votes
1answer
27 views

List Column visibility

I have a list where users can create a new item. There is a column named "status" that should not be visible to users when adding a new item. That column should be visible when editing an item and ...
1
vote
2answers
41 views

Image URL of SharePoint list

I created a MediaAlbum List added an existing column called "Page Image". $.ajax({ url: siteurl + ...
10
votes
1answer
133 views

set column order of fields using CSOM/REST javascript

I am creting list fields using CSOM ecma script. How do I set the column order of the fields to be displayed in the form programmatically? For eg: I have created the following fields programmatically ...
1
vote
3answers
51 views

Column validation failed

I have created column validation to enter only positive integers with 2 decimal. But I'm unable to key in integers with decimal. I'm not sure what went wrong. Please assist. Column validation ...
3
votes
2answers
127 views

Create custom view

I have a product library which contains choice menu column. The name of the column is New Product?. And the choices are TRUE and FALSE. I want to create a custom view which only shows Old Products. ...
2
votes
1answer
44 views

Phone number column validation

I want to add phone number column with below format: 1-121-343-6917, 434-5503 & 60-12-444 444 Used below method =TEXT(123456 ,CHOOSE( LEN(123456) ,"0" ...
1
vote
1answer
36 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
55 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 ...
1
vote
1answer
36 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
68 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
62 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
30 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
36 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
29 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 ...
0
votes
1answer
43 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 ...
5
votes
1answer
127 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 ...
0
votes
2answers
58 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 ...
1
vote
1answer
43 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
387 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
2answers
51 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 ...
3
votes
1answer
32 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 ...
0
votes
0answers
20 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: ...
1
vote
1answer
106 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: ...
0
votes
2answers
45 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
39 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
0answers
23 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?
2
votes
2answers
48 views

Required Field Color

How do you change the colour of either the field or the label of a required field when uploading/editing the properties of a document. The user says it is hard to see the little * ?
0
votes
0answers
30 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 ...
2
votes
1answer
90 views

Add Rich text column to the Blog Post comment (SharePoint 2013)

I am trying to customize the Blog post comments in SharePoint 2013 by adding a new custom column using RichText (called RTBody) and hiding the old one called Body in several pages, such as Post.aspx ...
1
vote
1answer
42 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
29 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 ...