Questions tagged [column]

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

308 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
35 views

How to update value into extra column in calendar app

I use calendar app to create a form for Training Course Registration. Location, Start & End time, Description are default column in calendar and I added new extra column (MaxOccupy and AttendCount)...
0
votes
1answer
428 views

Group by more than 2 columns in SharePoint 2013 in Data view Webpart

http://www.dotnetsharepoint.com/2015/05/group-by-more-than-2-columns-sharepoint.html this link which was mentioned earlier didnt worked out for me though i followed each and every step properly. Can ...
0
votes
1answer
287 views

Get child item count to only show on folders, not on documents too

Part 1: For the main all documents view, I have only folders which show the item child count. That is how I want it, but then, when I click into the folder which only has documents in it, I would like ...
0
votes
2answers
893 views

Create Custom People Picker Column in SharePoint 2013

I want to create custom Person or Group type of field which is mapped to User profile.when we add user name to that field then auto fill other columns like first Name,Last Name,Email,Work phone. In ...
0
votes
1answer
430 views

Calculate Columns to create Leaderboard

I have created an InfoPath form for a company-wide Step Competition that will have different communities competing against each other for walking the most amount of cumulative steps. Each form ...
0
votes
1answer
16 views

Is it possible to set up a list Title so that when clicked, the URL associated with the Title is launched?

I have a Content Editor Web Part that shows a Title (of an article) and the associated URL next to it. Users click on the title and the Edit box opens. They should click on the URL, but they don't. ...
0
votes
1answer
23 views

Default Column in SharePoint List

I am not sure what it is called, but I want to change the Key column so that the Open Menu is on a different column. The column it is in now is going to be a hidden column.
0
votes
1answer
443 views

Task list Due Date column

I have many problems in using a 2013 Reusable Workflow. I have to copy tasks from many task lists in the site to a single general list: in order to do it, I have created a Reusable Workflow and ...
0
votes
1answer
74 views

Trying to create a lookup field but unable to find the source field

I created 2 lists (A and B). A Field1 field2 Field3 B Field4 Field5 Field6 On A I have a lookup field Field2 which is based on the Field4 of B. It works fine. I would like to make a lookup in ...
0
votes
1answer
890 views

List that I've created is defaulted with “Stop editing this list”, want to make it so it defaults as “new item or edit this list”

One of the lists I've created is defaulted with this interface: I want it to be able to default with "new item or edit this list" instead as such:
0
votes
2answers
73 views

Need to grab address column and pass it to an array

