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

learn more… | top users | synonyms (1)

0
votes
1answer
117 views

Strict Text Formats in SharePoint Online

In my SharePoint Online list I have column Serial# and I want Serial# in a specific format like 5CB34307L8, 2CE0031NWX For example if I type 512,bc1 it should be converted automatically into 512BC1 ...
0
votes
0answers
63 views

External Content type column causes an error in the list view

I have a siet column/field of External Data type called "ABVictName". The problem with this field is that whenever I insert it in the List View it throws an error. In the logs I found this message: ...
1
vote
0answers
64 views

Why aren't the addition field columns populating when I select a value from a lookup column?

I have an Equipment List that looks like this: Number Description Mill Area 1 pump warehouse 2 motor outside 3 shaft yard 4 bearing ...
0
votes
1answer
31 views

Updating form choice field based on another choice field

I have a document library with two lookup columns. Column A is "Region" with the following choices: North South East West Users can select more than one region when uploading a document. Field B ...
0
votes
0answers
22 views

Sharepoint List Definition with custom column

Im working on Sharepoint 2010 project. I created farm solution with some list definitions. Now i would like to use Autocomplete Lookup Field in one of list definition. But if I look on Schema.xml ...
2
votes
2answers
170 views

Can't get calculated column syntax right

This "ought" to be easy and yet as with so many things SharePoint, it isn't. I have a calculated column where I keep getting a syntax error. If the user sets a dropdown column value to x, then y ...
0
votes
0answers
20 views

How to populate Meta Data Columns from Active Directory clicked names

Is there a way to populate a column from choosing names from Active Directory? We want to build a few columns of names from AD to be used in a Custom WorkFlow so that the Custom WF can be built using ...
0
votes
2answers
59 views

How to Hide Fields and Columns

I am working with a SharePoint Online. I am very new to SharePoint and JS in general (so I am no expert - but willing to learn). I have created a List that contains the following fields: A, B, C. A ...
2
votes
1answer
328 views

Replace comma delimiter in a multi-select choice column

A SharePoint list has a multi-select choice field. When 2 or more values are selected for an item,it is displayed(in the view)as: Value1,Value2,Value3,Value4,Value5,Value6 Is there a way that I can ...
0
votes
2answers
36 views

Caculated Column Help

I am trying to use a calculated column to generate something like this using [Created]: 161000TAPR15 16=Day of the Week, 10=Hour, 00=Minutes, T=[TimeZone],First letter of the Time Zone, APR=Month, 15=...
0
votes
1answer
191 views

More advanced logic while filtering a view? SP2013

I am attempting to filter a document library view in SP2013 but I have three things I need to filter on and I don't know if I can perform the logic desired. I want this view to only show documents ...
0
votes
1answer
335 views

Show only unique (not repeating) values of column in sharepoint list 2013

I have a list with two columns. Column names are Username and Status (options Free and Busy). Usernames can have both Free and Busy status or only one type Free or Busy. To make more clear this is ...
3
votes
4answers
1k 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 ...
0
votes
0answers
12 views

Rule inserted in user form doesn't work when Field Grouping is enabled

I have created a user form in SharePoint and has created one rule for one particular field in the form. The rule works fine, but when I do “Field Grouping” in the user form then rules doesn't work any ...
0
votes
2answers
193 views

List Views to display the items falling on Monday based on Date and Time column

I have a SharePoint list for Doctors appointments, this list has two Date&Time columns with name Visit Starts and Visit Ends. Now, I need to create a List view as Monday's Guests which should ...
0
votes
1answer
19 views

How to change list column that is defined as multi-line to single line input

I have imported an excel document into SharePoint 2010. One of the columns was automatically defined as being multi-line, but I want it to be single line input instead. I have looked at redefining the ...
0
votes
0answers
110 views

Cascade delete from lists

I have 3 lists with a lookup field to a document library. This fields is created from XML (deployed) with this properties: Indexed="TRUE" RelationshipDeleteBehavior="Cascade" Now, what I would ...
0
votes
1answer
25 views

InfoPath Designer - Largest Field Size

What is the largest field size that can be created in InfoPath Designer and is it a Text field or a Memo Field or something else?
0
votes
0answers
24 views

Decrease Title Character Limit

I know it's not possible to increase the maximum length of the title column. Character limit on Title column However, what would be the easiest way to decrease it to 50 Characters, for example? I'm ...
0
votes
2answers
101 views

How to display Title field as editable in Edit Properties

I have a custom Content Type, and a library template with that Content Type, that includes showing the default Title column. I created a library with the template with that Content Type yesterday, and ...
0
votes
0answers
54 views

Custom column doesn't show up under Page Fields in SPD toolbox

I have a presumably an easy question than a harder question: I've setup a custom column (called "mycolumn") that is a choice type with several values you can select. I associated the column with my ...
0
votes
0answers
63 views

List field manipulation based on rules

he following situation: I have got list (List A) with the following fields. Field A ->String Field B-> String Field C →LookUp to another list Field D → Calculated field Field E On creating or ...
0
votes
1answer
943 views

Column validation for US phone number format

I want to validate the field for US format phone number(478-857-4578). I used the below code, it works fine for all but one scenario. If I enter only 4 digit number or below than, the error message ...
1
vote
1answer
29 views

Auto-populate a column based on a different column

I was wondering if someone could help me with an issue I'm having in SharePoint. I made a library and one of the columns has a Yes/No option. The following column is based on that response. If the ...
0
votes
0answers
175 views

Group/person field multiple values

