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

learn more… | top users | synonyms (1)

0
votes
0answers
22 views

lookup with criteria

I have three lists in Sharepoint: Customer Product Lizens A Customer has a unique Name and a Adress. A Product has a unique Name belongs to a specific Customer(can also be unasigned). A Lizens ...
0
votes
1answer
21 views

2010 Branching Choice Columns

I have a dilemma with a list I have that I wish to export to excel and create pivot charts/graphs for... Currently my list has several fields that I wish to consolidate into one. I have: - Team ...
1
vote
1answer
15 views

Unique constraint on multiple columns

I would like to be able to set a unique constraint on two columns to avoid entries like in the 4th record below (1234,B1) ColumnA ColumnB 1234 B1 1212 A1 3211 B1 1234 ...
0
votes
2answers
3k views

Freeze Header Row

is it possible to freeze the header row in list? We add some code so the user can scroll trough the content. The code doesn't work for the header freeze. We work with Internet Explorer 10. Have ...
2
votes
1answer
39 views

Delete column of a list with content type which is not mine

Environment : Sharepoint Foundation 2010 I created a helpdesk list which contains a default content type. When I go to the list settings, I cannot : Delete any field already created at the same ...
0
votes
3answers
30 views

Add columns based on another columns value

I am trying to implement a Basic CRM in SharePoint. Although there are a lot of Add-Ins for SharePoint I want to do it by myself. So I made a sub-site and added some lists for the different modules ...
0
votes
2answers
32 views

Way to keep ID dynamic regarding the number of elements

I am simply asking if there is a way to keep dynamic a field ID auto incrementing in a list: I have 3 elements with ID 1, 2, 3 When Item with ID 2 is removed or moved, I want the element with ID 3 ...
0
votes
1answer
22 views

Force “Name” field in SP13 Library to be equal to '“Title”

As I understand, SP13 searches documents by document Title. When you upload some document to the library, you have to fill in "Name" and "Title" ( the same field twice). What I want to do is to ...
0
votes
1answer
4k 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 ...
2
votes
1answer
518 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
24 views

How do I know which Columns are safe to delete because they are used by a removed content type?

This list used to have content types (A & B). We have now deleted all list items that were content type B. I have turned off Management of content types. Columns for content type B still appear in ...
0
votes
1answer
40 views

Allow multiple selections on Person or Group field

In SharePoint 2013 on-premise I am trying to create a Person or Group field to use it in a content type. My problem with the field is that I cannot select more than 1 person. I have been googling a ...
2
votes
1answer
28 views

Calculated Columns - IF statement to find all numbers inbetween a selected area

Since my title is unclear let me explain. I'm currently trying to work out if I can use an IF statement to find numbers inbetween a selected amount. Example: =IF([Weeks Left]="1-12","coming ...
0
votes
0answers
12 views

Percentage calculated column issue

My code is =IF(OR(Agency="1",[Day Rate ex VAT]*(1-90%)), IF(OR(Agency="2",[Day Rate ex VAT]*(1-90%)), IF(Agency="3",[Day Rate ex VAT]*(1-90.5%)))) This code is basically trying to work out if ...
0
votes
4answers
34 views

How can i make SharePoint Calculated Columns to know who edit some columns data?

How can i make SharePoint Calculated Columns to know who has edited some columns data? I want to know who is editing specific columns, not modified by, and not using version history on each item. ...
0
votes
0answers
12 views

Display a Date in a Column by selecting one of a choice on the other column

I have added a task app for my project lists. There is one column called "Task Status" with three Drop-down choice: Project Assigned, Project in 90% completed and Project Completed. I wanted to ...
1
vote
1answer
41 views

What SharePoint Column is used for a Video?

Is there a built-in column that is used for a video asset?
1
vote
1answer
248 views

Validation formula on new items only

I'm using the following formula to prevent users from entering spaces on the article name field. =ISERROR(FIND(" ",ArticleName)) The problem is the users have already entered data in this field ...
0
votes
2answers
33 views

Adding text to a Sharepoint Traffic Light Calculated Column

