Sharepoint SIG

Thoughts and ideas from your SharePoint support team

February 20, 2015
by Sheila ffolliott
0 comments

Nintex Workflow and the Trim function

Nintex Workflow includes a Trim function that can be used to strip leading and trailing blanks from strings.  In most cases, Trim works as expected.  However, if the string that you are trying to trim contains a comma, the workflow fails with the error:

“Error retrieving context data. Error executing inline (FN-Trim) function. Check that the correct arguments have been passed to the function”

Continue Reading →

February 20, 2015
by Sheila ffolliott
0 comments

Nintex Forms – 30 minute timeout

Some people on campus have run into a problem that affects Nintex Forms.  Default SharePoint forms are not affected by this problem.  The symptom of the problem is that, when the Save button is clicked, instead of going back to SharePoint the form reappears as a blank form and the contents of the form has not been saved.  The cause of this is a 30 minute timeout.  The timeout is a SharePoint setting that affects the entire server. Continue Reading →

May 14, 2014
by Sheila ffolliott
2 Comments

Persistent fields in SharePoint – use caution

Recently I got burned by adding a persistent field to one of my lists. Persistent fields are site columns added by SharePoint and configured in a particular way. These fields can be added to a list, library or a content type. Once they have been added, they cannot be removed or edited using the SharePoint UI or SharePoint Designer. Unfortunately you cannot tell by looking at the list of site columns which ones are persistent and which are not.

Continue Reading →

February 4, 2014
by Sheila ffolliott
0 comments

Nintex Forms – New Features in version 1.4.1.0

Nintex recently released an update to its Forms product, which was installed during patch night on January 11, 2014.  I presented the new features to the SharePoint SIG group on January 24th.  As promised, here is a post that lists my notes from the SIG so others can read about them.  If you have questions about these features or would like a demo of the new features (or any Forms feature), please contact me at Sheila.ffolliott@usask.ca.

Continue Reading →

October 25, 2013
by Steven Indzeoski
0 comments

Replacing a Drop-Down List in Nintex Forms with an Autocompleting Textbox Using jQuery

An annoyance that often occurs in forms is having to select an item in a drop-down list with dozens or hundreds of items. No one enjoys scrolling through these giant lists. For the form I was working on, I needed to replace a potentially large drop-down list with an auto-completing textbox. Some issues that arose with this were that the drop-down list was linked to a lookup column in the list, and also applied a filter to a second drop-down list. To solve this problem, I wrote a jQuery plugin which replaces a drop-down list with an autocompleting textbox, and disables a second drop-down list until a value is chosen for the first field. Continue Reading →

September 30, 2013
by Sheila ffolliott
0 comments

Nintex Workflow – Update a Hyperlink Field

One of the datatypes available in SharePoint is “Hyperlink or Picture”.  When editing an item in a list via the usual data entry form, you can set the value of the Hyperlink field with both the Web address and the description that you want people to see instead of the Web address.

However, in a Nintex workflow using the “Update Item”, the screen only shows a single line.  There is no way to distinguish between the Web address and the description. Continue Reading →

April 24, 2013
by Sheila ffolliott
0 comments

Using Nintex Forms “List View” feature to implement Parent-Child functionality (partially)

Nintex Forms has a control called the List View.  This control can be used to implement a parent-child relationship between two SharePoint lists.  For example, if you have an invoice with one or more items, the invoice itself is the parent and each item on the invoice is a child.  The invoice items are attached to the invoice using a unique identifer such as the invoice number.Unfortunately the Nintex List View control displays the children with a link to edit them, but does not provide a way to add new child records through the form.  Adding children has to be done through the child list, typing in the parent’s ID manually.  This limits its usefulness for many scenarios.  Nintex support has forwarded my request for this feature to their development team but there is no indication of when (or if) this will be implemented.

For information on using SharePoint Designer and the built-in SharePoint forms to implement this type of functionality, see previous posts:

http://words.usask.ca/sharepointsig/2012/04/16/parent-child-relationship-between-two-lists-in-sharepoint-part-1/

http://words.usask.ca/sharepointsig/2012/04/16/automatically-set-the-parent-id-field-in-a-child-record/

Continue Reading →

February 14, 2013
by Sheila ffolliott
0 comments

Nintex Forms and the New “Rules” Feature

In the latest update to the Nintex Forms product, they have introduced a new “Rules” feature.  With this feature, you can check the value of a field and then change the formatting of the field on which  the rule is applied.  For example, you could change the background to red if another field on the form was equal to No.  Alternatively, you can hide or disable a field based on the choice made in a different field.  However, there are some caveats to this feature.

Continue Reading →