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

learn more… | top users | synonyms (1)

2
votes
1answer
352 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 ...
4
votes
3answers
729 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
165 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
125 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
271 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
3k 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
396 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
1k 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
86 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
28 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
135 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
1k 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
378 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
825 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
316 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 = sourceListItem.ParentList.ParentWeb....
0
votes
0answers
90 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
211 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
4k 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
1k 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
1k 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" ID="{71D763F4-CD20-420D-9E0E-...
6
votes
3answers
2k 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
560 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 ...
4
votes
1answer
530 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 = $w.Fields.GetFieldByInternalName("...
0
votes
1answer
54 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
52 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
47 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 problem?...
0
votes
1answer
2k 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
1k 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
3k 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 $...
2
votes
1answer
429 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
335 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
1k 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
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 ...
2
votes
1answer
600 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
52 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
289 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 ...
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
1answer
123 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
132 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
200 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
2k 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
444 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
206 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 ...
0
votes
0answers
238 views

MultiChoice Default value from resorces

I have a multichoice field that get the choices from resource file. And I read that a multi default value could be set using DefaultFormula and ;# seperation. So I defined my feild like this: <...
3
votes
1answer
280 views

Popup confirmation on 'status' column change

I'm looking to create a popup dialogue box when a column called 'Status' is set to 'Complete'. I want a popup box to ask "Confirm Complete?" with Yes or Cancel choices. Obviously Yes will update the ...
2
votes
1answer
141 views

How to store “stream” and “fields” paramters properly

I'm trying to use the GetItem method to use for copying documents, but I'm not having luck with the field or stream parameters. Below is an example of how I attempted to store each of them. When I ...
2
votes
2answers
428 views

Using field/column in html Page Layout but in CSS — Sharepoint 2013

I know you can use fields to define the content in a page, for instance, <div id="titleField"> <!--MS:<PageFieldTextField:TextField runat="server" ControlMode="Display" ...
1
vote
0answers
366 views

Gantt Chart Web Part: '[Column]' already belongs to this DataTable

I ran into an issue in vanilla Sharepoint 2010 where I had a gantt chart set up on a page and another user modified it, forcing me to recreate the chart. I went to connect the new chart to data ...
0
votes
1answer
535 views

SharePoint 2007: Get the average of a list column and display it on a page

I have a list with a column filled with values from 0 to 10. I need to take the average of this column and display it (maybe rounded to 1 decimal place) on another page as a kind of big, bold, ...
1
vote
0answers
63 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 ...