Archive

Here we demonstrate how to create a cascading dropdown using Nintex Forms.The video is shown on Nintex Forms 2010, but the same applies to Nintex Forms 2013.In this written example, I demonstrate with a common State to Store relationship. You'll need to create three SharePoint lists, two of which contain the lookup information for the cascading drop down. Create the SharePoint ListsCreate two custom lists. These custom lists form the basis for the lookups, which the main list will look the cascading information up from.Navigate to a SharePoint Team Site. Click the Site Settings icon, and select Add an App. Select Custom List, and call it "State". Click Create. Open the newly created SharePoint list, and click new item. In the Title field, enter "VIC", and click Save. Repeat step 3 and enter “NSW”, “ACT”, “NT”, “QLD”, “WA”, “TAS”, and “SA”.Create the Second SharePoint List - StoresClick the Site Settings icon, and select Add an App. Select Custom List, and call it "Stores". Click Create

I need a Flexi task to be assigned to a group of people (all of which need to be able to approve/reject the task) but have the email notification (with link to task inside) sent to a separate email address (group mailbox). Does anyone know how I can achieve this please? 

So last week we updated our Workflow and Forms to the latest versions and I am now having a user report that they are seeing the below error.Server unable to process request --> Could not find stored procedure "NM_DeleteFormByWorkflowBaseID".Now my first thought is that the Nintex DB needs to be updated.  After the install, I did update it in Central Administration in SharePoint.  But when I go to the "DataBase Setup" page in CA, I do not see the "Upgrade Necessary" or whatever the text is next to the DataBase version or config db.Do I need to do a server reboot to get things to talk straight?My current DB version is 2.0.3.0.Should I re-run the install?

I have a workflow that previously worked just fine (and also a copy of the exact workflow working correctly on another library). It's a workflow to create an excel document in a library after an item is entered onto a list. The error I'm receiving is "The workflow could not create the list item. Make sure the list exists and the user has permissions to add items to the list." followed by "The workflow operation failed because the action requires the document to be checked in."   Pertinent information: I've removed all permission restrictions from the library. All users have Contribute level access. I also ensured that the "require document checkout" is toggled to no. I'm fairly certain that the issue is with the library.   Any idea on how I can fix this?

Hello, I am creating a "Stats" table in a dashboard list view. I'd like to do a list Sum for amount - *only if the status is equal to "In Progress"*.  Can someone please advise me on how to do this? Im not sure how to add conditions in to the expression. or even if this is the correct approach to do so. Kind Regards,Luke

Products: Nintex Workflow 2013, Nintex Workflow 2010 This week a request came in for a way to activate Web Applications via PowerShell, below you will find a script that does exactly that. Each section of the Web Application sequence is segmented off into separate functions which are wrapped in try/catch blocks for ease of troubleshooting.  PowerShell Script Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") [void][System.Reflection.Assembly]::LoadWithPartialName("Nintex.Workflow") [void][System.Reflection.Assembly]::LoadWithPartialName("Nintex.Workflow.Administration")   $ErrorOccurred = $false   function Activate-WebApplications(){ $Host.UI.WriteLine('Activating Web Applications.') foreach ($WebApplication in [Microsoft.SharePoint.Administration.SPWebService]::ContentService.WebApplications){   if ($WebApplication.IsAdministrationWebApplication 

Good day Nintex community, I am not familiar with the development in Nintex workflow and  have been struggling for weeks now, please help. I am using Nintex 2013 I need to come up with a step in Nintex workflow where I have to create a folder in a document Library, inside that folder there should be subfolders and inside the subfolders there should be files. I have used the "create item" action and I was able to create folders and subfolders, however I am struggling to place the files provided inside those subfolders. so that every time the workflow runs it should automatically create those folders, subfolders and files in a document library. below is the screenshot of how I configured the action, I have created variables for folders and set have set each variable. also is there a way of setting the variable in one place/action with Nintex workflow 2013?    

I am newbie in k2 blackpoint and I wonder if I can debug my workflow in k2 studio or using different tools. It's little bit confusing when I need to finish workflow and check only the results.

Q: I would like to be as prepared as possible for my upcoming upgrade to the latest version of K2 Five. I have read through quite a bit of documentation, and I am pretty confident that I have gathered all the necessary information as well as met all the prerequisites, but I have a nagging feeling I am forgetting something. Is there a document that K2 can provide that brings all of the information I am going to need together in one place? A "prerequisite checklist" of sorts? A: Please find attached the "K2 Upgrade Planning Sheet.docx" document. This document can be used as a planning sheeting which can serve as an aid in the planning for the upgrading of the K2 Five environment. It covers a checklist of all the Environment Information you will need, such as the accounts used in the installation, the required permissions needed, as well as Server and Software information you should have on hand. It will be a great reference to have to allow you to collect all the information in one place