I've created a 2010 workflow using SPD that takes values from the field in InfoPath form and copies it to the element column (both fields are group/person with multiple values allowed). The thing is, ...
0
votes
1answer
546 views

SharePoint Column Name “Name” The column name that you entered is already in use or reserved. Choose another name

I am trying to change a column named Name1 to Name but it's returning an error message The column name that you entered is already in use or reserved. Choose another name I tried but it doesn't ...
1
vote
1answer
30 views

Is there to have a parameter for an entire list?

Is it possible to have an attribute, like start date, where other columns would use it to calculate their value? For example the due date column would take the start date and then add the amount of ...
1
vote
1answer
57 views

Validation Formulas not working on a specific site

I have troubles using validation formulas on one specific site. Within a large sharepoint I was working on one site and had no problems using validation formulas. Now I now want to implement these ...
1
vote
1answer
49 views

Best practice: when to create a new content type or add column?

I'm still learning SharePoint and I'm coming getting stuck on whether to create a new content type or add a site column to an existing content type. For example, I created a base company document ...
1
vote
0answers
1k views

Change List Item Created Date field with Powershell

Good Day, I have a list in SharePoint 2013 that I'm importing items from a csv. I need to change the created date to the created date of the imported item. I'm able to import the list item ...
0
votes
0answers
13 views

How can I break up a column in a conent type without losing the terms?

I've developed a term list and a particular field in a content type that is applied to all of my libraries, but given the diversity of the content, the term list has gotten too long and I want to ...
0
votes
1answer
26 views

New custom columns are not in SharePoint 2013

I have imported a MS-Project 2013 into our SharePoint 2013 and during the process I have mapped custom MS-Project columns, which now are part of my task list view. What I'm trying to achieve here is ...
0
votes
0answers
137 views

column setting “Require that this column contains information ” will be set to No when creating a list

I am working on SP 2013 + team site collection. I have the following scenario which I can not understand: 1 - I have created a custom site column named “Area” of type drop down list with choices and ...
0
votes
0answers
27 views

Remove existing Column from List

I know there are different questions and answers to this, but they are old or have a different approach. I have added some existing site columns to a list via "Add from existing site columns". Now I ...
0
votes
1answer
47 views

Event receiver, unpublish

Hi how could i use a event receiver based on a document library, to se if the user has unpublished a dokument in the library, in the mean time also i want to update a field in the document library ...
0
votes
1answer
29 views

Missing columns in look-up column

I created a new document list and enabled some column in the view: Afterwards a I created a custom list and added a look up column. In this column I would like to specify a column of my document ...
0
votes
1answer
73 views

Html in Snippet not showing

I've created some Rollup Details site columns and include them in the page layout. Then i found them in the snippet gallery and copy them into the Edit Mode Panel. Exactly like how it's been done to ...
0
votes
2answers
78 views

Choice column : how to set its content with all existing values

I have a column called project based on a static list of values. I would like that list to display all already existing values in project and allow the user to add a new one if he does not find the ...
0
votes
1answer
324 views

Can anyone color code a column with an if statement?

Here is what I am trying to do. I have a SharePoint 2010 list that I want to color code dates based on that it expires 364 days after the date entered. Example: If the date is older then 334 ...
1
vote
1answer
160 views

Hiding Fields in an InfoPath Form

Is it possible to hide fields in an InfoPath 2013 field based on the value of another field? Possibly through JavaScript? I have an InfoPath 2013 form that is linked to a SharePoint 2013 List, and ...
0
votes
1answer
352 views

Which Database table stores the XML column mappings for Lists?

First off, I'd like to say that I understand the limitations and the risk of accessing a Sharepoint Database directly. I am not updating the SP Content, just simply querying the data in a SQL View for ...
0
votes
1answer
59 views

Lookup Column of a List Column

I have a requirement for a project site in SharePoint. The Site will have: 1st List: a Stakeholders List with the names of people involved (people/group type) in the project and their Project Role (...
0
votes
1answer
263 views

Can field in form autopopulate based on other field's drop down selection? Both fields are from the same list

I have a form that's pulling in items from different columns of this list:![List][1] On the form, you have the option to select Job Title and, later on the form, Systems Access, ![Categories][2] Since ...
0
votes
1answer
363 views

Require field to be not null in sharepoint list

I have several columns to input a number, the field is required with a default value of zero. This works fine when filling out the form, but once they save it then go back into the form the user can ...
0
votes
1answer
55 views

Create multi user selection field

how could i create a multi user field? <Field ID="{6ec181bb-e64c-40cf-9a77-48c98108e981}" Name="Field" DisplayName="MyUserField" Type="UserMulti" Required="FALSE" Group="myGroup"...
0
votes
1answer
130 views

Mixing between “lookup” column type and “People or Group” column type

I want to create a site column that contain a list of “Project Managers”, where some project managers are already defined inside Active directory and are defined inside a SharePoint security group , ...
1
vote
1answer
359 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 ...
1
vote
1answer
67 views

Is there a way to allow subsite admin to modify only specific site columns

I am working on an issue tracking list inside my SP 2013 team site, and i need our current sub site admin to be able to modify only specific site columns at the list level. the problem i am facing is ...
0
votes
1answer
138 views

Powershell script to add a field to all the document sets

I have created a field in sharepoint content type hub. Now I want to add this field to all the Document Libraries in my sharepoint online tenant. Is there a powershell script which can do this for me?...
0
votes
1answer
104 views

How do I add check boxes to my columns in my list view?

In the image below I would like the columns that say yes to be check boxes instead of text. The columns are set up as Yes/No column type. Is this possible?