Questions tagged [column]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
16 views

Text Column Validation: Numbers only, 5 numbers, a period, and 3 numbers

In my SharePoint list, I need a text column [ID] to validate as 5 numbers, a period, and then 3 numbers. Example: "15202.123" and I need help. :-) Thank you!
3
votes
2answers
1k views

Calculated Column needs left alignment

I have the same exact problem as related here Calculated Column left align header However, the solution suggested is inadequate. This would require me to manual add the web part to each list that I ...
3
votes
1answer
750 views

Add Rich text column to the Blog Post comment (SharePoint 2013)

I am trying to customize the Blog post comments in SharePoint 2013 by adding a new custom column using RichText (called RTBody) and hiding the old one called Body in several pages, such as Post.aspx ...
1
vote
1answer
1k views

Sharepoint Online - Recover column from lists of project sites

I have a site collection with a lot of subsites attached to projects (each subsite is a site created by a project). Those subsites has a list with its fields. I executed a PowerShell script that ...
2
votes
2answers
2k views

Getting hyperlink URL and description in custom XSLT with Content Query Web part

I'm having trouble getting the URL and description to show as separate items in SharePoint 2013. I'm trying to display the description as the text of the Link and the URL as the HREF value in the a ...
2
votes
2answers
3k views

SharePoint Excel export issues (ID export to lookup columns/Columns out of order)

Good day, I have 2 issues I am trying to workout on some SharePoint Lists. I was hoping I could get a little help as my developer skills are just now developing beyond OTB solutions. Issue 1: I ...
1
vote
4answers
1k views
0
votes
2answers
757 views

Columns not displaying value

I've added some columns (name, ID etc ) to the document library after the documents have been uploaded, and got no value displayed. Is there any way to fix this or I'll have to recreate the library?
0
votes
1answer
43 views

JSON Sharepoint Calculated Columns

First time coding with JSON and need a little help...... I am attempting to make a calculated column with conditional formatting. So far i can get it to work but only partially. What i want is to have ...
2
votes
1answer
1k views

Amending the Calendar form in Sharepoint 2013

I have a question about the Calendar app. I made the Location field compulsory from the Validation settings and a red warning message appears, when you try to save an event without its location. How ...
0
votes
2answers
4k 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 ...
2
votes
1answer
2k 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 ...
0
votes
1answer
804 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
23 views

Email users based on results of choice column with checkboxes (multiple selections)

I am looking to create a workflow that sends an email to users based upon the results of column that allows multiple selections. The column has 8 selections and it basically needs to email user "...
0
votes
1answer
721 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 ...
2
votes
1answer
22 views

How to find all selectable properties of a list item

If I run the query ..._api/web/lists/GetByTitle('Site Pages')/items, I get a list of properties, but it is not comprehensive. For example, FileRef is not visible in the resulting JSON, but can be ...
0
votes
1answer
788 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
2answers
32 views

Hidden columns visible in edit form for a content type in SharePoint online

Recently we migrated few sites from SharePoint 2010 to SharePoint online. The source site had few managed metadata columns. For each of these columns, SP2010 had created a Single line of text column ...
0
votes
1answer
961 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
731 views

Column formatting changes not saving

For my document library on sharepoint online modern view, I have a column for Title. I've tried to format it so that the height changes dynamically based on how long the title is and when I save it at ...
0
votes
1answer
847 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" DisplayName="$Resources:Project....
0
votes
5answers
4k views

Change column color of a list webpart

We have a landing page that consist of a scheduled maintenance list webpart and we want to have a color coded background for a column. For example: In Progress = Red Completed = Green I tried the ...
0
votes
1answer
764 views

Saving Publishing Page in edit mode returns “Are you sure you want to leave this page?” dialogue

we're getting some ... interesting ... behavior in IE. Setup We have a page layout based on some content type. Both contain (besides other fields) a DateTimeField which is shown in edit mode. When ...
0
votes
2answers
2k 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
1answer
51 views

SharePoint Online - Show column description or full column name when hovering the column header

We currently have a SharePoint list that has quite many columns, with describing column names making the column names take up quite a lot of width. Many of them get cut off in the middle of the name, ...
3
votes
1answer
738 views

How to associate an existing site column to a list using the REST API

In SharePoint 2013, I have a site column that already exists and I'm trying to associate it to an existing list using the REST API. I found examples on adding a new column to a list using the REST API ...
0
votes
1answer
716 views

How to refine search using existing Site Collection columns

