Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [column]

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

1
vote
2answers
61 views

Stoplight system pulling information from multiple columns - how to set predence

I have created a stoplight system using the instruction below: http://eimagine.com/creating-a-stoplight-color-coded-status-in-a-sharepoint-2013-list/ But want to expand it by pulling in information ...
0
votes
1answer
41 views

Missing Lookup Column Including Search Form

I was trying to create new lookup column with search form in sharepoint online (365), but the lookup column with search form is missing. i want to ask, how to add lookup column with search form? as ...
0
votes
1answer
21 views

Conditionally Trigger Column when creating Calendar Events

When creating an event in a calendar, I list 4 standards for the creator to choose from. I want the chosen standard to then trigger a drop down of locations for that standard. Can I do this? For ...
0
votes
0answers
26 views

Before I add something to Format this column

Before I add something to format this column I have got context menu: After add something like very easy: { "elmType": "div", "txtContent": "@currentField" } json code the context dots ...
1
vote
1answer
59 views

SharePoint Online- Column Calculations Getting Total Items Missing

This is for SharePoint Online Having trouble getting column item count of empty entries. Originally I was attempting to find the total number of items missing in a column. example: Column A has ...
1
vote
0answers
11 views

Is it possible to create a column underneath a content type?

So I'm trying to work on Sharepoint Automation and I'm trying to figure out on how to create a column underneath a content type. Upon reading some documentation, from REST API, I found out that it ...
0
votes
1answer
604 views

How do I “validate” a column/field only if it's not blank