I've been referencing the MSDN articles a lot recently on Date and Time format strings and sometimes I get confused by the many options and sometimes these formats do not carry over or function. So I wanted to build a quick reference sheet that I can refer to in my workflows and forms. First, how to use the inline and runtime functions. fn-FormatDate in WorkflowsRepresents a date time value in text of a specific format. Usagefn-FormatDate({WorkflowVariable:MyDate}, d) Other NotesFor workflow inline functions, using single quotes takes the value as a literal. So for the formateDate function fn-FormatDate({WorkflowVariable:MyDate}, 'D') provides the value of D. Using double quotes or no quotes produces the same result. For example:fn-FormatDate({WorkflowVariable:MyDate}, "dd/MM/yyyy") and fn-FormatDate({WorkflowVariable:MyDate}, dd/MM/yyyy) both produce 11/08/2015fn-FormatDate({WorkflowVariable:MyDate}, "D") and fn-FormatDate({WorkflowVariable:MyDate}, D) both produce Tuesday, August 11,

Hi Everyone,   I have a workflow that works and fails sporadically, with no changes in between. It is failing in and around the Lazy Approval reply (Using accepted term on server). Full error message: "Error in request approval action. Unauthorized attempt to update approval task by Manager. The response has not been recorded." I tested with my account (admin) on Friday, it failed. Tested with same account today, it worked. Today for example, 1 user submitted 4 workflows and same manager approved: 3 times it worked, once it failed. Any ideas as to what would cause or correct this sort of inconsistency? See attachments for error.   Thanks,  

Is it possible to add additional approvers to approval workflow in flight

How to add Save as Draft button functionality and users can modify their own items? Please follow this post for Save as Draft button functionality, thanks Dan Stoll for wonderful post. Under Version settings, set "Content Approval" to Yes and set "Draft Item Security" to "Only users who can approve items (and the author of the item) ". This would help us to hide own draft item from others.   Under Advanced Settings Set Item Level permissions to "Create items and edit items that were created by the user". Now Build you Nintex Form by adding two Calculated fields and Save as Draft button. Set 1st Calculated field Value  Set 2nd Calculated field Value to  [if IE 9]  [endif]  userProfileLookup(Current User, "PreferredName")  You many hide both these fields under banner by using "bring to front" functionality. Add Set as Draft button Add rule and set on 'Save as Draft' and 'Save and Submit' buttons and set following condit

An AD Service the offers the following features: • CreateUser • UpdateUser • ReadUser • GetUsers • Move User OU • Add User To Groups • Remove User from Groups • Search User by SubString • Search Groups By SubString This is release one of the service which as per the ‘Project Overview’ provides the ability to have more advanced Active Directory integration focused around Active Directory Users. In the Zip file for the project is the document Last version: "ActiveDirectoryDynamicSO 1.0.0.8.zip" generated the 3 June 2022.

Hello all,anyone knows if there is any way how to create kind of a task in CA for instance to use PurgeWorkflowData with certain parameters, which would run regularly instead of having to go to CA, set the filter Run the query and purge it manually? Or anyone knows how to use NWAdmin.exe with filter parameters in powershell script? All I so far found is the creation of the batch files and then windows tasks out of it, which I find quite cubersome for such important task to do. I would expect this option to be configurable in CA.. Thanx for any kinda reply. Jan

I need to create a table in Nintex Form with an easy calculation of multiplication when a user enters a field.Can you please help in how to create a table in Nintex and add calculation. Below is the table:If the user can enter number of hours and the Total dollar value and hours can be calculated in the table. Role hours  rate   total  Product Managers 4 $145.00 $580.00 Product Owners 5 $70.00 $350.00 Scrum Master 2 $40.00 $80.00 Business Analyst 6 $98.00 $588.00 IT Clinical Engineering  0 $90.00 $0.00 Quality Assurance 3 $22.00 $66.00 IT Engineering 200 $90.00 $18,000.00 Warranty support 2 $98.00 $196.00 Total      

Converts an ADO query into an excel file and returns it to the user

 Symptoms  User is able to submit a task action from SmartForms successfully, but the action does not commit. The task event does not complete and the workflow does not move forward. The following error is logged: ""76350792","2016-11-22 13:17:35","Error","General","1","GeneralErrorMessage","K2Worker.Action","1 26033 Worklist item 1418_11 Not Open for K2:DENALLIXAdministrator at 127.0.0.1:97554","","","K2PROD:C:Program Files (x86)K2 blackpearlHost ServerBin","76350792","ee665d0b960244729f4ef86f774a2a53","""  Diagnoses  Exporting the result from the [Server].[Actioner] table as a .csv file, there looks be be trailing spaces of the accounts in question:   ID,ActionerName,ActionerType,Status 1,K2:DENALLIXAdministrator ,1,NULL   The destination set for this client event is using a SmartObject result from a SQL table (varchar SQL type) that return the username in the format 'DENALLIXAdministrator'. It would appear that this data may have had trailing spaces. This issue can be replicated by

