Another requirement for my teleconference reservation form was to only allow one unique user to be assigned to a number. I had to figure a way to filter or exclude previously selected users from other drop-down box selections. My user drop-down is populated via the Attendees people picker field from […]
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
Had a request from a customer for a report showing the number of Remedy incidents transferred from his managed group to other groups during a given date range. I figured out a pseudo lead/lag query for SQL Server 2008. This creates an output that aligns the current row with the […]
42″ wide by 4″ high by 12″ deep. Lid attached by trunk latches. When detached, the lid can be second tier of pedals.
Code updated: 02/23/2018 for bug fixes. I needed to create a panner that would make 1 rotation over 5 minutes. I discovered two other projects to base mine on. Construction is pretty much the same as the source projects below. I rewrote some of the code. My TimeLapse Panner prompts […]
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 import InfoPath forms into a SQL table for consolidating reporting purposes. In this scenario the InfoPath form data is stored in the form XML itself. The InfoPath form is for tracking project activities and has 6 fields: Project Leader, Week End Date, Accomplishments, Milestones, Risks, Lessons […]
