|
Alexander Bautz Profile |
|
|
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