Hi,   Any idea why can't call the webservice? it prompt error"Unexpected error occurred while making the request".        

QUESTIONWhat considerations should be made when upgrading to a later version of Nintex for SharePoint?ANSWEREnsure the destination environment has the same content.To prevent upgrade issues from third-party tools, read this first: Nintex Workflow Backup and Restore. Nintex requires that the destination environment contain the same content as the source environment: GUIDs, content types and directory structure. Third-party tools can change this content, causing issues during upgrade. Use the Database Attach method for migration.The primary supported migration method for full content migration is the Database Attach method. For more information, see Nintex Workflow Backup and Restore. This method ensures migration of all content and ensures that running workflows continue. Any other method requires running workflows to cease during migration.Migrate to the next immediate version before migrating to the desired version. Migrating directly from Nintex for SharePoint 2007 to Nintex for Shar

Learn what you need to know when upgrading to a later version of Nintex for SharePoint.For example, you may want to upgrade from Nintex for SharePoint 2013 to Nintex for SharePoint 2016.  1) Make sure the destination environment has the same content. Are you using third-party tools?To prevent upgrade issues from third-party tools, read this first: Nintex Workflow Backup and Restore. Nintex requires that the destination environment (the environment you are migrating to) contains the same content as the source environment: GUIDs, content types and directory structure. Third-party tools can change this content, causing issues during upgrade.  2) Use the Database Attach method for migration.The primary supported migration method for full content migration is the Database Attach method (see Nintex Workflow Backup and Restore). As long as that process is followed to a tee, all of your content should be migrated. Use the Database Attach method to ensure that running workflows continue. Any ot

I am new to Nintex and I need a bit of help related to the default value of a PeoplePicker field.My form has a checkbox Yes/No for delegation (screenshot 1). If it is checked (screenshot 2) I set up a rule (screenshot 4) to show another section that has a PeoplePicker for choosing the person for who we are filling the form (screenshot 3).This PeoplePicker as the CurrentUser set as default (screenshot 5) because even if delegation is not checked I still need the same information to connect to my list columns.Everything works fine except in the eventual case if someone checks delegation, chooses another person in the PeoplePicker but then regrets it and unchecks delegation. In this not probable but possible case, the PeoplePicker doesn't reset to the default CurrentUser.I would prefer a solution using the rules or formulas but I am not against using only JS. ScreenshotsForm when a new item is created (no delegation is the default)When delegation is checkedChose another person instead of

You can use the following SQL query to find workflows inside the Nintex Content database based on their state. Simply modify the "WHERE" argument to look for workflows in other states. SELECT DISTINCT i.workflowname, i.webid, i.siteid, i.listid, p.CurrentActivityTitle, p.TimeStampFROM dbo.workflowinstance i  inner join WorkflowProgress P  on I.InstanceID = P.InstanceIDWHERE i.State = '2' Here are the different states you can query:when 2 then 'Running'when 4 then 'Completed'when 8 then 'Cancelled'when 64 then 'Error' 

 Symptoms Is there any documentation related to the amount of load a K2 server can handle? Diagnoses There is no "standard" amount of capacity needed. This will vary on the type of process, amount of processes, and numerous other factors. Resolution Two helpful documents for planning are:> Performance and Capacity Planning - http://coe.k2.com/files/9035> K2 blackpearl Performance Testing - http://help.k2.com/files/1630  

 Symptoms  When viewing the SmartForms Debug logging and the Developer tools in IE for this form we see the following errors in a vast amount:Developer Tools IE Error:[error] Property of control could not be set: GetProperty. Error message: Unable to get property 'SFCAreaItem' of undefined or null reference (Helper: executeControlFunction) Unable to get property 'SFCAreaItem' of undefined or null referenceTypeError: Unable to get property 'SFCAreaItem' of undefined or null reference at getProperty (http://[SMARTFORMS URL]/Runtime/Bundles/Js/RT?v=IfuEr25ODjKqVi0o8cBgfoyPwj3DBETjfmQlMxvt-y41andamp_v=4.15060.15300.4:263:1074) at executeControlFunction (http://[SMARTFORMS URL]/Runtime/Bundles/Js/RT?v=IfuEr25ODjKqVi0o8cBgfoyPwj3DBETjfmQlMxvt-y41andamp_v=4.15060.15300.4:223:15034) at setTabIndexesToNone (http://[SMARTFORMS URL]/Runtime/Bundles/Js/RT?v=IfuEr25ODjKqVi0o8cBgfoyPwj3DBETjfmQlMxvt-y41andamp_v=4.15060.15300.4:223:1623) at SourceCode.Forms.Widget.PopupWindow._create (http://[SMARTFO