Add Cancel button to InfoPath form

When you look at the standard available options for buttons in InfoPath (Submit, Update form and Rules and Custom code)  you would think that there’s also an Cancel option by default.
There is no Cancel button by default, you can however create this within two minutes.

  1. Drag a new button on the form and select it.
  2. Select in the menu bar the tab CONTROL TOOLS PROPERTIES.image
  3. Rename Button to Cancel in the field Label.
  4. Click  Add Rule, a menu is shown. Select When This Button is Clicked, a new menu appairs. Select and Click Close Form. image
  5. Confirm that you want the form to be closed by clicking OKimage

And that’s it. You’ve created your own Cancel button within 2 minutes.

Connect SQL Management Studio as a different user

Consultants often need to use different user account to connect to SQL servers or databases.

As not every customer wants to give consultants direct access to the server we use a local version of SQL Management Studio and connect via that to the databases.
SQL Management Studio runs by default under the credentials of the current user. When you select runas different user via Shift and right click the icon you get the option to connect as a different user. Problem is that accounts from customers aren’t allowed to log on.

To be able to connect as a user from a different domain you need to run the SQL Management Studio as followed:

runas /netonly /user:domain\username “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\Management Studio\Ssms.exe”

I’ve create a batch file for every customer with corresponding domain and username.

Create a listitem with date via a SharePoint Webservice workflow

On the internet there are enough methods to create a item via SharePoint Webservice, but getting date fields inserted took me more research.

Variable

Create in Nintex Workflow the following variables:

  • StartDate (Date and Time)
  • StartDateConverted (Text)
  • XML (Text)

Workflow

Set the created date in the variable Startdate with a Set variable action.

Add the calculate  date action, select in the by Date field the variable Startdate.
Add the variable StartDateConverted by the field Store ISO 8601 Date 

Add an Build Dynamic string action and cofingure as followed:

  buildcreateitemwebservice

Save the data in the variable txtBatchXML

Add a Call web service action
Add via the Insert Reference button the field {Common:WebUrl}, followed by /_vti_bin/lists.asmx. The full address is {Common:WebUrl}/_vti_bin/lists.asmx

Enter the Username and Pasword click Refresh.
Now select Web Method UpdateListItems and at the ID from the list by listname and for updates select the variable txtBatchXML

Nintex Workflow user’s Guide available

Starting to work with Nintex Workflow and overwhelmed with all the options?
Figuring out when you need which action?
You’ve created a few workflows with Nintex but you think they can be better?

For all these questions is the Nintex Workflow user’s Guide. A guide for people that are just starting with Nintex, want to know more of Nintex Workflow or even want to build complex workflows. Nintex Workflow user’s Guide comes with detailed step-by-step instruction for the creation of your first workflow till workflows that retrieve data from web services.

NWUG_Cover_Text_Long

Remove blank spaces from names in workflow

When creating a sharepoint site via a Nintex Workflow it’s best to remove any blank spaces from the url as these are converted to %20.

Most often these url’s are converted from a field a person has entered. You can explain the users that they shoudn’t use spaces or you can use Nintex to remove these blank spaces in the names.

You can easily remove the spaces by adding a Regular expression action with the following settings:

  • Pattern: \s
  • Replacement text: keep this empty
  • Input text: the name
  • Store result in: variable