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

learn more… | top users | synonyms (1)

2
votes
0answers
51 views

How do you validate a column only if it's new item being added?

I recently added validation to a field which works great. =[Arrival Date]>=TODAY()-5 However, I ran into an issue when an employee is editing an older item to update the "Status" but it's not ...
2
votes
0answers
136 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
0answers
275 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 ...
2
votes
0answers
69 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 ...
1
vote
0answers
12 views

How to find files by typing a column property?

I'd like to know how to find documents inside all SharePoint libraries ("all folders") by typing a property name inside a custom column. Is it possible? For example, I create I column called "project ...
1
vote
0answers
6 views

Add an additional column to just a subfolder view (not for all library views)

I would like to add an extra column to one of the subfolder views I'm working with. Basically, I have a large document library with 10 or so top-level folders. A few layers down, I would like to be ...
1
vote
0answers
12 views

My Webpart does not see Field in a list

I am writing a webpart for SharePoint 2007 and have 1 problem with accessing list by a webpart. I have a list with lets say 10 fields and I am using this fields by a webpart without problem. But ...
1
vote
0answers
56 views

Column Visible in Standard View but not in Datasheet View or Edit Document Properties

I customized the standard Shared Documents library in the following ways: Renamed the "Title" column to "Description" Added new columns to the default view ("All Documents") The Description column ...
1
vote
0answers
101 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 ...
1
vote
0answers
75 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
0answers
112 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 = ...
1
vote
0answers
244 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 ...
1
vote
0answers
52 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 ...
1
vote
0answers
141 views

Content Type Columns not showing for Image Library

I have created the following 2 Site Column Definitions and a Content Type that incorporates both of the site columns A List Definition of type Picture Library that utilizes the Content type. however ...
1
vote
0answers
148 views

How to set custom list's column order declaratively

