I created an Infopath for users to request teleconference numbers. I have two lists; Schedule and Conference List. Schedule list had these columns: Title, Start Date, End Date, Attendees, Status, Assigned. Conference List had these columns; Source (which will be set to Title above), Title, Phone Number, Start Date, End […]
Update 1/13/2016 – Changes to script. The original script hides the list view pagination. Changes marked as Pagination Fix below. I have a SharePoint list that has exceeded the 5,000 item limit threshold. This, of course, causes a couple of views to go bonkers. I indexed several list columns but […]
Create a simple interface to add/remove a single user to/from multiple groups at once. When you identify/select a user, it will show you two select lists. The right side will list all of the groups the current user is a member of while the left box shows all the groups […]
The following code returns all SharePoint permissions groups and the respective members. This uses JQuery 1.xx and SPServices. // Add JQuery and SPServices references. // GroupMember
A while ago I showed how to upload a file to a Sharepoint Document Library using a File Task in SSIS. Here’s another solution…Simply cut and paste the following into a Script Task in your SSIS package. This is the simple version as the local file, Sharepoint URL and service account credentials […]
Had a request to send notification emails against a SharePoint Task List when the Due Dates were 90, 60, 30 and 5 days out. Steps: 0. You will need to create the 6 variables show on the left. 1. I am dropping and importing the SP List Data each time […]
I have a Forecast/Trending Chart that has past and future dates. I needed to denote Today with a vertical StripLine on the chart. (Click on images for larger version.) You can add a Marker with an expression easily. In your series properties; create an expression for your Marker. In my […]
I have an email-enabled document library where reports in PDF format are delivered daily. I need to display the most recent reports embedded on a Web Part page. The filenames are structured as name_datestamptimestamp.pdf Different reports are sent here so I have to discern a part of the filename (eg. […]
In some cases you may want to audit who has what permissions to various parts of your SharePoint site or farm. This query will give you a list of all of your groups, the roles / permissions of the groups, the users in those groups, and what they have permissions […]
I needed a way for me and my teammates to see and edit all report subscriptions across a Sharepoint site with SQL Reporting Services in Integrated mode. There are two parts here; the first is a function that returns text between delimiters. This is important to get the site and […]
