Questions tagged [column]

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

Filter by
Sorted by
Tagged with
2
votes
0answers
128 views

Make column locked for editing by users in Sharepoint list

I currently have a SharePoint list that track open tickets for specific events. I have a flow that runs on this when an item is added. The flow creates an automatic due date (+5 days from when ...
0
votes
1answer
29 views

Code customizing

I have a document library with a deadline column and a status column. If the deadline expires, the date will be red (see code). Now, additionally, when the task status is closed, the date should turn ...
1
vote
3answers
4k views

Column Width in Quick Edit or Datasheet View

Is there a way to adjust the column widths or enable text wrapping in the Quick Edit or Datasheet view in SharePoint 2013? I have seen ways to set widths in the standard list view (using CSS), but ...
1
vote
0answers
17 views

Multillingual column name becomes internal name

I have a problem where a column used by a couple of content types is correctly named Document version when the user views the page in Swedish, but the display names becomes the internal name ...
0
votes
2answers
17 views

What validation code should I use such that if any Column entry is changed it shows an error ?

I'm basically trying to keep 5 columns of my list locked(uneditable) while the last column editable. I'm a beginner and thought this would be the easiest way to achieve this. Do kindly suggest any ...
2
votes
2answers
3k views

Sharepoint 2013: no attachment column available

I am having the same issue as here, but I have no "list" option in the ribbon, and therefore no "list settings" option. I am working on a list, but I am baffled by why there is no "attachment" column ...
3
votes
1answer
786 views

Popup confirmation on 'status' column change

I'm looking to create a popup dialogue box when a column called 'Status' is set to 'Complete'. I want a popup box to ask "Confirm Complete?" with Yes or Cancel choices. Obviously Yes will update the ...
1
vote
0answers
38 views

SharePoint 2016: filter on managed metadata column with AND operator

We are using SharePoint 2016 and have a document library with a multiple managed metadata column. In this document library we try sometimes to filter on this column. We can select 1 or more terms in ...
0
votes
1answer
15 views

Truncate with a twist

I've been browsing this site for two days now with no avail to my problem. I have a SharePoint 2013 on premise site with Designer Workflows only. This site for reasons I cannot go into is very ...
0
votes
3answers
156 views

Check SharePoint lists are identical

Is it possible to check two SharePoint lists are identical in terms of list columns(Column names and types) programmatically?
0
votes
1answer
5k views

Number formatting in Sharepoint list

I have several large Sharepoint lists that I imported from Excel, the first column of each of these lists is "Customer Number" these numbers uploaded in the form 1,000,000 and so on. I want to ...
1
vote
2answers
182 views

Set list column permission in different views of the same list - sharepoint 2016

In sharepoint 2016 I have a list with several views each targeting different audience. I need some solution to manage column permission in new/edit/display forms. I tried https://archive.codeplex.com/?...
0
votes
0answers
754 views

Formatting column making the column text to disappear in latest Sharepoint online

Formatting column with JSON makes the column text to disappear in latest Sharepoint online. E.g. if I try to use something like that: { "elmType": "div", "txtContent": "@currentField" } saddenly I ...
0
votes
1answer
276 views

Disable fields based on choice *that may have multiple choices*

Is the title weird-sounding? It is to me. But, here's my situation: I would like to disable (in some way, greying out, or whatever) certain fields in a list based upon a CHOICE field I've got at the ...
1
vote
1answer
206 views

How to create columns that pull 'Authors' and 'Last saved by' metadata from a word document

In a document library, is it possible to create a new column that pulls this data from the files properties? I’ve tried adding 'Author' from existing site columns and creating my own single line of ...
0
votes
2answers
202 views

sharepoint API rest custom column http 400

I have a list in sharepoint, where I have put the totals of the columns I am interested in. ID Count=50 Certification Count=9 I want to display these counts on another page. I have found a code to ...
0
votes
1answer
153 views

Unable to hide custom columns in Discussion Board

I have added some custom fields to a Discussion Board list in SP 2013 that are populated using Workflow. I do not want these to appear in any of the create or edit item views. I have marked the items ...
0
votes
1answer
39 views

Update existing tasks with new column and value

We want to create a new column called "Year" (Tasks > Settings > Create Column) and set a default value to "2016". Default value is already displayed when we create new task, but we have a lot of ...
3
votes
2answers
4k views

Column formatting with json

On a standard Date field that is inputted, can I display a full data format (example Friday, 23 March 2018 instead of 23/03/18) with Json to place in the column settings? Please advise
0
votes
1answer
435 views

Sharepoint Site columns how do i add a year in our column

I want to add 2019 to 2020 look upon our YEAR column. Please assist
2
votes
2answers
6k views

Calculating Fiscal Year

I am creating a document library in SharePoint 2013, where I want to have a column which shows the fiscal year (= not the date, only the year). It has to be a choice menu, since people in the ...
0
votes
2answers
35 views

Creating fields that are automatically populated based on the value in a Lookup column

I have two SharePoint lists. List #1 contains "static" information such as project number, geographic location, region, and planned inspection type. List #2 is a list that I want to use as a way to ...
5
votes
3answers
14k views

How can I provision a list with a calculated field?

I am trying to create some fields, a content type, a list definition and a list instance in Visual Studio. All of my fields are working, showing up in the list etc. except for calculated fields. What ...
1
vote
3answers
1k views

Sharepoint traffic light

My boss wants me to make a traffic light system inside a list, which changes colour depinding on the values of a column, using javascript(has to be javascript!) in sharepoint 2013. I found a guide ...
1
vote
3answers
132 views

Sharepoint 'content type' not available as a column

I would like to quickly filter by content type (on sharepoint online) in my document library, but I can not find the column 'content type' anywhere.
1
vote
1answer
61 views

How do I edit colum in SharePoint Online using JavaScript?

Hope you're well; What is javaScript code to add on SharePoint list for showing a few lines of text per row so they all the same size where reams of text have been written this is via scroll or ...
1
vote
2answers
6k views

How to add a choice type column as a lookup in another custom list

I'm trying to add a lookup column in List A that would show Status column in List B. But the status column in List B is a "choice" and SharePoint 2010 does not allow choice as lookup. I'd prefer not ...
0
votes
3answers
233 views

SharePoint: Can’t display custom column value in Search Results

Good Day! I have the List on SharePoint Site. It’s enabled for showing in search results. I see its elements in Search Results Page. I would like to show my custom column values in Search Results. The ...
2
votes
1answer
84 views

Need assistance: JavaScript Code

Code work whell before i add to code: items[i].get_item("SITE") I can take ID from code, but not a column element. What have I do bad. Here is a code: <input type='button' id='123' value='Pokaż ...
-1
votes
1answer
40 views

JavaScript code on working on SharePoint Online list

Hope you're well; I am adding JavaScript code into content web part. However it is not working. I'm i mising something out.
0
votes
1answer
4k views

Auto-populate an existing column based on another column using data from different list

I have two lists filled with data (listA and listB). A is a list of people with column 'DepartmentName' in it. B is a list of departments with columns 'DepartmentName' and 'Building'. I want to ...
0
votes
3answers
567 views

CSS: Hide empty column on SharePoint List

How do you delete or make hidden this additional column that sticks out from the header row? Can this be done using the HTML or Content editor? See attachments below. Content Editor: <style ...
0
votes
3answers
72 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
81 views

JavaScript on SharePoint list

hope you're well; What is javaScript code to add on SharePoint list for showing a few lines of text per row so they all the same size where reams of text have been written this is via scroll or ...
1
vote
0answers
101 views

New site columns not available to check in list view

I’m experiencing an extremely annoying issue with SharePoint. This is what I’ve done on our SharePoint Online tenant: Created a new modern SharePoint team site. I want to track client invoices. -...
3
votes
2answers
8k views

Rest API - Get list items by column value

Assuming there is a list of Students with their zip-codes in one of the columns, what is the query string needed to get only students with a certain zip-code? So far here is what I've got: site.com/...
1
vote
2answers
64 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
62 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
25 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 ...
1
vote
1answer
141 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
2k 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
77 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
1answer
636 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
28 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
2k 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
176 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
1k 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
112 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 ...

1
3 4
5
6 7
21