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

learn more… | top users | synonyms (1)

0
votes
1answer
235 views

Skipping blank cells when using concatenate in a list's calculated column

I am using Concatenate in a calculated column to combine information from two columns in a list like this =CONCATENATE(A2, ", ",B2," feet"). Can you help me with a formula that would leave the field ...
0
votes
1answer
56 views

How to create a column that's filterable from a Content Query Web Part

I have an App of type 'Document Library', on which I added a column of type 'Managed Metadata'. I am using the Content Query Web Part to display documents matching a certain metadata tag. ...
1
vote
1answer
42 views

Can a “Person or Group” column have a repeat user in one entry?

I am trying to fix a SharePoint 2010 workflow that a co-worker created and I came across this odd case. The client wants an approver workflow where the same person appears twice in the approval list. ...
0
votes
3answers
1k views

Missing fields in the NewItem, EditItem, ViewItem forms

I am using sharepoint 2010. I have a document library. This document library has no content types. It has directly 5 columns. When I go to this document library I see the allItems view and shows all ...
0
votes
0answers
31 views

Sharepoint List Non Required fields

When using datasheet view during data entry using Sharepoint List, users informed me that the list is requiring entry on NON-REQUIRED fields. This issue happens to different fields not a specific ...
0
votes
1answer
291 views

Changing a Column Choice value and updating the column value for any previously saved items

I have a list with a choice column which has muliple choices, so that the user can pick from a selection. Would like it so that the choice list is updatable (i.e can change the names) at a later ...
0
votes
2answers
53 views

How do I get a lookup column to filter in 2013?

I have data in page view that places the information for "project" in a lookup column. When I try to filter this column I get the error "this column cannot be filtered." How to I get this column to ...
1
vote
1answer
214 views

How do you display information in multiple columns programmatically in a web part?

I am developing a web part (not a visual web part) that displays the site owners of a SharePoint site and their email addresses. Right now I am displaying the information in a listbox. It displays the ...
3
votes
3answers
423 views

Soap + Rest: Trying to understand differences for selecting fields between the two

I'm working on a Java-Application that integrates with SharePoint. The different SharePoint services are currently requested via the SOAP API. I am now working on an abstraction layer to also ...
0
votes
0answers
126 views

SharePoint Error “Error converting data type varchar to numeric.” on “Single line of text” column

I have a column defined in SharePoint as "Single line of text" when I deploy my webpart, and try to enter text in the field I get the following error from my log file: "Error converting data type ...
0
votes
2answers
74 views

Checkbox Column Allow one value

How to make a checkbox column not to allow multiple values Only check one option! Would appreciate any help
0
votes
2answers
167 views

Using If - Then Statements in Sharepoint

I'm not sure there's a way to do this or not. I'm pretty sure there is but I can't seem to figure out how to write the statement. What we need to do is to make Column B required if you choose ...
0
votes
1answer
2k views

Column '' does not exist error on existing and newly created lists. SharePoint 2013

Any time a new item is added on a custom list, I get the error "Column '' does not exist. It may have been deleted by another user". This is on a SharePoint 2013 farm. The problem originally started ...
0
votes
1answer
131 views

On click of save button, 1 column to take the value of another column in a list

I have a list with columns "due date" and "revised date" in SharePoint. I want to enter the due date column only when I am entering items for the first time. Onclick of save button I want the ...
2
votes
1answer
745 views

Display more fields in Discussion Board SP 2013

Can anyone tell me which function or part of the code I have to override from SP.UI.discussion.js to display extra fields in subject view of discussion board? Other than the fields it has OOTB.
0
votes
0answers
60 views

Filter Document Libraries based on a column name

Get-SPWeb http://sharepoint/sites/training | Select -ExpandProperty Lists | Where { $_.GetType().Name -eq "SPDocumentLibrary" } | Select Title I have this code which outputs all of the document ...
0
votes
0answers
23 views

Changing Field Type of a column

Is it possible to change Field Type of a column from TaxonomyField to Single Line of Text? It is a SharePoint online solution.
1
vote
0answers
110 views

column validation across survey questions

I want to validate responses to a question in a survey using information from a previous question and I just can't get the survey to take the validation formula. Basically: Q1 = How many hours do ...
1
vote
2answers
518 views

Calculated column to retrieve total number of ID

I have a SharePoint list which all has a unique ID to identify the items, so I want to create a calculated column that counts how many ID are there, like a count! Any help is appreciated
0
votes
4answers
173 views

SharePoint List Column deleted by user I need to know by whom

In Production one user has deleted the one column I need to know who has deleted the column. Please Help to find the way how we can track.
0
votes
1answer
398 views

Cannot edit column type and set it as URL

I'm using SharePoint 2013. I have a list with custom columns. One column is text type, and I want to set it as URL type. In SharePoint Designer, I can change the type, but I can't choose "URL" type. ...
0
votes
2answers
213 views

Document Library add file with custom column (SharePoint 2013)

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(lookup column). SPFile file = ...
0
votes
0answers
71 views

Save properties in a custom field