I currently have a column called "MAC Address" - it is not a required field as some pieces of gear do not have an address, but unique values are enforced. If a user puts in an address I want to (at ...
0
votes
1answer
65 views

How to change like column for list layout Sharepoint

I implemented the like feature on a test column I have but I noticed the icon linked to the like is a little hart. I want to change that hart to a thumbsup or another icon. How can i do that? I would ...
0
votes
0answers
20 views

Button to show Current Time in a List Column

I would like to create a custom button in list column, that will be visible by default after adding a new item. Simple Button with a picture that will show Current Time after clicking on it. Example:...
0
votes
1answer
490 views

Retrieve a single field's version history from SharePoint

My company uses a SharePoint list as an asset inventory database. One of the fields is a Notes field. I am able to pull the current contents of the field by linking to the list in MSAccess, but I ...
0
votes
1answer
27 views

Sharepoint Email

I want a daily email to be sent that contains either the items contained on particular list view on that day, or that contains items that has a date format field set as that days' date. (Note that ...
0
votes
1answer
1k views

How to put a color code on a sharepoint column(Choice) base on the input

Hi i have this list that i use as a webpart to our homepage and it has a column name Status which has 3 choices. Ongoing, Scheduled and Completed. What i want to happen is when a choice is ongoing the ...
0
votes
1answer
22 views

I need help with a formula for a conditional column in a form

If "Other" is checked in column 1 then column 2 (Please specify)is to be displayed. What is a valid formula for this?
0
votes
1answer
137 views

How to create a lookup column with Site Design for modern sites

As per the MS article i have created site design file and uploaded to SharePoint which is working fine. But I want to create a lookup column with the site design approach. I am using below code to ...
0
votes
1answer
723 views

Calculated column returns value from another list

How can I use calculated column to return a value from another list in SharePoint?
0
votes
2answers
62 views

Sharepoint Library: Column Limit

I am syncing a folder of files between OneDrive Business and a Sharepoint Library with CloudHQ. The sync works fine, however, when I try to modify the columns by adding a column from an existing ...
2
votes
0answers
522 views

Using a workflow to automatically create document folders each time a new list entry is made

I'm new to sharepoint developer, so I'm hoping someone is able to guide me (provide simple instructions!) on whether it's possible to create a workflow where once I enter a new item in a list, a new ...
1
vote
2answers
135 views

How to refer to a lookup field in a returned CAML query?

I know how to refer to a standard field in the OnSuccess function of a .executeQueryAsync call using a CAML query; qryItems.itemAt(1).get_item('Mailto') However, I have another column that is a ...
0
votes
1answer
33 views

How do I get column data from list webpart using javascript based on the webparts selected item

Scenario: I am trying to create a group mailto function for one of my SharePoint pages. The idea is that the user can select the groups they wish to bulk e-mail within our organisation. They click a ...
0
votes
1answer
35 views

Search for hyperlink field content CSOM

Having a site column of type 'Hyperlink or picture" which is configured as hyperlink my requirement is to search for content in this hyperlink column in a CSOM Applet. Now I wonder do I have to ...
2
votes
1answer
27 views

Can i manually publish a content type hub field to a single site?

For reasons unknown, I'm currently having an issue where a single sitecollection in my SP2016, doesn't receive updates from the Content Type Hub - Neither content types nor fields. Every other site ...
0
votes
0answers
87 views

SharePoint Online rename list column title

I am trying to figure out how to rename a list column on SharePoint Online, for example I would like to rename the column "Category2" to "Category". I have seen JS examples of doing this on SP2013 ...
1
vote
3answers
4k views

Document Library add file with custom column (SharePoint 2010)

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. I am posting the file via an ASP.NET application page. Here is what I ...
0
votes
1answer
29 views

People and Groups List Column Not Appearing in List Web Part

I have one main list called "Employees". A field on the new item form is a people and groups field. On one site page I have added 2 of the employee list web parts, one is filtered. My issue is that ...
0
votes
1answer
38 views

Document Library “Modified By” metadata disappears after 2-3 seconds

I have a SharePoint Online site with one Document Library and would like to see who last modified files/folders. Once the page loads, all the metadata displays properly but 2-3 seconds later, the ...
0
votes
1answer
281 views

column validation in sharepoint list formula

Dears, Hopefully someone can help with composing a formula for a validation of a column in a sp list. I've have 3 columns with the choice "pending" or "completed". The validation would take place ...
5
votes
1answer
4k views

Can I prevent duplicates to a SP2013 list with a validation formula?

I have a SharePoint 2013 list and want to use 2 columns as sort of a natural key on the list, so when a user enters a new entry, if these 2 columns combined match an entry already in the list, it won'...
0
votes
1answer
29 views

Hiding fields in Sharepoint list view no longer working since a few days

Several months ago I've implemented a solution to show icons instead of textual status values and it's been working fine since. However, since a few days, I still see the icon instead of the text, but ...
1
vote
1answer
88 views

Is there a possibility to insert multiple hyperlinks to into the same field

Is there an option on SharePoint / Info path to choose to create a field that will enable to insert multiple hyperlinks on the same field instead of creating another field for that?
9
votes
3answers
39k views

More than 255 characters in multiple lines of text?

I have an InfoPath Form which submits the text of a textbox and saves it in a SharePoint list. Whenever a user types in more than 255 characters and I want to edit the element in the SharePoint list (...
1
vote
1answer
35 views

How to increase data size of a field in SharePoint

I have a requirement where I need to increase data size of a field in SharePoint. This field currently can hold 12 characters and I want to increase it to 15 characters. Pls, share your suggestion.
1
vote
1answer
67 views

Adding a SP.FieldUserValue into the Visitor/Member/Owner group of a site

I'm creating a website based on what a user submits in a form 3 fields are reserved for the 3 types of default groups that you're asked for when creating a subsite manually : - Owner - Members - ...
0
votes
2answers
247 views

Column validation for datepicker - end date must be within 2 years of start date

I have a datepicker. I went into list settings for the start date and set the validation to =Start Date >= today() That works great. Now I want the End Date to be within 2 years of that End Date or ...
2
votes
1answer
1k views

How To Add Color To SharePoint List Column Background?

I have a requirement to make the background of a column in a SharePoint list colored (e.g. green). I have seen posts on CSR, JSLink, Conditional Formatting, etc. & all of these articles target ...
0
votes
1answer
172 views

Custom field type column editor in Sharepoint designer

I would need some help that i was not able to google it and if there is somebody who could help me that would be great. I successfully created a custom field type Now what im looking for is some ...
0
votes
1answer
5k views

Assigning Multiple People to Task

I created a Task app using SP13. Is there a way to add more than one more person per task without using a workflow? I have added a Person and Group column; therefore, the end-user can add the person ...
0
votes
1answer
38 views

Calculated Column for SharePoint List

I have a calculated column displaying a numeric score ---is there a way to have this score rank ordered automatically? (example - scores would be 87, 75, 74...- where 87 would be the number 1 priority,...
0
votes
1answer
472 views

Cumulative sum of a column

What function can I use to create a calculated column [Cumulative Meters] that will sum [Meters] for each row? I can only seem to get a single overall sum for [Meters] using the Totals tool in ...
2
votes
3answers
22k views

SharePoint 2013 Auto populate person column in list with creator name

I have a custom list which contains several columns. I want to add a column to the list which I would like to be a "name/person" field which is mapped to registered users on SharePoint (or AD). But I ...
5
votes
4answers
2k views

How to make a Column hidden in SP List Item View?

I have a column called "Employee Email" in a custom list. Is there any option to make the column hidden while viewing the item?
1
vote
2answers
62 views

How do i get a choice column to change from YES to NO depending on another column using calculated columns

I'm trying to uses nested ifs to change what a choice column displays but I'm not sure if this can be done or if I'm doing it properly. What I'm trying to have accrue is once the next review date ...
0
votes
2answers
20 views

SharePoint File Indexing

In a document library, I would like to show different columns at a folder level, not at an overall level. Currently, I can see the column fields common for all the folders. Is there a way to have ...
0
votes
1answer
43 views

View Item Column Type in Document Library

I'm using SharePoint 2013. When using a custom list an option available is a View Item column that allows the user to view the item details. But I don't see the same option for a document library. ...
1
vote
1answer
342 views

Is there a way to create a large number of columns quickly?

I am about to create 84 choice fields for a timesheet solution I am creating in Sharepoint. Clearly I am procrastinating on this task and here I am. Is there a trick I don't know about that might ...
0
votes
2answers
40 views

how to provide validation on to create SharePoint Date and time Column?

I want to create a SharePoint Date and time Column, so that the user is only allowed only to select a date 20 days ahead of today's date.
2
votes
1answer
226 views

First letter of internal name of list column converts to _x00XX_

I need to create two new columns in a standard list, one is called "AB12" and the other one "AB13". But when I create them, the internal names of them turns into "_x0041_B12" and "_x0041_B13". It ...
0
votes
1answer
25 views

How to Shrink Blue Outline on Page So Everything Shows on Screen

Please forgive me, but I do not know code at all, and I have been asked to maintain our teacher SharePoint page. Yay! Would you take a look at this screenshot? I've obviously done something wrong. I ...
1
vote
2answers
3k views

Powershell - Change display format in SharePoint Site column from friendly to standard

How can I change the display format from friendly to standard? I want to change this on all lists in the solution $sites = Get-SPSite "http://company.com/sites/testdelete/" $created = "Created" ...
1
vote
1answer
43 views

Get the column name of list

I tried this: var fieldValues = currentItem.get_fieldValues(); But it returns [object object]. How can I see through this without know the column name?
0
votes
1answer
133 views

Validate choice from a Drop Down menu if that choice was chosen by another user

We have SP2013 (PREM). I have a custom list with a date-picker column and another column called "Timeslot" which is a dropdown menu of about 15 20-minute choices. The desired end state is to be able ...