Questions tagged [datasheet]
A type of list view that organizes list columns into a spreadsheet format and can enable editing of multiple items at once without having to open each individual item.
158
questions
1
vote
1
answer
20
views
Add content editor in datasheet view
I'm using SharePoint 2016 classic view.
I want to edit a Datasheet view on a library, like it's possible for "classic" views.
For example, I sometime add a content editor on some "...
- 21
0
votes
1
answer
496
views
Convert SharePoint Custom List in Datasheet View to a Regular Custom List
I created a custom list in datasheet view and populated it with a fairly large number of items.
I am now discovering a few limitations with this list type versus a the standard SharePoint custom list (...
- 101
0
votes
2
answers
155
views
Sharepoint 2013: Can you control the input of a Datasheet View?
Goal : Prevent user from inputting duplicate information through Datasheet view.
To add some context, duplicate information was being inputted into a library list. To resolve the issue, I created a ...
0
votes
1
answer
36
views
Form Library datasheet view value disappears on tab off
I am working in SharePoint 2016 on Premises. Using InfoPath designer 2013, I published an InfoPath form to a library. The form works fine when editing values in the browser. I created a datasheet ...
- 404
0
votes
1
answer
86
views
SharePoint 2013 DataSheet View make Column mandatory
I am currently trying to make a specific Column mandatory on SharePoint Datasheet View.
SharePoint default validation on Column or List Level are NOT an option.
I allready have the Code to check for ...
- 21
0
votes
1
answer
114
views
Sharepoint Datasheet Compact view
Can we make Datasheet view like wrap-text we do in excel current column have large multiple text which is making hard to read or edit
- 139
0
votes
3
answers
705
views
Export table to exisiting sharepoint list from excel
Is it possible to export data from excel to exisiting sharepoint list i do not want to create new one ,copy paste datasheetview is not working as expected and taking time do we have any options?
- 139
0
votes
1
answer
238
views
Create hyperlink to a filtered Datasheet view
Is it possible to create a direct link to a Datasheet/quick edit view which is already filtered.
If I copy the filtered URL:
http://example.com/sites/sitename/list/dataentryview.aspx#...
1
vote
1
answer
148
views
Import Spreadsheet to Datasheet SharePoint with calculating columns
Is there a work around in importing Excel Spreadsheet data (copy and paste) into Datasheets with calculating columns? For some reason, when I import it, the calculating column doesn't populate and it'...
- 307
1
vote
0
answers
152
views
New entry on top instead of bottom in SharePoint Online List Datasheet view
I have a list in SharePoint Online where the newest entry has to be on top of the datasheet view, I like to have the NEW empty row on TOP and not on bottom by Default as shown in the below screenshot
...
- 828
0
votes
1
answer
305
views
Two Header Rows in Datasheet View
Is it possible to have two header rows? Example, one row is the title and the one below is the description.
OR
In the Column properties, can we add the Description as the 2nd row of the Datasheet ...
- 307
0
votes
1
answer
18
views
List Datasheet upload & added column
This is hard to explain, but I'll do my best.
I have a SP list where I update the data from an excel file and copy&paste it into the datasheet view of my SP list.
I have a SP custom view of this ...
- 1
0
votes
0
answers
18
views
Can a drop down list open automatically upon entering the field?
I have a list in a datasheet view with a drop down on the 3rd field.
When I navigate into the 3rd field I want the list to open. The reason for this is beacuse the user is entering data via a ...
- 1
1
vote
1
answer
42
views
SP2013 NOTES column won't accept PASTE
I have another one of my lists that I need help with. This list has a NOTES section that displays a LINK that says "View Entries...". While this may be an obvious statement, I cannot paste to this ...
- 164
1
vote
3
answers
15k
views
Change the background color for an entire column in a sharepoint online list
I've been looking for a solution to change the background color of specific columns in a SPO list. There seems to be a lot of information on conditional color coding but not the requirement that I am ...
- 23
1
vote
1
answer
374
views
SharePoint Online, JSOM, 'ObjectSharingInformation is not defined'
How do You use ObjectSharingInformation in javscript?
I get
Uncaught ReferenceError: ObjectSharingInformation is not defined
My function is something like
function getSharingDetails() {
...
- 1,623
1
vote
1
answer
325
views
SharePoint Online CSR, make clickable link in Datasheet View
Want to create direct link to Document Set folders, so found and changed CSR that do this. Works well, but not in Datasheet View (it is not clickable in Datasheet View).
Tried to change column types ...
- 1,623
0
votes
1
answer
369
views
Datasheet view edit list items not validating multiple users edition (SPOnline)
so we have a list that a lot of users edit at the same time in list view edit mode (datasheet view),
if we were editing rows things at the same time we expected the red error telling us that one row ...
- 245
0
votes
2
answers
501
views
List structure has changed error in Datasheet mode - SharePoint 2010
We have a custom list that we are trying to edit in Datasheet view and are getting the following error when the next row is clicked:
Another user has changed the structure of this list. All your ...
- 2,110
0
votes
2
answers
716
views
Create list datasheet view using the REST api
Provided following body content for a SharePoint REST api call:
{
'__metadata': { 'type': 'SP.View' },
'Title': 'Awesome View',
'PersonalView': false
}
This creates a new view named Amesome ...
- 159
0
votes
1
answer
2k
views
Blank window when editing list item
I have a problem when I want to edit a list item.
When click on it or "..." edit item I receive white window with "x" all items of the list.
However when I want to add an item there is no issue; form ...
1
vote
0
answers
135
views
is there any way i can get a js event or function when i edit cells in Datasheet/Quick edit view?
I need apply some client side changes when i click on cells for editing. i wanted to know if there is certain javascript event or functions which i can use to apply the changes through javascript/...
- 31
1
vote
1
answer
197
views
Sharepoint 2010 Datasheet columns that require data are not included in this view
I have a problem in a lists datasheet view. It's a regular issue list with a custom content type added to it. In the content type, there are 9 fields that are set to require information. When I ...
- 23
0
votes
1
answer
904
views
Why would DataSheet View work on 1 list but not another?
I created a list about a week ago (Custom List) and created a view from the DataSheet View template - and it works just fine. Today I created another list (Custom List) and then tried to create a ...
1
vote
0
answers
132
views
Detect When new row is created in Quick edit view with the help of javascript/jQuery
I needed to apply certain validation on cells of Quick edit.
I can apply once it is loaded thereafter I need any event so that I can detect when the user has created a new row and call my validation ...
- 31
6
votes
1
answer
18k
views
Import/Copy/Paste Data from Excel into Existing SharePoint List
How can I import data from Excel into an existing Task List (or other list) for the various column types using the Datasheet View?
- 243
2
votes
1
answer
223
views
Datasheet view Headings modify
I am looking to modify the headings on a datasheet view of my list. I want to do any 1 of the 3 options below
1. Remove the headings column. I have tried adding the following code
.ms-...
0
votes
1
answer
118
views
SP task list data push to SQL
What is my option so my sp task list still push the data to our sql database using the datasheet view? I was told that adding new item to the list triggers an event handler which uploads the data from ...
- 31
0
votes
1
answer
747
views
Display Item Count in Quick Edit mode
Is there any way to display column count in Quick Edit mode? Datasheet view had this option to "Show Totals" but this seems to be missing with Quick Edit
- 1,512
2
votes
1
answer
82
views
Datasheet View to include overlay data
Is there a way to include the data from the calendar overlays in the datasheet view? I am trying to aggregate the data from the different calendars into a table or datasheet format.
- 21
10
votes
1
answer
654
views
Read Only in Datasheet view
I have a List that has a column that I changed from single line of text to multi-line text and now when in datasheet mode it tells me and my users the cell is read-only. it works fine in Standard View....
- 151
2
votes
0
answers
413
views
Attach file in Datasheet View
SharePoint 2007 allowed adding attachments to list items in Datasheet view. However, with SharePoint Online (Modern / Classic view) I do not get any options for attaching items in Datasheet view.
Is ...
- 881
1
vote
1
answer
317
views
2013 - Populate column based on another value in datasheet view
I'm using SharePoint 2013.
I'm trying to understand if is it possible to populate a column when another column is filled in datasheet view.
I mean: I have a SharePoint list with "Start Date" and "...
- 1,073
0
votes
2
answers
1k
views
Create view, no "Datasheet View" option
In only one of my libraries (it's a picture library), there is no "Datasheet View" as an option when creating a new view? (Only standard view and calendar). It's Sharepoint 2013
I'm trying to follow ...
- 73
0
votes
1
answer
52
views
Redirect from datasheet view in sharepoint 2013
I have a sharepoint 2013 list. When the user clicks on edit this list to open it in a datasheet view...after making changes when clicked on stop ,the data should be saved and redirect to another page....
- 463
0
votes
2
answers
8k
views
Redirect to another page after submitting form [duplicate]
I have a sharepoint 2013 list. When the user clicks on edit this list to open it in a datasheet view...after making changes when clicked on stop ,the data should be saved and redirect to another page....
- 463
1
vote
4
answers
5k
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 ...
- 31
-1
votes
1
answer
3k
views
Adjust column width in Quick Edit or Datasheet View [duplicate]
I am trying to find a way adjust the column widths/wrap text in the Quick Edit/Datasheet view in SharePoint 2013.
So far, I have only seen ways to adjust the widths in the standard view (using CSS), ...
3
votes
1
answer
57
views
problem with more than one datasheet views on SharePoint 2013 page
I have a problem with the datasheet views on SharePoint 2013.
When I add more than one datasheet on a page I have some troubles with choice fields. When I try to select a value on the choice field ...
1
vote
1
answer
42
views
See More in DataSheet View?
This seems like a simple enough question although I can't seem to find the answer on Google or here thus far:
Are you able to change the page when in Datasheet View - SharePoint 2010?
I also ...
- 193
4
votes
3
answers
15k
views
SharePoint Online : Cannot view lists in DataSheet View
I want to view my list as datasheet. But I can't see it anywhere. Some sources that I found in Google said that I need to open in IE. But there's still no DataSheet option
- 371
8
votes
3
answers
1k
views
Datasheet view added programatically missing from view selector
I am adding a new view to a list using CSOM (ViewTypeKind = Grid).
The same code works perfectly for other types of views.
For datasheet views, although they are added and they function properly, ...
- 5,457
2
votes
2
answers
2k
views
Can I revert File Names back to a previous file name?
I changed file names by mistake while in Datasheet View by dragging the corner of the top row down. The file names that changed need to be changed back to their previous and correct name.
- 174
0
votes
2
answers
609
views
SharePoint - Make column read only in list based on condition
I have an Risk/Issue where the user selects from a drop down list if the item is an issue or a risk.
Two fields severity and probability calculate together to give a score for Risks in my list. My ...
- 175
3
votes
1
answer
2k
views
SharePoint 2013 Online - Is it possible to freeze panes for a task list (header row)
We have a task list containing many items. The idea is to update the list in datasheet view. but Users complain that they can't freeze the top header row.
I have suggested filtering the content ...
- 43
1
vote
2
answers
2k
views
Sharepoint-Online Caculated End Date shows as blank on Gantt View
I have noticed a number of issues with DataSheet/Gantt View when using calculated columns, i will list others at the bottom, however my main concern here is my gantt chart not showing an end date for ...
- 111
0
votes
2
answers
127
views
Datasheet view export
I am using a datasheet view in sharepoint to manage an excel like sheet that multiple users can modify there data in. right now i export the list manually and upload it to the service provider. I am ...
0
votes
1
answer
390
views
SharePoint 2013 Datasheet view is read only
I have created a DropOffLibrary, added a few documents. Then created a DataSheet View to allow quick edit of library properties. However, the view shows as read-only and does not allow inline editing. ...
- 61
0
votes
1
answer
184
views
Error message in Datasheet View
I keep getting the two error message when trying to copy/paste or use the autofill or fill down options on a list in datasheet view.
Datasheet bulk edit option is turned on and all columns which ...
- 11
1
vote
0
answers
146
views
SP2013 Datasheet View Webpart
Have an SP2013 site that contains lists and pages with web parts that link to this list. One of the pages contains a Datasheet View what is used for a quick change in a particular field to kick off a ...