I currently have a Calculated column that produces a colored circle depending on another column. =IF( ISERR(RIGHT(LEFT(Level,2),1)-1) ,"" ,"<DIV style='font-weight:bold; ...
0
votes
0answers
9 views

Fields from Infopath form not showing up in site content type columns

So I created a new site content type for a document library in SP 2010 I'm using to store form submissions. I was able to have the content type reference an existing form when creating new items, but ...
0
votes
0answers
18 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 ...
0
votes
0answers
13 views

Custom task column on reusable workflow

I had a workflow that was linked to a list. I noticed then that I could make a reusable workflow, which is more practical: I only need to link it to the list that I want, instead of making a new one! ...
1
vote
1answer
2k views

Making column required is only possible after it is added and edited (happens in content type only)

While creating columns in content type the option of Require that this column contains information is disabled so I cannot make the column required. But once I save the column and edit it I am able to ...
0
votes
1answer
587 views

Link list URL fields do not display when using FieldRenderingControl

I'm creating a custom New Form for a Link list. Depending on the view depends which columns are displayed. for(int i = 0; i < spView.ViewFields.Count; i++) { ...
1
vote
1answer
842 views

Date field validation in SharePoint 2007

I need to limit the Date field in a SharePoint 2007 list so the users can enter date from today and up to year after. How can i do it?
0
votes
0answers
13 views

Sharepoint list “Append Changes to Existing Text” + latest Entry

I have a SP list with a column latest updates. This column is set to "Append Changes to Existing Text" with versioning turned on. However, when we go through the list as a team. It's annoying to open ...
3
votes
1answer
33 views

Column validation only when creating new item Sharepoint 2010

So I have a date field that needs to be a future date when the item is created. The formula I have set up for that is: =[Date Required]>TODAY() This works well however I am running into an ...
1
vote
1answer
795 views

Field properties ShowInEditForm not saved

I have a listadded EventReceiver with the following code: public override void ListAdded(SPListEventProperties properties) { SPWeb web = properties.Web; bool safeUpdates = ...
4
votes
1answer
746 views

SharePoint Bug? Conflict Error when saving a Page with a “Required” DateTime field in the page layout

I've just recently encountered a weird error / bug in SharePoint. Here is the scenario: I have a custom column "Test Date" that is of DateTime field type. The field is configured as required. It is ...
0
votes
1answer
601 views

Update metadata column using Java REST

As I understand, you have to make a 3 steps to update the metadata on the file. I have uploaded a file to my document library using POST and after that made a GET and took out the metadata i need to ...
1
vote
1answer
45 views

How to change the font of column name

Is there a way for me to change the font size/ family for a particular column name for Default New Form web part. (jquery/ SPD) Like the following image (diff from default style) Thanks!
1
vote
2answers
6k views

make custom list item column unrequired (non-required)

I have a custom content type with many required columns. The UI does not allow me to change a column from required to non-required (at least, I can't find a way to do it). Is there a way to achieve ...
1
vote
0answers
32 views

Sharepoint 2010 Validation by two fields

I have a SharePoint list with these fields: Destination - User picks a person Created by - User who created the item Is there a way to prevent users from creating item for themselves using ...
0
votes
1answer
46 views

Adding custom column to Workflow Task content type makes workflow stop on assign task

I have been asking a few questions in here lately, as I'm beggining my journey as a Sharepoint Online 'developer' for my new internship. I have a new one for today: I have created a custom approval ...
1
vote
0answers
32 views

SharePoint 2013 - Add Library Column Showing Managed Metadata Level Values

I need to be able to classify all the documents in a library into a Major Category and a Minor Category where the Minor is specific, but not exclusive to the Major. It would appear that the best way ...
3
votes
3answers
613 views

Can I add a start workflow link to a column in a list view?

I would like to add a link directly to a start workflow page in a column so that users don't have to go through several clicks to start a workflow. The link needs to change based on the item ID for ...
1
vote
0answers
24 views

Change a field in SharePoint Online

I have identified a site column with incorrect properties. Specifically I need to change the RichText value from FALSE to TRUE. How can I do that? I have tried to locate Elements.xml and edit that ...
4
votes
1answer
428 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
16 views

Help with auto calculated field for dates from another column [closed]

I am trying to make a column with expire dates from a date entered in another column. For example I have a column with a date entered for training. I then want another column named expire date that ...
0
votes
3answers
36 views

Calculated Column Question

I currently have a list with the Column - "Level" This column is a choice column with the choices: "Novice" and "Beginner" I'm creating a calculated column called "Score" I want this column to ...
1
vote
2answers
871 views

ID column into the 'link to item' of a list

In a list, how would I make the ID column the column that links to the item's detail screen?
0
votes
0answers
16 views

Create Field which allows choice of values, but value does not change when source does

Using SharePoint 2010, is it possible to create a field which forces the user to select from a dropdown list (based on items in another list), but when the value in the related list changes or is ...
3
votes
1answer
281 views

Convert Field To FieldLookup using ClientContext

I need to get a FieldLookup from a list (already queried). First line in the below code errors out "Unable to cast Field to FieldLookup". Yes, the field I am trying to retrieve is a lookup field only. ...
0
votes
1answer
554 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" ...
0
votes
0answers
5 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
39 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
183 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 ...
2
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
29 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 ...