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

learn more… | top users | synonyms (1)

0
votes
1answer
583 views

How can I make sure that if linebreaks is inserted inside a multiline textbox it gets displayed like it

I have a field that looks like this in my schema: <Field ID="{7662cd2c-f069-4dba-9e35-082cf976e170}" Type="Note" RestrictedMode="TRUE" NumLines="15" Name="Body" DisplayName="$Resources:Project....
0
votes
0answers
6 views

What is the Protocol Name field on the List app, and how do I automate filling it in?

I am attempting to create a Custom List app in SharePoint but am being stymied by the Protocol Name column that is added by the list by default. I don't have a good understanding of what that column ...
1
vote
2answers
52 views

Column validation- User must enter A or B as first character

I am trying to create a validation formula which will verify that the user entered A or B as the first character in the column. Can't seem to get the formula right. Can anyone help? [EDIT] One ...
2
votes
3answers
346 views

Set default value of Article Start Date to [Today] with CSOM

I'm struggeling with setting the default value of ArticleStartDate date-time column using PowerShell and CSOM. Bakground: I have a content type, used by a page layout, inheriting from Article Page ...
3
votes
3answers
4k views

Hide header row for specific list view

Is it possible to hide the header row, displaying column headers, for a specific view on a SharePoint 2010 publishing page? We've used this CSS to hide the column headings, but this is all or nothing; ...
0
votes
2answers
34 views

Setting a field as a hyperlink in a list

I'm attempting to use a calculated column to set the field as a hyperlink. Currently, I'm using this code. ="<a href='"&%URL_Field_Name%&"'> "&[%field_name%]&"</a>" So, ...
8
votes
4answers
3k views

List Validation does not show Error when Conditions are not met

I am using List Validation feature for a list which is working fine i.e. doesn't save the item when condition not met. However, it is not showing the error message which helps to rectify the inputs in ...
1
vote
1answer
43 views

How can I create a [Me] filtered view using a Lookup column with names in it?

Any help will be hugely appreciated as really struggling with this. I am limited by company regulation saying I can't use code so any answer will need to be code free and not require the use of Design ...
0
votes
2answers
34 views

Column Versions

Is there any way of adding a column to show the previous version of an approval status? I want 2 columns: one to show the current version and the second column to show the previous version of the '...
0
votes
1answer
48 views

Lookup column restriction

For a school project we are setting up a SharePoint for a non profit organisation who handle clients. we have made a document library where we store documents sets for every client thats added. In a ...
0
votes
3answers
3k views

Document Library add file with custom column (SharePoint 2010)

I have a document library with a custom column. I want to add a file programatically, as well as a value for the custom column. I am posting the file via an ASP.NET application page. Here is what I ...
2
votes
0answers
27 views

How is the relative list item order calculated from tp_ItemOrder column?

I am using a custom action and the Reorder.aspx page to provide a sorting-functionality to my users. I followed the instructions that can be found here: https://niftit.com/blog/how-to-reorder-a-...
0
votes
0answers
24 views

Sharepoint Column Validation Error - Not going to second page

I added column validation to the drop-down choice questions on page 1 of my survey and it worked fine. The last question of my survey page 2 has branching logic and column validation. When I ...
0
votes
3answers
745 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
1answer
15 views

list columns, diplaying information provided via lookup from one column differently in another

There is a lookup column within my list that allows the results to be displayed in many different ways. Example: Smith, John W or John.Smith or Employee ID#. Is there a way to add another column to ...
1
vote
1answer
6k views

Sharepoint 2013: changing column order is not refleted in the list

I changed the column order on a list item. These changes are reflected in the "column ordering" view. However, the changes are NOT reflected in the actual list layout. I tried emptying the browser ...
0
votes
0answers
27 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
1answer
2k views

How do I change the order of display of additional fields associated to an External column?

In SharePoint 2010 I have an External Data Column that I have linked to an External Content Type with 5 fields named A,B,C,D and E. I have selected all fields to be shown when the external data column ...
1
vote
0answers
179 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 ...
2
votes
2answers
53 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
37 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 ...
1
vote
2answers
2k views

sp2013: Column with link to the displayform like on the title column?

I'm using SharePoint 2013. I have a custom list and a custom Content Type. I have edited the view and deactivated the title column because I don't use it. I now miss a column with a link to the ...
0
votes
1answer
52 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
43 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 Time]<=DATE(YEAR(TODAY()),MONTH(TODAY())+2,...
0
votes
1answer
88 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 ...
0
votes
2answers
228 views

renaming the [Content Type] column

My Custom List is based on Content Types. While modifying the view I get the option to display a column name called [Content Type], but I don't know how to rename it to something meaningful. That ...
3
votes
0answers
42 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
54 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?
10
votes
1answer
540 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 :...
3
votes
1answer
228 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 won'...
2
votes
1answer
26 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
95 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
746 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
16 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 ...
3
votes
1answer
196 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 ...
0
votes
0answers
53 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 ...
23
votes
4answers
71k views

Change Title (linked to item with edit menu) to different column

How can I change the column in a SharePoint list that has the link to the item and the link to the item with edit menu eg: Title (linked to item) Title (linked to item with edit menu) I want to have ...
0
votes
0answers
19 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
45 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
166 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
1answer
1k views

LinkToItem not linking to document

I have tried linkToItem="TRUE" but it doesn't work on my SP2013 version but LinkToItem="TRUE" does. Only one issue, the LinkToItem doesn't open the file, it just opens the edit/item screen. How do I ...
1
vote
2answers
72 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
31 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
73 views

Image URL of SharePoint list

I created a MediaAlbum List added an existing column called "Page Image". $.ajax({ url: siteurl + "/_api/web/lists/getbytitle('MediaAlbum')/items?$filter=IsActive%20eq%201&$expand=...
1
vote
3answers
67 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 ...
2
votes
1answer
63 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" ...
3
votes
2answers
134 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. I'...
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
151 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
332 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]