|
Alexander Bautz Profile |
|
|
SPJS Charts for SharePoint v3.x
Alexander Bautz
This article will freshen up on the setup of the solution and will describe the changes in v3.1 Keywords: New chart types, multiple dropdown filters and variables in the custom CAML query. I have “silently” released version 3 of the “Charting for SharePoint using Google Visualization API” solution in November 2011. You find it here. [...] [read].
Posted: about 11 hours ago. |
Dynamic Forms for SharePoint
Alexander Bautz
I posted a teaser for my latest project in December. Now I thought it was time to post a working solution! This solution will let you add dependent logic to your forms. For example you could have a Yes/No check box determines whether some fields as required or not, or the status selector in a [...] [read].
Posted: Wed, Jan 18th '12 |
Bring back the missing list tools menu in list view with multiple webparts
Alexander Bautz
In my latest project I added a web part to a list view and needed to have the list tools visible. I had to look for a fix to the disappearing list tools menu. Yes you can bring it back by clicking the web part you want to focus on, but it will be hidden [...] [read].
Posted: Wed, Jan 11th '12 |
Approve multiple documents or list items in one operation with client side code
Alexander Bautz
I got this request from Larry: Good day A, Have a question. Is there an easy way to add to the SP 2010 ribbon an approve all button. I hate having to select each item and manually approve each one. I have found some script but they are deployed on central admin. I would like [...] [read].
Posted: Wed, Jan 11th '12 |
Pull user list property from people picker and write to separate textfield
Alexander Bautz
I have previously posted a solution for pulling the email address from a people picker. This is an updated version that lets you pull any user list property (this is the built in user list in SharePoint and NOT the SharePoint Server Shared Service Provider profile) from the people picker and write it to a [...] [read].
Posted: Sun, Jan 8th '12 |
Teaser: Dynamic [required / visible] fields for SharePoint
Alexander Bautz
Here is a teaser for my newest project: Stay tuned for updates! Alexander [read].
Posted: Fri, Dec 9th '11 |
Follow me on twitter
Alexander Bautz
Hi all, I have finally joined twitter! Follow me to get notifications on new and updated articles Alexander [read].
Posted: Wed, Dec 7th '11 |
All the code has been moved to http://spjsfiles.com
Alexander Bautz
Hi all, Due to instability on my home server I have moved all code referred in the articles to a hosted site on http://spjsfiles.com I have made a redirect in the old location and will try to update all links in previous articles. Stay tuned! Alexander [read].
Posted: Tue, Dec 6th '11 |
Truncate text in list view and add mouseover preview
Alexander Bautz
I have previously done this article Multi line text field in list view: Shorten text and add hovereffect to view full text. This post is an updated version to support both SharePoint 2007 and SharePoint 2010. Features This solution will shorten any text column (single line or multi line) in a list view to a [...] [read].
Posted: Sat, Dec 3rd '11 |
Compare date with today: status indicator in list view
Alexander Bautz
The first solution i posted in this blog was the Compare DueDate with Today in list view. I have redone the solution and added support for SharePoint 2010 grouped views. I have NOT included the mouseover “overdue by” text. If there is a demand for it, i could add it back in. How to use [...] [read].
Posted: Tue, Nov 29th '11 |
Status
Alexander Bautz
Hi all, I’m glad to have so many active reader! I do however have some trouble keeping up with all the comments and questions – both in the articles posted here, and to my email address. I intend to answer all comments, requests and emails, but please keep in mind that this is a one [...] [read].
Posted: Sat, Nov 19th '11 |
Parent-child-grandchild relationship in SharePoint 2010 lists with javascript only
Alexander Bautz
I got this request from Sheree Wu Hi Alex, I am new to SharePoint and have been struggling with steep learning curve and would really appreciate your help… I created a parent-child-grandchild relation where I inserted a related view in the parent’s dispform to show all children and also in the child’s dispform to show [...] [read].
Posted: Sat, Nov 19th '11 |
Superfish drop-down menu – buildt from a SharePoint list
Alexander Bautz
I got this request from Larry: Hey A, I have a good request for you. I would like to build a menu structure using a SP List. JQuery has a plugin called Superfish http://plugins.jquery.com/project/Superfish. looks like it can create a great menu structure with multiple levels. If the menu items could be maintained in a [...] [read].
Posted: Sun, Nov 6th '11 |
SharePoint 2010 – The view selector is back!
Alexander Bautz
In SharePoint 2010 you loose the list view selector in a list view if there are more than 1 web part in the page. This makes navigating the list views very cumbersome. I have previously created a solution for adding a view selector in these list views, but that solution was a bit clunky. I [...] [read].
Posted: Thu, Oct 27th '11 |
List all attachments when clicking the paperclip in a list view – updated version
Alexander Bautz
I have previously posted a solution for listing all attachments when clicking on the paper clip in a list view, you find it here. This is an updated version with a few new features – and SharePoint 2010 support. I post it in a new article to keep it tidy. The new features are: Option [...] [read].
Posted: Fri, Oct 7th '11 |
Accessing user profile information in SharePoint with javascript – updated version
Alexander Bautz
I have previously posted a solution for pulling user information from the built-in user information list in SharePoint (found in WSS 3.0, MOSS 2007 and SharePoint 2010 both foundation and server). This is NOT the user profile found in MOSS 2007 and in SharePoint 2010 server. You find the solution here This solution is an [...] [read].
Posted: Sun, Sep 18th '11 |
Pull e-mail from people picker and write to a separate textfield – updated version
Alexander Bautz
I have previously posted a solution for pulling the e-mail address from a people picker and writing it to a separate field when saving the form. You find it here. This one does the same, but i have updated the scripts and added an “onchange event” that triggers when you enter the name in the [...] [read].
Posted: Sun, Sep 18th '11 |
Preview metadata in list view on mouseover – updated version
Alexander Bautz
This is a remake of a previously posted solution for previewing an item in a list when hovering over the table row or a custom image. You find the code below, but first an overview of the features. List view Preview on hover This solution works in both SharePoint 2007 and in SharePoint 2010, but [...] [read].
Posted: Mon, Sep 12th '11 |
Remove group label in grouped list view
Alexander Bautz
I got a request from Djamel asking for a solution for removing the group label (the field name) in a grouped list view. Add this code to a Content Editor Web Part (CEWP) in the list view. Adding a CEWP in a SharePoint 2010 list view will unfortunately remove the list view selector. SharePoint 2007 [...] [read].
Posted: Tue, Aug 30th '11 |
Charting for SharePoint using Google Visualization API: Update 16.08.2011
Alexander Bautz
I have posted a new version of the “Charting for SharePoint using Google Visualization API” – v2.9.3. You find it in the download section below. These are the changes in this release Save as template: I have added a new checkbox to the configuration: “Use display name for list and view”. This one will replace [...] [read].
Posted: Tue, Aug 16th '11 |
Offline for one week
Alexander Bautz
Hi all, I will be offline for approximately a week and cannot answer any questions until I’m back. Alexander [read].
Posted: Fri, Jul 22nd '11 |
CommentBox for SharePoint
Alexander Bautz
I got this request from Brett: Hi Alexander, Got an awesome request for your mad skills. Are you able to provide a Javascript/JQuery code for a Comments Box Web Part? So it can be added to any page, list or library? I’m thinking you could set it like the Poll web part, where the Admin [...] [read].
Posted: Sun, Jul 10th '11 |
Pull on-call information from calendar
Alexander Bautz
This solution is an answer to a request from Colin Blake: Hey Alexander, I’ve been browsing through your blog (amazing!) and have not been able to come up with anything yet using your posted solutions so I was hoping you could help me or get me pointed in the right direction. I have a calender [...] [read].
Posted: Thu, Jun 9th '11 |
Interactive Charts using Google Visualization API: Examples
Alexander Bautz
This post describes the use of the tool posted here. The latest changes are found here. This post will be updated with examples on how to utilize this tool to build various charts. I will add examples upon request. If you have a smashing chart or a special trick, please send it to me and [...] [read].
Posted: Mon, Jun 6th '11 |
Charting for SharePoint using Google Visualization API: Update 05.06.2011
Alexander Bautz
I have posted a new version of the “Charting for SharePoint using Google Visualization API” – v2.9.0. The changes are described here, but the background story and the code is found in original article. This post describes the new features in v2.9.0. You should read the original post found here, the update for v2.8 posted [...] [read].
Posted: Sun, Jun 5th '11 |
Hit counter and star rating for SharePoint
Alexander Bautz
I have redone the Hit counter for SharePoint and changed from a simple “Like” to a star-rating. I have done a total rebuild of the code and this new release will perform better in lists with a large number of hits. Note: If your pages will have more than a few thousand hits, you most [...] [read].
Posted: Sat, May 28th '11 |
Charting for SharePoint using Google Visualization API: Update 05.05.2011
Alexander Bautz
I have posted a new version of the “Charting for SharePoint using Google Visualization API” – v2.8.5. The changes are described here, but the background story and the code is found in original article. This post describes the new features and changes from v2.8. You should read the original post found here, and the update [...] [read].
Posted: Thu, May 5th '11 |
Redirect from NewForm to DispForm or EditForm
Alexander Bautz
I have done a few articles on this subject earlier, but here is another method which is simpler to use. What it does is to modify the form action in NewForm to redirect you to DispForm or EditForm after the form has been submitted. You are redirected without the ID parameter in the URL. When [...] [read].
Posted: Sat, Apr 23rd '11 |
Toggle appended comments in multi line fields
Alexander Bautz
I got this request from Tim: Tim Says: Is there a way to hide the appended comments to a multipe line field with version control. Actually can it a a click hide/show, and can it display the last comment by default? click it the see all pervious comments. Larry got a bit on the way, [...] [read].
Posted: Fri, Apr 22nd '11 |
Charting for SharePoint using Google Visualization API: Update 27.03.2011
Alexander Bautz
I have posted a new version of the “Charting for SharePoint using Google Visualization API” – v2.8. The changes are described here, but the background story and the code is found in original article. This post describes the new features. 1. Filter the chart using a choice column from the list The dropdown is created [...] [read].
Posted: Sun, Mar 27th '11 |
Accordion for SharePoint forms v2.0
Alexander Bautz
This solution is used to break up a SharePoint form into sections – like in an accordion. Features Full SP2007 and SP2010 support for both lists and document libraries Works for all standard field types (Custom field types are not guaranteed to work) A field can be used in multiple section You can have a [...] [read].
Posted: Sat, Mar 12th '11 |
Tabs for SharePoint forms v2.0
Alexander Bautz
This solution has previously been published over at NothingButSharePoint This solution is used to “tab” SharePoint forms. If you have a long form, you can group fields together and present them in tabs for a better overview. Features Full SP2007 and SP2010 support for both lists and document libraries Works for all standard field types [...] [read].
Posted: Sat, Mar 12th '11 |
Inline editing for SharePoint 2007
Alexander Bautz
I have previously created a solution for editing items inline in a list view. You find it here This solution did not support choice fields or multi line text fields. I stated a long time ago that i would update the solution to support choice fields, but never had the time to implement it. This [...] [read].
Posted: Mon, Feb 7th '11 |
Get n’th given day of any month
Alexander Bautz
Based on recent requests i want to post this solution for getting the n’th given day of any month in any year. For example the third Friday of current month: <script type="text/javascript"> var myDay = getNthDayOfMonth(3,5,'',''); alert(myDay); /* Parameters: index: n'th occurrence of the specified day day: daynumber - javascript way where sunday is 0 [...] [read].
Posted: Fri, Jan 21st '11 |
Poll for SharePoint
Alexander Bautz
This code lets you generate polls using JavaScript/jQuery only. No need for server side installed WebParts. Poll Result with bar chart Result with column chart Result with pie chart The charts are generated using Google Chart Tools / Image Charts (aka Chart API). Create a custom list with the following fields Answer: Single line of [...] [read].
Posted: Tue, Nov 23rd '10 |
Convert a standard SharePoint lookup column to a full blown cross site lookup using javascript only
Alexander Bautz
I have updated the tool described in this article with some new functionality. The functionality i will describe here is the ability to convert a standard SharePoint lookup column to a cross site lookup column using javascript/jquery only! Download the script from the above referred article. Create a Lookup column in your list and have [...] [read].
Posted: Wed, Oct 20th '10 |
Interactive Charts using Google Visualization API v2.0
Alexander Bautz
Since i posted the previous version of the solution that utilizes the Google Chart Tools / Interactive Charts (aka Visualization API), Google has updated their API and made the previous version more or less obsolete. NOTE: I have made a “bridge” between Google’s Visualization API and SharePoint. How the charts render or function it up [...] [read].
Posted: Wed, Aug 25th '10 |
List all attachments when clicking the paperclip in a list view
Alexander Bautz
I got this request from Chris: …the challenge I’m currently trying to solve is to get the attachments paperclip in a listview clickable. Using a doclib and linking against the file is not an option since we are talking about a lot of files with the same name which should be stored with the list [...] [read].
Posted: Tue, Aug 24th '10 |
Visual status indicator based on 5 date columns in a list view
Alexander Bautz
I got an e-mail from Charlie Epes about a ticket over at STP Hi Alexander: You are mentioned in the thick of a request started by me. If you want to chime in here, please do! http://www.endusersharepoint.com/STP/viewtopic.php?f=10&t=1319 My challenge was: Here’s an example of what I’m trying to do in my List. Let’s say my [...] [read].
Posted: Fri, Jul 2nd '10 |
Vertical Scrolling WebPart
Alexander Bautz
I got this request from Charlie: …a solution that I can use as a dashboard web part to vertically scroll the most recent “top 10” items from a 2nd list? Example: I need to be able to grab the most recently items marked as “Completed” or “Sold” from a list and be able to show [...] [read].
Posted: Tue, Jun 22nd '10 |
Numbers only in single line text field
Alexander Bautz
By request from Larry, here is a solution that restricts input in a single line text field to number only. Note: It is treated as text in SharePoint and you cannot sum or average in a list view. Add this code to a CEWP below the list form in your NewForm or EditForm: <script type="text/javascript" [...] [read].
Posted: Thu, Jun 17th '10 |
Show field description in list view column header
Alexander Bautz
I got this request from Saran to display the field description when hovering the mouse over the column header in a list view. Add this code to a CEWP and place it below the list view: <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script> <script type="text/javascript"> wsBaseUrl = L_Menu_BaseUrl + '/_vti_bin/'; var myTooltipObj = customGetList(ctx.listName); $(".ms-listviewtable th"). [read].
Posted: Thu, Jun 17th '10 |
Send email with javascript – with the help of a workflow in a dedicated “send email-list”
Alexander Bautz
This solution “injects” data, using JavaScript, into a custom list. This list has one purpose only: sending an email containing the injected data. The custom list have the following fields: Title: The native Title field – holds the subject. To: Single line of text. Cc: Single line of text. EmailBody: Multiple lines of plain text. [...] [read].
Posted: Tue, Jun 15th '10 |
Cascading dropdowns in SharePoint text fields – populated by lookup in another list (version 2)
Alexander Bautz
I have previously posted a solution for creating cascading dropdowns from SharePoint single line text fields. Populated based on a query against another list. I have reviewed the script to add a few enhancements. No more need to create a calculated column in the “lookup list” Less arguments to pass to the function – sleeker [...] [read].
Posted: Mon, Jun 14th '10 |
Edit document metadate without creating a new version or triggering workflows
Alexander Bautz
Have you noticed that when uploading a new documents in a document library, the connected workflows do not trigger? This behavior can be used to “sneak” in changes in a documents metadate without triggering new versions or connected workflows. The trick is simply to load the page with the parameter “&Mode=Upload” in the URL: [your [...] [read].
Posted: Tue, Jun 8th '10 |
Manipulate upload link in document library
Alexander Bautz
I got this request from JGilmore: Anyone know how to change the URL of the ‘Upload’ button as well as the links under its dropdown? I would like to have the user directed to a custom upload page with ‘Overwrite existing files’ unchecked by default. Thanks in advance. Here is one possible approach Add this [...] [read].
Posted: Tue, Jun 8th '10 |
Get or Set value for SharePoint field in NewForm, EditForm and DispForm (Get only in DispForm)
Alexander Bautz
This article describes how to get or set the value for all standard SharePoint field types in in NewForm, EditForm and DispForm (Get only in DispForm). This solution is tested in IE8, Firefox 3.6.3. Instructions for getFieldValue The function “getFieldValue” takes four arguments: fin: FieldInternalName of the field to set the value for. dispform: true [...] [read].
Posted: Fri, May 28th '10 |
Autocomplete for single line of text
Alexander Bautz
I got a request form Charlie on how to accomplish autocomplete for a single line text-field, reading the values from itself. This solution resembles my Autocomplete for SharePoint people picker, but it pulls date into a single line text field. As always we start like this: Create a document library to hold your scripts (or [...] [read].
Posted: Thu, May 27th '10 |
Interactive Charts using Google Visualization API
Alexander Bautz
This is a teaser on a solution for creating charts directly from SharePoint lists using Google Visualization API. The solution is a CEWP-solution and requiring no other than a few script references. All code and data are processed and rendered in the browser. No data is sent to any server. The solution features “Sum”, “Count” [...] [read].
Posted: Tue, May 4th '10 |
Image preview on hover over a hyperlink field
Alexander Bautz
I got this request from Mark: Hi Alexander, I did not include the column as a picture because they are to big to display in the list view. For this reason I setup a list with a hyperlink to the image. Besides it would look terrible having a list that displays all these large pictures [...] [read].
Posted: Thu, Apr 29th '10 |
Get field value for all SharePoint FieldTypes or set field as read only in EditForm
Alexander Bautz
I have had several requests for a solution for setting fields as read only in EditForm. I have created this script to achieve this.
This script enables you to get the field value for any SharePoint field type in EditForm, and to set the field as read only by grabbing it’s value, hiding the <TD>, and [...] [read].
Posted: Thu, Apr 22nd '10 |
Toggle column visibility in list view
Alexander Bautz
19.04.2010 Modified code to support “pre hiding” from query string parameter. Both the CEWP code and the file “ToggleColumnVisibility.js” has changed.
Here are a solution for toggling the columns visibility in a list view by adding a checkbox row above the list view. Remove the check to hide the column. recheck to show.
The solution dynamically adapts [...] [read].
Posted: Sun, Apr 18th '10 |
Filter a calendar view based on user profile property
Alexander Bautz
I got this request from Carel Schotborgh:
Using WSS 3.0
Not have been able to find it anywhere so, since it is possible to filter a list items (in all event/task/etc view) based on membership in SharePoint group (By Alexander). I would like to request the possibility to filter an Agenda View on a single line text, [...] [read].
Posted: Sun, Apr 11th '10 |
Revised function init_fields()
Alexander Bautz
I got a tip from Alexey Krasheninnikov regarding using regex rather then “indexOf” and “substring” in the function “init_fields()”. It is both quicker and cleaner.
This function is used in all my scripts that works with NewForm, DispForm or EditForm. It only works in non-modified forms.
Here is a revised version of the function. The regex [...] [read].
Posted: Wed, Apr 7th '10 |
Pull e-mail from people picker and write to a separate textfield
Alexander Bautz
I got this request from Indra:
Hi Alex,
This is really great blog!! awesome work and i am big fan of this site, i check everyday and look at the things and learn , but i need something that i cannot find any where. Let me explain what i need..
I have a list with a people picker [...] [read].
Posted: Tue, Apr 6th '10 |
How to troubleshoot when the scripts does not work
Alexander Bautz
In most cases where users have trouble getting my solutions to work, the problem is the script references. I will give a few examples here on how to troubleshoot these cases.
To copy the script from sourcecode provided in the article, hover over the script and click “view source”. Highlight, copy and paste in notepad. Save [...] [read].
Posted: Fri, Apr 2nd '10 |
Edit SharePoint Field properties, including lookup column list association, with client side code only
Alexander Bautz
31.03.2010 Updated the code to fix a bug regarding “ShowInDisplayForm”, thanks to Mike for spotting the bug.
This code enables you to edit the following field properties using jQuery only:
Hidden: Specifies whether the field is displayed in the list.
ReadOnly: Specifies whether values in the field can be modified.
Required: Determines whether the field requires values.
Show In NewForm: [...] [read].
Posted: Tue, Mar 30th '10 |
Autocomplete for SharePoint people picker
Alexander Bautz
26.03.2010 Updated code to be able to clear the selection It’s only the code for the file “AutocompleteForPeoplePicker.js” that has changed. Thanks to Steve for pointing out the bug.
This solution adds auto complete functionality to a standard SharePoint people picker.
This solution is built with the autocomplete widget from jQuery UI. The values are pulled from [...] [read].
Posted: Wed, Mar 24th '10 |
vLookup type rollup for SharePoint
Alexander Bautz
01.04.2010 Small update to the file “vLookupForSharePoint.js”. I have modified the argument “hoverToView” to have separate settings for DispForm and for ListView. You must change the argument “hoverToView” to “hoverToViewDispForm” and “hoverToViewListView” in your calculated columns.
I have long thought of making a generic solution for pulling information from another list, kind of like you would [...] [read].
Posted: Wed, Mar 17th '10 |
Filter Radio Buttons or Checkboxes based on selection in another field
Alexander Bautz
15.03.2010 small update to the code to handle blank “triggervalue”. Thanks to Larry.
I got this request from Elstone:
Hello
I have two choice fields, 1 drop down and another is multiple radio buttons (6 values/radio button). This I want to implement on newform/editform
In dropdown I have 3 values i.e. Yes/No/Not Sure (selected by default).
I want to show/hide [...] [read].
Posted: Sun, Mar 14th '10 |
Add character or word count to SharePoint multi line plain text field and restrict input length
Alexander Bautz
14.03.2010 Updated to count down from limit to 0 and color code the counter. Also merged the “Count characters” and the “Count words” functions to one. See new code and explanation below.
I got this request from Larry:
new request for you. Character/word counter for multiple line field to display below the field. Not general for all [...] [read].
Posted: Thu, Mar 11th '10 |
RSS Feed