I have a cross site custom field. with user control to save properties like WebId ListId and FieldID. class CustomLookup : SPFieldUrl{ public Guid WebSourceId { get { ...
0
votes
1answer
141 views

Add new button to a column with “single line of text data type” in SharePoint

I am trying to create a "Add new" button to a column called "other Passengers" which has a "Single line of text data type". Such that I can add up "0 to n" numbers of passengers not in our LDAP i.e ...
1
vote
3answers
2k views

Character limit on Title column

I would like to know if there is a way to increase the character limit of 255 chars on the Title column of a list. If not, is there any way to bypass the Title (is a required field by default) and ...
0
votes
1answer
539 views

How to configure Currency field?

How to set currency symbol for a field (in list definition)? <Field ID="{1706A5C3-AC44-4685-A075-6019FAF9D940}" Name="Budget" DisplayName="Volumen (in €)" Type="Currency" /> SharePoint is in ...
1
vote
1answer
562 views

The element cannot contain child element because the parent element's content model is text only Error

I want to provision the field using feature. I have a field which is of type Calculated and the xml for the column is like below: <Field Type="Calculated" ...
4
votes
3answers
428 views

Add a user profile property as a library column

I have a few properties stored against user profiles (both standard and custom properties) that I would like to show, based on the user that created an item, in library views. For example, if the ...
1
vote
3answers
336 views

Limiting permissions to list-items and library files without using folders

I have some files in a flat library, i.e., no subfolders, that need to have access restricted to a couple usergroups. I understand that one way to do this is by placing items in a subfolder in the ...
1
vote
0answers
220 views

Field's TitleResource.SetValueForUICulture() does not work for the web's default language

I have a site column in my site collection whose title I change / translate with following PowerShell statement: $w = Get-SPWeb "URL to the site collection" $f = ...
0
votes
1answer
49 views

Cascading Column Selections

I am trying to find a way to make it so that when a User selects from a drop down option of "Category", based on their response, specific options will appear in the drop down for the next column ...
0
votes
0answers
38 views

First Modified Date

I need to capture the date that each row in a list is first modified. Not the date that the row is created, but the the date that the row is first modified after creation (effectively the date ...
1
vote
1answer
37 views

Existing values of some columns are not displayed in QuickEdit view?

If I use QuickEdit in a document library, some of the custom columns seem to be empty. In fact, they already contain values. Is this a known bug? Does anybody have an idea, what could be the ...
0
votes
1answer
822 views

SharePoint Column Formula Validation

I need to check if a column (type Number) is an Integer (no decimal). I added this formula to the list validation: =mod([MyField],1)=0 But I get this error: The formula contains a syntax error ...
0
votes
1answer
612 views

SharePoint Powershell Number and User columns

I need to create two list fields by powershell. One that accept only Integer (type Number with no decimal) and the other User (multiple selection). I can create Number field and Single User field ...
0
votes
2answers
2k views

Create Lookup Field Powershell

I am using SharePoint 2013, I need to create a lookup field through PowerShell. I tried this code but is not working: $SiteUrl = "http://mySite" $WebObj = Get-SPWeb -identity $SiteUrl ...
1
vote
1answer
243 views

creating custom field type to upload video files and store it in asset library

I have a requirement below. my custom page layout should have a column which should accept video files and on saving the page, it should save the video to the asset library. if the user uploads the ...
3
votes
1answer
184 views

Where does SPFolder store it's “Created By” information?

Here's an odd one: I have a content type derived from SPFolder, that I am creating through code. As part of the creation process, I am trying to set the "Created By" information to be the user who ...
0
votes
2answers
834 views

Sharepoint tasks - ASSIGNED TO value is empty

I created custom view in sharepoint 2013 for tasks. So users can see only tasks which are created by them or assigned by them. They all have contribute rights, and I remove abillity to create custom ...
1
vote
2answers
977 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 ...
1
vote
1answer
286 views

SharePoint 2013 - Reverse Lookup

I am trying to achieve the following in SharePoint 2013. I have two (2) lists a server list and an application list. Each list contains a lookup column which a user can select which applications are ...
0
votes
1answer
47 views

I want to change a column type but don't want to lose my data

I have a column using the "Currency" format. Since it only allows one type of currency I need to change the column type to single line of text. I will be using radio buttons to select the different ...
2
votes
0answers
199 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 ...
0
votes
1answer
2k 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
1answer
80 views

sp2013: set datetime column + 3 year in some condition, how?

I have a sharepoint 2013 site. I have a custom documentlibrary with 4 custom contenttypes. When I upload a document I can select a contenttype and see 1 datetime column. I would like to set the ...
0
votes
2answers
70 views

Q: Can I update values of an entire column from a workflow?

I'm using VBA to gather info based on their status. What I'd like to do is reset their status after the VBA operation is done. From my understanding, there is no way to update via Excel VBA. My only ...
1
vote
1answer
153 views

Column Validation Formula works in Excel but not in SharePoint

It seems like the tip was to create your formula in Excel and then just copy it to sharepoint. So I did and it doesn't work so I was just wondering if someone could tell me why. I've trying to ...
2
votes
1answer
1k views

SharePoint 2013 sp.js Getting the column names of custom list

*Edit* I have figured out how come the data returned for the columns was showing the wrong labels. The issue occurs when the list columns are created using the quick edit mode, as it allows you to ...
2
votes
2answers
182 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 ...
0
votes
1answer
106 views

How to hide specific column header in a list WebPart?

I created a webpart with URL column header, but i want to hide it for users...i know i can hide it using CSS but it hides all the colum headers in other webparts, Any solution to hide only the URL ...