Questions tagged [column]

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

315 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
3answers
67k views

SharePoint Online, Change Column Widths On Custom List

I have created a Custom List via Importing Excel Spreadsheet. How do I adjust the column widths? I tried to follow the below link, (my view is AllItems.aspx) and it never shows me the menu outlined ...
5
votes
0answers
123 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 ...
4
votes
1answer
233 views

How do I validate Start and End Dates by column?

I have a site where employees input schedule items, each with a Start Date and End Date. I would like an error message to appear when users select an End Date before the Start Date. What formula can ...
4
votes
1answer
161 views

How to retrieve column names in other languages with CSOM?

I am trying to retrieve display name of a column in all languages available in my SharePoint installation (currently English and German). internal static void TestColumn(Microsoft.SharePoint.Client....
4
votes
0answers
105 views

Pasting into a metadata column

So I am moving our phone inventory over to SharePoint, and I have created numerous columns. Three of the columns use metadata, and so when I paste the items into the field I get the little red box ...
4
votes
1answer
328 views

How to send email to people from choice column with multiple selections

I would like to choice people from choice column with multiple selections and then send email to these people by using workflow SPD. Can I do it? I use SharePoint Foundation
3
votes
1answer
133 views

Document Library Required Columns

I'm trying to organize a document library by using different columns of information. I have two columns that are drop-down menus and one column that is a single line of text, all of which I set to be ...
3
votes
0answers
937 views

How can I create a traffic light status column

I want to create a traffic light status column in my task list. I have referenced the Path to SharePoint solution (and most of the others out there) but using a calculated column to display HTML and ...
3
votes
1answer
2k 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
1answer
652 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 ...
3
votes
1answer
132 views

Set value of “column b” with “column a”

I would venture to guess the answer to this is no but I am going to ask anyway... Is there any way, without an event handler, to set "column b" equal to "column a" without changing the default value ...
2
votes
0answers
108 views

Make column locked for editing by users in Sharepoint list

I currently have a SharePoint list that track open tickets for specific events. I have a flow that runs on this when an item is added. The flow creates an automatic due date (+5 days from when ...
2
votes
0answers
813 views

Using a workflow to automatically create document folders each time a new list entry is made

I'm new to sharepoint developer, so I'm hoping someone is able to guide me (provide simple instructions!) on whether it's possible to create a workflow where once I enter a new item in a list, a new ...
2
votes
1answer
264 views

First letter of internal name of list column converts to _x00XX_

I need to create two new columns in a standard list, one is called "AB12" and the other one "AB13". But when I create them, the internal names of them turns into "_x0041_B12" and "_x0041_B13". It ...
2
votes
1answer
159 views

Hiding specific column in search results

How do I hide specific column when user search for an item? For example, user searches for other people's names and the personal detail comes out but some detail should be hidden such as email. Is ...
2
votes
0answers
82 views

Unable to search managed properties for a document library

I have a document library with metadata that seems to have managed properties. I want to be able to search these managed properties. For example, I can do 'Filename:docx' and it shows only word docs....
2
votes
1answer
146 views

How was a user able to enforce a unique value for a choice column?

I have a document library with a choice column with possible values. In library settings, I have selected 'No' for both 'Enforce unique values:' and 'Allow 'Fill-in' choices:' A user was still able ...
2
votes
2answers
18 views

Unable to update values in a column after minimum requirement was changed

I'm using SharePoint 2010. I had a number column set to require a unique entry with a minimum value of 5000. After about 40 entries were made to the list the minimum value requirement was changed to ...
2
votes
0answers
35 views

Fields are not displyed in Disp/EditForm after content type upgrade

I had content type based on Page and pages library, which uses this contennt type. I needed to add new columns to this list. I created Elements.xml for fields: <?xml version="1.0" encoding="...
2
votes
0answers
88 views

Create a “Shared With” column for CURRENT permissioned users?

I know this must have been asked before, but I can't find it anywhere on StackExchange. So the OOTB "Shared With" column shows a historical view of all users (current or past) who have ever had ...
2
votes
0answers
48 views

Can I Modify the Output of SP2013 Field Values in Snippets or Page Layout?

I would like to know if there is a way to modify the output of page fields in SharePoint 2013 from within a snippet or within the page layout. I have a field of type Hyperlink or Picture. I want to ...
2
votes
2answers
2k views

SharePoint Excel export issues (ID export to lookup columns/Columns out of order)

Good day, I have 2 issues I am trying to workout on some SharePoint Lists. I was hoping I could get a little help as my developer skills are just now developing beyond OTB solutions. Issue 1: I ...
2
votes
0answers
655 views

Aligning column headers(titles) with row items

I have a list in which the items are long string of characters. Due to this the Column titles are not perfectly aligned with item rows. The Column headers are not changing there original position and ...
2
votes
0answers
61 views

Exception by setting a column unique

I have a huge list, about 200000 items. Till yesterday a custom column called Nr was not unique and contained many doubles. Today I cleaned it removing items with double entries, tryied to set the ...
2
votes
0answers
660 views

create a view that groups multi choice column values

I apologize in advance if I am breaking rules by asking a question similar to one already asked (SP2013 - Create a view that groups based on individual selections in a multi choice field). I can't ...
2
votes
0answers
80 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-...
2
votes
2answers
2k 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
1answer
109 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,...
2
votes
0answers
145 views

Difference between ArticleStartDate and Publish startdate columns

What is the difference between these columns: ArticleStartDate: <SharePointWebControls:DateTimeField id="ArticleStartDate" FieldName="ArticleStartDate" runat="server"></...
2
votes
1answer
2k views

How to Display Created By Field in InfoPath AND Sharepoint list with multiple values?

The article "How to Display Created By Field in InfoPath" seemed to work for a user on this forum. However, my needs are slightly different. I'm trying to create a list with the entry form showing ...
2
votes
0answers
183 views

Removing People from User Field, Allow only group

By default, there are two options available for User field. User User and Groups Is there any programmatic/declarative way on changing the properties so that the user field will only suggests and ...
2
votes
0answers
843 views

Changes to List Columns not Updating to Content Type

I have a document library with a Document Set content type in it. I created a bunch of custom columns in the list, and added them to the document set. I have changed the display name of some of the ...
2
votes
0answers
130 views

Setting Required Managed Metadata Column to hidden with default value?

In a Content Type, I have one managed metadata column (which is required) I want to set it with default value and set it to hidden using powershell. I want to clarify if it possible to hide a required ...
2
votes
1answer
1k views

Amending the Calendar form in Sharepoint 2013

I have a question about the Calendar app. I made the Location field compulsory from the Validation settings and a red warning message appears, when you try to save an event without its location. How ...
2
votes
0answers
581 views

Upload pdf file and automatically create list columns in a SharePoint list

My requirement is : When a user uploads a pdf file into a document library. There is a table in a pdf file which two columns. The SharePoint should understand and create list columns from the first ...
2
votes
0answers
556 views

Filter.aspx and GetDistinctValues

We found an issue, that filters on columns are stop working. Error message is: Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the ...
2
votes
2answers
1k views

Calculated Column needs left alignment

I have the same exact problem as related here Calculated Column left align header However, the solution suggested is inadequate. This would require me to manual add the web part to each list that I ...
2
votes
0answers
72 views

Is there a setting on SPField that would prevent it from being included in a CAML query?

I'm trying to build a CAML query for a managed metadata column. I'm following the guidelines provided here by Microsoft. Essentially they say to query for the term's Wssid. No problem, I can do ...
2
votes
0answers
743 views

Sharepoint Designer Set Task Field drop-down is showing empty

Using SPD 2010 I created an Approval process. I have added few custom field to my task list and now under "Before Task is assigned", the action "Set Task field" is not showing anything on the dropdown-...
2
votes
0answers
104 views

Why the Required property of field is changing to false?

I created site column with Required="true". Then I created site content type and added my column to it . Then I created list, selected "Allow management of content types?" to "Yes" and added my ...
2
votes
1answer
420 views

Value of User field changed after copying to another list cross Site Collections

The value of owner field of a document is beeing changed when I copy a document from a library to another library which belongs to another site collection than the original library. I copy the ...
2
votes
0answers
155 views

Best way to create a list with hidden columns with Data pulling from InfoPath form

So I have been working on this for a little bit here is what I am trying to accomplish: Using OOTB SharePoint 2010 Functionality I want to create an HR Referral System. Basically an InfoPath Form ...
2
votes
0answers
677 views

Updated = calculated field based on Modified shows 1899 last update

Working with SP 2010 and had to remove the time stamp from modified. Tried at system level - no joy. Used a calculated field (=TEXT(Modified,"mm/dd/yyyy")). This works well but occasionally shows the ...
2
votes
0answers
90 views

Using resx file in Calculated Field

Is it possible to use resource file (.resx) in tag? I made a calculated field and want to show the result in some different languages.
2
votes
1answer
637 views

How do I configure required columns on Wiki pages?

In a SharePoint 2010 Wiki page library, if I add metadata columns to the page library, something like "Category" and make it a required column. When I go and create a new Wiki Page in that library I'...
2
votes
1answer
130 views

Hide empty columns in PerformancePoint Scorecard dynamically

I have a scorecard with several empty columns which I want to hide dynamically. In the illustration above, I want to hide three empty columns, viz. MidYear Income, MidYear % and MidYear Status. ...
1
vote
0answers
31 views

Problems with exporting a list to Excel

I have modified my view and selected just the columns that i want to show. But when I export the content to excel I can see more columns. (In my nomal view I am not seeing them, just when I export it ...
1
vote
0answers
7 views

SharePoint default Column values are added to all documents of a library even if the specific contenttype does not includes the column

in our document libraries documents are assigned to different contenttypes. These contenttypes share some columns but not all. If we now define default values for a managed metadata column, all ...
1
vote
0answers
12 views

Add “Select All” (similar to “clear all filter”) option from the column header

I need to click "Select All" under any column (similar to "Clear all" button on Column Header menu ). It should select all values of column. Can it be done using Script Editor? What script would it ...
1
vote
2answers
48 views

SPFX rest call response seen in network tab but I cant read it on console

I got an issue I'm doing a rest call to get columns of a list, the call success because I can see the response in the network tab of the developer tools, here is a picture: for some reason when I try ...