I want to refine the search based on existing site collection columns. How i do that: Any suggestion or good article on this topic. As i am pretty new to search? My requirement is that, my client is ...
0
votes
2answers
736 views

Field not found exception

I have an ASP.NET Web Service (ASMX) and a class for working with lists (CRUD operations). Web service's method calls method (retrieve item from list) from CRUD-operations class and then I recieve an ...
0
votes
1answer
36 views

Flow to modify columns on dynamically determined Sharepoint library

I have a flow through Power Automate and one of its functions is to modify metadata of a file stored in a Sharepoint library based on certain criteria. The metadata is stored in custom columns and the ...
1
vote
1answer
1k views

Locking Sharepoint column after data is input

How can I lock a column (in a list) from further changes after it is initially populated? I want to lock down the "initial due date" and only allow changes to a "revised due date" column so we can ...
0
votes
1answer
732 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
3k views

Save to a People or Group column using SP 2013 REST API by login name only (without the ID)

This question will be a duplicate of this one (which has no accepted answer). I am trying to save a SP 2013 list item using the REST API. One of the columns is a People or Group column. Normally ...
6
votes
3answers
68k 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 ...
0
votes
1answer
73 views

Correct way of Convert Enhanced Rich Text field to Plain Text (multiline) - Sharepoint 2013

I changed a type of a Enhanced Rich Text column to Plain Text field. I am seeing similar to the following content in the text field now. <div class="...
0
votes
2answers
1k views

Making a yes/no column show an icon rather than text

I'd like to have a Yes/No column that rather than showing the usual text ("Yes"/"No"), shows an icon - say green or red. I know I can create another column (a calculated one) with a formula that ...
0
votes
1answer
926 views

Deleted “Resources” Column and now site gives error

I've deleted the Resource column in my calendar list and now, when I have Use this calendar to share member's schedule checked YES, I get an error: Unable to retrieve 'Resource' field from the ...
2
votes
1answer
761 views

Set Web Part Page Columns for Equal Width

I have a web part page with header, footer and 3 columns. I want the three columns to be of equal width. I have searched but can't find and simple CSS code to apply. I don't have access to SPD. ...
0
votes
1answer
778 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 ...
1
vote
2answers
347 views

How can I locate the 'Approval Status' column in my List Settings?

I have a SharePoint Online list that has recently grown to over 5000 items. Here is what a given entry looks like on the AllItems view, with the column I'm interested in circled in red: When I go to ...
0
votes
1answer
979 views

How to hide specific column header in a list WebPart?

I created a webpart with URL column header, but i want to hide it for users...i know i can hide it using CSS but it hides all the colum headers in other webparts, Any solution to hide only the URL ...
0
votes
2answers
1k 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 ...
1
vote
1answer
966 views

how to change the format of the “person or group” column

In my document set (Sharepoint 2010) I have a column with type of “person or group” which I can add the name of some users to it. The format of the names is like this: firsName1 Surname1; firstNmae2 ...
1
vote
3answers
3k views

Conditional Columns in SharePoint List

Is there a way to have a Conditional Column with Multi-Line Text that will only show up in the list if a certain status is selected?
1
vote
1answer
23 views

Nesting IF Statements in SharePoint Calculated Column

Uhh!. I have 3 statements that individually return my values. Now, I need to put these together into one formula. Here are my statements that need combined into one calculated column. Thank you. 1st ...
4
votes
1answer
3k views

Phone number column validation

I want to add phone number column with below format: 1-121-343-6917, 434-5503 & 60-12-444 444 Used below method =TEXT(123456 ,CHOOSE( LEN(123456) ,"0" ...
0
votes
1answer
1k views

On click of save button, 1 column to take the value of another column in a list

I have a list with columns "due date" and "revised date" in SharePoint. I want to enter the due date column only when I am entering items for the first time. Onclick of save button I want the ...
0
votes
1answer
15 views

How can I make a list view with 4 columns use two zones or columns on a wiki page

I have a list view that contains 4 columns. The list is being shown on a wiki page. I want to wrap the list so that it is not so long. By wrap, I mean split the number of rows in half and show the ...
1
vote
0answers
32 views

Tenant level mapping to crawled property

I have mapped a crawled property ows_DocumentType to RefinableString00 in the SPO Admin console, and I can confirm that all my Site Collections see this mapping. How do I create the columns on these ...
0
votes
0answers
30 views

People column not showing up in Word quick parts

I have a People column in my document library, and I have added it to my Document Set. I have also checked the People column to be a shared column in the Document Set Settings. I have other columns ...
5
votes
5answers
3k 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
2 3 4 5
21