So basically what I want to achieve is to find a way to set column order on my custom lists declaratively (I'm using list definitions to create my custom Lists). One way of setting column order is ...
1
vote
0answers
23 views

how do i add a column that shows what people/groups have access to that file?

I have many documents that have different permissions, I would like to have my users be able to see who else can see/edit the documents. I don't want them to be able to change the permissions just be ...
1
vote
0answers
94 views

JavaScript function in URL field value

Is it possible to set the value for the URL field so that when clicked it runs a JavaScript function? I have created a field which stores links to files in SharePoint, but when clicked, the file is ...
1
vote
0answers
1k views

Column width in SharePoint

I would like to customize the width ( make them narrow, with 2 lines of headline ) of the columns in my SharePoint library. As far as I searched it can be done in SharePoint Designer with codes. Yet, ...
1
vote
0answers
184 views

Change column type from “Lookup (information already on this site)” to Person or Group

I have an issue after migration SharePoint 2007 to 2010. We had “Person or Group” which now somehow has transformed to “Lookup (information already on this site)”. This creates lots of troubles for ...
1
vote
0answers
12 views

Creating a report from a list that exceeds the number of viewable columns set by the admin

The SP admin has restricted views to 14 columns however the workflows used by the list will max at 24 columns. Is the admin throttle applicable to my report or is it only applicable to views?
1
vote
0answers
117 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 ...
1
vote
0answers
216 views

Week number formula for date and time column

What calculated field formula would show me the week number for a date and time like this: 5/27/2012 6:00 AM All the formulas I found are only for dates.
1
vote
0answers
354 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 ...
1
vote
0answers
469 views

How to create HTML column in Sharepoint?

Today one of are lab tech deleted the Java Script that would take the HTML in a list and display it. Dose anyone know what script it is? What im trying to display: <span ...
1
vote
0answers
306 views

Rules for Transforming List Column Names into XML Element Names

I am using the ListData.svc service to pull data from several lists. Many of the column names have punctuation and spaces, so their names are transformed as they're rendered as Atom in the ListData ...
1
vote
0answers
76 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.
1
vote
0answers
316 views

Change the default “Name” column in a Form Library

Is it possible to change the default "Name" column that is created in a form library. One method I saw is creating a content type that inherits from this column. Could someone provide instructions on ...
1
vote
0answers
83 views

Document List Indexed Column goes missing

We are currently trying to troubleshoot a problem in Sharepoint 2007 where a custom column loses the "indexed column" setting. We are trying to track this down, but has been mostly a reactive ...
0
votes
0answers
9 views

Filtering by column heading column causing error Cannot show the value of the filter

I have a list in sharepoint i have created three views which filters the items according to the year they were created. But when i am in the list and i want to filter with the column heading i get the ...
0
votes
0answers
20 views

New line break in SharePoint column description

I am provisioning a list declaratively in Visual Studio. In the schema for the list I want to include a field that has multiple lines of text for its description. Currently I have this in the ...
0
votes
0answers
8 views

Changing the order of columns in a custom content type messes things up?

I have a few custom content types that inherit from Event. I've added these to calendar lists throughout my site. I had to change the column order in the content types. I expected everything to be ...
0
votes
0answers
16 views

Dropdown menu item values causing issues, bug or limitation?

Today I start by asking if anyone would know reason behind my problem. What I'm trying to achieve is simple dropdown column that would be populated with the following values that are "long" but do not ...
0
votes
0answers
22 views

How to create column for attachment in SharePoint 2013 Document Library

I've created document Library where user can upload the file while click on Upload option (OOTB). Now in this Library I want to create one more column where user can put some comment and attach one ...
0
votes
0answers
21 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. ...
0
votes
0answers
16 views

Sharepoint numeric formula

I have a sharepoint list and I need , in a new column, a numeric count upwards. So whenever they fill in the survey, it gains +1 regardless how many days/hours are between the two surveys. So, first ...
0
votes
0answers
19 views

SP2013 Column Validation Length without spaces

I have a Column Title, and need to get its length but not counting any spaces. This is a test should give me the length of 11 With LEN I can get the length of a string, but with the spaces. After ...
0
votes
0answers
60 views

Hide 'View Entries' if the field is blank - Multiple lines of Text Append Changes

I have a 'Multiple lines of text' field on a custom list that has 'Append Changes' enabled. My client would like to hide the 'View Entries' link (in the List View) if there is nothing in the field. It ...
0
votes
0answers
13 views

number column with no default value returns zero

I have a custom content type with a numeric column in it. The column is set to not require a value, and the default value is blank. Problem is, the column is displaying a "0" in views for instances ...
0
votes
0answers
53 views

Sharepoint 2013 - Row with total of the column values

In sharepoint 2013 list, how can i have a total row at the end of the list, showing the sum of the columns. I am not using the "totals" in list settings since it shows the total on the top of the ...
0
votes
0answers
29 views

How to link from one item to another?

I want to have a field in Content Type A that can link an item to an item in the same list but a different content type (Content Type B). So for example, A-1 and A-2 link to B-1, A-3 links to B-2, ...
0
votes
0answers
10 views

Update field definition in all farm

I have a question is there a way to update field definition in all the farm? Basically I've migrated from 2007 and I have a field which has to be changed. So that all the lists etc etc can have a new ...
0
votes
0answers
56 views

Filtered Lookup Column from other Lookup Column

Why is this so difficult! SharePoint Online Office 365 List 1 : Group - Title, Desc List 2 : Category - Title, Group-Title(Lookup) List 3 : Document - Title, Category-Title(Lookup), ...
0
votes
0answers
26 views

SharePoint 2013 Workflows - Cannot update field that begins with underscore?

I like to use underscores at the beginning of my column names if I'm going to set them to hidden. However, I've just discovered that SharePoint 2013 workflows throw HTTP 400 errors when I try to do ...
0
votes
0answers
62 views

Task List Re-Adding Completed Checkbox to View

We had a user remove the "Completed" column from the All Items (default) view on a task list. When we try to add the "Completed" column back to the the view, it comes back as a (Yes/No) column ...
0
votes
0answers
55 views

Title field is reset when I create a template (list, site, etc.)

In a rush, I changed the "Title" field within my custom list on the "item" content type. I had done this previously and clicking "title" on the content type had let me edit it at the list level. But ...
0
votes
0answers
23 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
0answers
80 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
0answers
27 views

Column choices based on previous column choice

I would like to create a new custom list where firstly I ask the person about the category and based on the category that he chooses I have a new column where he can select the specified item. I am ...
0
votes
0answers
49 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
21 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.