Questions tagged [column]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
6 views

Set Form Values from Popup window

Good Day, I have the non-standard task. I have SharePoint Document List and Directory List. The Directory List includes three columns: “Process” (single-line field), “Process Group” (choice field), “...
0
votes
0answers
8 views

How do I provide a list of choice if a former column is YES [closed]

i need the user to have a list of choices to choose based on the selection of another column. For example if column A has choices aa,bb,cc and if user selects cc then the next column should have a ...
0
votes
1answer
845 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
2answers
1k 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
12 views

SharePoint Online modern site: Create Site column with multilingual Title using powershell

I can't figure-out how to create a site column with multilingual Title in SharePoint Online on modern sites using powershell. Example: I would like to create a column with the English Title "...
0
votes
2answers
16 views

Populating column value based on another column [closed]

lets say a have a list with a column titled 'fruit', (ex: orange, banana, grape) I want to add a column 'fruit color' which populates automatically with, (ex: orange, yellow, purple) is there a way to ...
0
votes
1answer
31 views

Sensitivity label value for PDF documents not showing in SharePoint Online library

I have sensitivity labels enabled for my Office 365 tenant and have created labels, policies as well as some DLP rules. All appears to be working correctly in SharePoint libraries, apart from PDF ...
0
votes
1answer
705 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
1answer
18 views

How can't i refresh ListItemAllFields when site column is updated?

I'm updating site column with this code: Field field = site.Fields.GetById(property.MappedSiteColumn); clientContext.Load(field); field.SchemaXml = xml; clientContext.ExecuteQuery(); The site column ...
2
votes
1answer
35 views

Do File Libraries have any column types that can be modified after approval?

I have a Doc Library with versioning, content approval, etc. that gets updated with a Flow/Power Automate after the user has checked-in. I want to have a column or two that are not doc properties and ...
0
votes
2answers
704 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
753 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
1answer
18 views

Editing Format of an attribute in SharePoint list is different from its viewwing format

I am working on a list and the format of a column is currency and currency format is $NZ and it shows the values as it's supposed to (e.g. $123,000), but when a user wants to enter a new row or edit ...
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
25 views

CASE SENSITIVE Custom Validtion syntax for the IN operator for a column of SharePoint list

I am entering the below condition as the validation formula for an attribute in the SP list, but it allows me to enter "innovation" instead of "Innovation", how can I avoid this. =...
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 ...
0
votes
1answer
708 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
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 ...
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
771 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
2answers
893 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 ...
2
votes
1answer
733 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. ...
11
votes
5answers
8k 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 ...
3
votes
4answers
8k views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
0
votes
2answers
38 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 ...
1
vote
2answers
1k views

How to set only positive number in sharepoint 2013 column

The column Title has default setting as single line text. I would like to set validation as only positive numbers allowed, no decimal. I've tried with =ISNUMBER(PurchaseQty+0) but I still can key in ...
0
votes
1answer
257 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
2answers
35 views

Count Number of Items of Specific Value and update field in another list

I am stumbling with this in a huge way and I'm hoping someone here can help. I have a SharePoint List that has two fields I want to collect data from. The first field in Location and the Second is ...
0
votes
1answer
907 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 ...
0
votes
1answer
975 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
34 views

Is there a way to remove white-space from the Text?

For example, If I give input text in the Column as - mo bi le pho ne. Then the data should be saved in the column as- mobilephone (it should remove all the white-spaces) Also, the Validation formula ...
2
votes
3answers
4k views

Custom list quick edit missing one or more required column

I am trying to create a custom list that is editable in quick view, only three columns are required (Project Name, Project Start Date, Project Estimated End Date)and I am trying to display it in a ...
1
vote
1answer
39 views

Unable to delete Column

Forgive me if this has been asked before but I have not been able to find a solution that works. I am currently teaching myself how to use SharePoint. I have created some columns that have errors in ...
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 ...
0
votes
2answers
197 views

In a library, I find a column called TAGS, what is it?

While playing around, I noticed a column appearing among the available ones in the view settings called 'Tags'. I have displayed it and the image inside the library (of a person) showed the tag '...
0
votes
0answers
7 views

Want to Update Drop-Down Column Selected value with Single Item (Record) Collection Column name Quantity in Power Apps. Need Help

As beginning I have attached the List to the gallery & Copied the Selected Row (all Columns) as per my choice into Collection(ChooseItems) in one Screen. I have selected many rows from Gallery and ...
1
vote
1answer
929 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?
0
votes
1answer
22 views

Update column based on file views in document library

I have a document library with a bunch of files im sharing with others. I have a column called "Opened" which is based on a yes/no value, and it defaults to no for each file. I'm wondering how I can ...
0
votes
1answer
26 views

Is it posible for a document set to inherit metadata from a document which is inside this document set

I'm running in to this problem where people want to add metadata to a document using that same document. This is possible using Word quickparts. Now for the fun part, the documents are inside a '...
0
votes
1answer
31 views

How to mask a field like SSN or ID field?

Is there way to mask a field like social security number or ID field? I like mask field both in list view level, edit form and view form. Is it possible? Sharepoint 2013 (we have nintex form as well)
0
votes
1answer
24 views

Column Validation/Validation Settings, How can I add a formula where if one answers YES to one column it will require them to fill out certain columns

I have a sharepoint list where I have a series of questions. The first question in the series is a YES/NO question, and it states if the answer is no, there is no need to answer the next few ...
0
votes
0answers
19 views

Unable to set User SharePoint group column (lookup) value

Would like to request for some assistance in SharePoint. I have a SharePoint group called Users and SharePoint List called Role and Department. I have added Role and Department to Users column as ...
2
votes
1answer
52 views

[PnP][SharePoint] How to add a column to all content types of a list?

I have a list in SharePoint with 50 content types. My list has two columns that I want to add to each content type in my list using PNP library. Until now I have something like this: Add-PnPField -...
0
votes
1answer
10 views

Infopath-Populate ID from SharePoint List

I have an InfoPath 2013 form with multiple views with a lot of fields for users to fill out. My final page after the user submits the form through the main data connection is a view that says "Thank ...
0
votes
0answers
8 views

Enable Table Styles Group for enhanced rich text field

Good Day, I have enhanced rich text field in some SharePoint List. I can insert table to this field, but Table Styles Group is grayed out. How can I enable Table Styles Group for rich text field? I ...
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 ...
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
28 views

Create a column unique to only a single folder within a document library

I am currently working on a standalone project that has numerous documents that will reside within the project folder located within my organizations document library. Below is an idealized example ...
0
votes
1answer
30 views

Custom Validtion syntax for the IN operator for a column of SharePoint list

I am trying to find out how can I write a code to restrict a user to enter a value among a set of predefined values (i.e. IN Operator) in a column of a SharePoint list. My column name is "Asset type" ...

1
2 3 4 5
21