My script uses an array like this: var locations = [ ['Location 1 Name', 'New York, NY', 'Location 1 URL'], ['Location 2 Name', 'Newark, NJ', 'Location 2 URL'], ['Location 3 Name', '...
0
votes
1answer
37 views

Refinement options… do custom columns have to be managed metadata or can they be attributed to free form text or “choices”?

In order to make it a managed property, does the site column have to be "Managed Metadata" or can it be free form text?
0
votes
1answer
97 views

Counting Field Changes

I need to setup some type of counter on how many times a field has been changed in my SharePoint list. Is there any way to do this without coding? If so please explain. Thanks!
0
votes
3answers
187 views

Can I make a column in a library on SharePoint UNsearchable?

Is there a way to make one column in a SharePoint library UNsearchable? Basically I have a list that contains documents, dates and a column for "comments". I want that "comments" column to NOT ...
0
votes
3answers
71 views

List Column autoincrementing Identifier

I want to create sequential ID for transactions under a specific account. So, lets say I have an account XYZ. The first transaction ID should be XYZ-1. The second XYZ-2 and so on. I have a two lists. ...
0
votes
1answer
26 views

Display persons based on view

I have a Person column I'd like to display in some view as just name, some other with presence and again in some other place with picture and details. Does anybody know a workaround to get it (unless ...
0
votes
1answer
34 views

How do I multi-entry Column Default Values in SharePoint 2013 Document Library?

There are 12 monthly folders, one for each month. I want to set default values in each for automation operations. Current method I am using: Go into the Library Setting Click in Column Default Value ...
0
votes
0answers
133 views

get computed field source field in CSOM/JSOM

I know how to get all the fields in a list using CSOM/JSOM. What I cannot figure out is how to get the source field for computed fields. For example, the LinkTitle field is a computed field soured ...
0
votes
1answer
1k views

Infopath 2013 validation error message about a missing field

Currently testing a Sharepoint list form customized in Infopath. Once I've been through the whole - long- form in Sharepoint, and click on 'submit' the form returns a message error that reads: ...
0
votes
1answer
44 views

Using actual Dates to calculate a list column

We are on SharePoint 2013 externally and Office 365. I am trying to make a calculated column to filter a list on specific dates but it keeps error. Is it possible to calculate on dates such as Between ...
0
votes
1answer
48 views

Unable to save data in picture library SharePoint 2013

I have created picture library using default template in SharePoint 2013 site. I have created new columns for picture library. In above image, I trying to save new value for Country column. when I ...
0
votes
2answers
42 views

Does a field need to be placed within an InfoPath form in order to store a value?

I'm interested in storing a boolean value in a field. However, I don't necessarily want to place the field onto the form. Can values be stored, changed and used in rules without inserting the field ...
0
votes
1answer
99 views

Export a list column with name “Workflow”

Has anyone ever seen this strange behaviour or can confirm? I have a custom list (in a SP2013 site), very simple and clean structure, only Title field and one additional custom list column named "...
0
votes
1answer
26 views

Create calculated field with colour shading

Have a document library with Expiry Date column for specific documentation. I need to set up a calculated field to highlight documents that expire within 3 weeks / 2 weeks and 1 week from the date ...
0
votes
1answer
311 views

Update user field based on the selected lookup value

I need to update a user field based on the value selected from a lookup column. Ex: I have a lookup column with Location details. When I select a location the corresponding manager name gets ...
0
votes
0answers
76 views

SharePoint List with large number of columns goes off the screen in Oslo Theme

My SharePoint site uses Oslo theme. I have a SharePoint List with large number of columns. Whenever this List is opened, there is alot of blank space on the left side of the page. Here's screenshot-...
0
votes
1answer
639 views

Spservices autocomplete with many columns

Could somebody advise how can I make autocomplete for multiple columns, currently I'm using it for one column: $().SPServices.SPAutocomplete({ sourceList: "My list", sourceColumn: "Email", ...
0
votes
2answers
360 views

Job title column

Is there a way I can capture the users job title at the time they add an item to a list. I'm able to show the users job title in a column however it will change when their job title changes. I would ...
0
votes
1answer
76 views

Discussion Board data missing in column

On a SharePoint 2013 intranet, I created a discussion with "Created By" being one of the column. The column is to show the Office, users are from. The office is displayed for some users while being ...
0
votes
2answers
37 views

Help with calculated columns

I have two columns in my SharePoint list called name and email, So I want to have the name be the display name and have the value of the email. So when a users selects a name he or she won't see ...
0
votes
1answer
76 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 ...
0
votes
3answers
106 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
512 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
1answer
315 views

Lookup column restriction

For a school project we are setting up a SharePoint for a non profit organisation who handle clients. we have made a document library where we store documents sets for every client thats added. In a ...
0
votes
1answer
202 views

Get schema name of specific field in list

How to get Schema name of specific field in a SharePoint list? I'm using SPservices to get list items from the list but one field is missing in the result. I want all field values of the list
0
votes
1answer
70 views

List Column visibility

I have a list where users can create a new item. There is a column named "status" that should not be visible to users when adding a new item. That column should be visible when editing an item and ...
0
votes
1answer
278 views

Column validation based on another column

I have a list where users can fill a column named "External effort (m/d)" (type of column is number). After that column, I have "External resource cost" column, which type is currency, and where users ...
0
votes
1answer
707 views

Efficient way to get all the field (column) values in an array from SharePoint List

I have to get all the field (column) values in an array from a SharePoint list. Right now I am looping through all the items in the list and creating an array. But it is very inefficient if I have ...
0
votes
1answer
58 views

Unable to send emails to address stored as a String

I am having trouble with a helpdesk we are using. It had been set for internal staff to use and so when they raised a ticket, it remembered who they were and could then send email updates out nice ...
0
votes
0answers
96 views

Color code Columns?

we have imported a spreadsheet into a new list on a SharePoint 2013 site and as a result have a lot of data with many columns. What we want to do is colour code it as per the original spreadsheet - ...
0
votes
1answer
218 views

How to get SPField and avoid exception that it is not exists?

I run now this code and got an exception on the first row. How to avoid an exception when the column doesnt exists? SPField field = contentType.Fields.GetFieldByInternalName("ArticleStartDate2"); if(...
0
votes
1answer
165 views

Rich HTML - No Limitations

I have followed instructions (basically exactly the code in the link) on how to create a unrestricted HTML field: http://blog.mastykarz.nl/publishing-rich-html-no-limitations-sharepoint-2010/ I am ...
0
votes
1answer
211 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
1answer
75 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 is ...
0
votes
0answers
24 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 ...
0
votes
2answers
136 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 ...
0
votes
2answers
3k 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 ...
0
votes
1answer
464 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
1answer
39 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
104 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 ...