Nintex Automation K2

Looking for what the difference is between the set and populated events of the picker control in 4.6.11/4.7, and the order of events in the lifecycle of the control (for example, I understand the populated event occurs when resolving is completed, but I don't know where set fits in). Thanks and best,Tony

I didn't see it in the forums but is anyone using Microsoft Access for a Smartobject?

Are there limits or restrictions on how many columns a list view can have? Running into some behavior on a list view populating from a Stored Procedure (35 columns) that the list will take forever to load and open up.  Sometimes the view will open and sometimes the view will error out and not load at all. If the stored procedure / smartobject is updated with new column - the view seems to error out and then I'm forced to create a new view / expressions / functionality and add it to the form again. This does not seem pratical.  Basic function I need this for is because I need to export the data into an excel file.Anybody else having this behavior or suggestions.

We all know K2 can create SmartObjects based on existing schema in a database or service. I'm wondering if it can work the other way around. Can I: 1. Set up a SQL Server service instance in K2 and connect it to a database2. Define a SmartObject in K2 and have that SO definition create a table inside the database that can then be updated and queried as necessary Is this possible? I've looked at the documentation but couldn't find an answer; if I missed it, a link to the relevant docs would be much appreciated. Thanks!

I want to access information of active, stopped ,error status of my workflow under process detail inside workflow on management console. Doesn’t anyone know where k2 stores those information? For example instances : ID ,Folio, start data, status ,originator, version Please find from attachment screen shot process detail from k2 management console

I'm using K2 Five in SP2016 and would like to know how to set Rules in SmartForm to check user belongs to a particular SP Group to show/hide controls on form.I found this article (https://community.k2.com/t5/K2-blackpearl/Check-User-in-a-SP2013-Group/td-p/91065) but I have no idea how to use OOTB smartobject 'SharePoint Integration Helper Methods'.Much greatly appreciated your help!

Hi, Anyone know what rights and how to set them for allowing end users to package and deploy their own solutions from a dev server to a live server? Got client tools installed, so package and deployment can be run.The create package option was greyed out, so i set Export rights for the user and also added them to the Package and deployment Role in management. Now getting another message - insuffieicent rights detected, unbale to continue. You must have view rights to all objects in the system to perform packaging and deployment activities. Where do i set the above, but without giving the user too much admin rights? Is their a bare minimum i can give to allow the user to do P&D without them messing anything up? Thanks 

Hi, i was trying to change the connection string with an exchange email, but, when I was updating the String Table in Environments it give me an error.Now i am getting this error inside Managament site. 

When I route a work item to a specific user, it should get removed from all others queue. So that assigned person will work on the item.For example, workitem1 can be viewed by User A, User B and User C. When A assign it to C, the  work item should get disappear from queue of User A & B.How do we set this ?

Hello All,I have a workflow with a loop. I want to count the iterations of the loop and report the number of times the loop ran. I have a variable in my workflow to track the count. I can set an explicit value for my variable. But I am not able to set the value using a simple additions (e.g.  Count = Count + 1). I've even tried assigning the current count to another variable and then adding 1 to the other variable without success.e.g. Count2 = CountCount = Count2 + 1 Is there a trick to doing simple math and assinging the result to a variable in a workflow? Thanks,-tomas  

Hello, I am trying to sum up the values I selected in my picker control.This picker control is supposed to allow my end user to select multiple part numbers, for each of these part numbers there is a value associated with it.Thus I want to sum up the values selected in this picker control but am running into issues creating an expression to do this.Attached is a screenshot of the picker control where you can see the part number and the number associated with it.The value of the current customer demand should be 102 since I selected those two parts but it just is returned as 0.

I would like to setup security within a form.  I have a button control when clicked it shows an editable list view. i would only like certain people that are members of an AD group to be able to click and show the viewis this posisble? or a different method? i don't want to have to create a second form with the editable list view if possible

Does anybody have suggestions on how to change the hyperlink color on a list view?  We created a custom form template but that didn't work.   I'm thinking that particular view has different css to change but I'm not sure where. Thank you in advance.

Hello All,I'm trying to package a workflow but the Package and Deployment tools can't see the workflow. It sees another workflow, but not the one I've been developing. I'm packaging on a DEV server and I'm logged in as the service account to edit/publish the package. The account has the Package/Deployment Role in the management console. The permissions seem the same for the two workflows. So I'm puzzled why I can only see one workflow. Are there filesystem or other permissions that I need to check in order for the P&D tool to see my workflow? Thanks,-tomas

Hello, Yet another question from me. Is there a way to force Workflow into error when it runs out of options during the runtime? Currently when my WFs get into a situation they cant seem to resolve ( Say none of the split conditions apply, or there is no outgoing path) They simply mark themselves as Completed. That seems super wrong. I would like WFs to throw errors instead if they end outside of specified end steps. Is that possible ? And one more question. Is it possible to somehow configure WF to send an email when it encounters an error ? Currently we have to check for errors manually and that is annoying. Thank you and have a nice day 

Hi fellow travelers -  We are starting to outgrow SharePoint and are considering using MS SQL Server as a more capable data source. We're looking at projects with hundreds of thousands of records at the least. What we're wondering is, should we create new SQL databases inside our existing server that hosts the K2 application database, or stand up an entirely new server and database in order to avoid bogging down that server?  We have an on-prem K2 Five installation, with an app server running Designer/Management, and a separate database server. On 5.1 right now but will be upgrading to K2 5.2 soon. We have about 45,000 overall users but our concurrent usage is probably in the tens or hundreds at any given time. Thanks for your help!

Hello All,I'm trying to enable Workflow REST API. I've gone to the Management tool and enabled the Workflow REST API there. I'm presented with a Swagger URL and a Base URL and both appear to be correct. But then I click the icon to view the  Swagger information, I get this error message:{  "Message": "The Workflow API in K2 has been disabled, please use K2 Management to enable it."} Is there something else that needs to be done (aside from flipping the switch in the Management interface)?Are there other pre-requisites?Did we miss a step in the setup process? Any insights are appreciated. Thank you,-tomas vera 

In the legacy workflow designer, I created an Expression to build a SharePoint document link that--when clicked--opened a Word document in the browser (versus downloading it and opening it in Word). I'm rebuilding the workflow now using the modern designer and can't figure out how to create a similar expression. Here's what my expression looks like in the legacy designer: Document Link: Left(Document ID (Link to Document), LengthToComma)LengthToComma: Find(Document ID (Link to Document), ,) -1 I tried setting variables and can get parts of it, but I can't get the LengthToComma formula to work with the "-1" bit at the end. Kept getting character mismatch-type errors. I couldn't find a way to do expressions in the same way in the new workflow designer.  Anyone have any thoughts?

Hi, Scenario:I have a SmartBox SmartObject which is used to store customer records. Currently, I am using the ID field as a displayable reference number, so that the User can keep track of a particular record during a Workflow etc.This works well in basic terms, as by default, K2 sets this field as an Autonumber (i.e. 1, 2, 3, ....). So will be unique (for that SmartObject). Issue:The reference is not unique across all smartobjects, a prefix is required within the reference number so that the User knows which type of record they are dealing with. Requirement:Amend the format of the Reference number.The Reference Number should be prefixed and be a fixed number of digits. Examples: (FA00001, FA00002, FA00111). Best Practice Query:How would most people go about generating the Reference Number?  Idea:Would you get the ID back after the record has been created, then somehow generate the Reference Number using a Rule prehaps (?), then do an update on the Row storing the generated reference n

Hi, I already have logic to check if a User is on a Mobile Device (using an advanced condition against User Agent). This may sound far fetched, but is it possible to also check if the User is Offline? To clarify, the scenario for this would be if the user is using the K2 Workspace App and is in Offline Mode (or has no connectivity). PowerApps has this property exposed, just wondering if K2 does!  Thanks :) 

Hi,We have a new install of K2 5 (not an upgrade) and I was suprised at how few workflow actions there were until I noticed in the older version of K2 they had many Workflow wizards within the Workflow designer that provided a number of useful actions but we do not have these in our install?  Have they been withdrwan altogether or do we need to install an add on or similar? Here are the main ones we seem to be missing that we would utilise: Documents Set WizardGroups Wizard UsersWizard Active DirectoryWizard Exchange WizardWord Document WizardAll Permission Actions (On libraries, Lists and documents) A particular scenario I am trying to achieve is to convert a word document to a PDF and have it moved to a different library location, how could this be achieved without the ‘Word Document’ wizard which includes this action on the old version? Thanking anyone in advance that could throw me some light (total newbie sorry!).Julie :-)

Hello, Is there any option to restrict access to Workspace in K2 Five? I found the option for blocking certains users from accessing Designer (Management is blocked for everone by default), but can we change permissions just for Workspace?I didn't find any satisfying answer to this question. Przemek

Hello, Can anyone help me find out how to change Environment Variable values in a K2 Cloud environment, since i do not see the "Environments" node in the Managament Site as it exists in K2 Five?

Hi, I am a  complete newbie and just working through the K2 5 tutorials, but on all 'task' email alerts the smart actions do not appear as hyperlinks. The 'worklist item' does work OK if I leave it at the default one that appears on the initial email, although if I added this manually to the email via the context list then that doesn't link either. I am read a similiar thread in regard to this issue, but that thread seems to be about the links not performing the actions after being clicked, I can't get mine to hyperlink to start with, any ideas? Heres the email output:From: K2 BlackPearl Server (test) Sent: 26 July 20*personal details removed*:48 To: Julie Bird <*personal details removed*> Subject: Document Submitted for your approval: Dummy 1.docx Dear Julie Bird, A document is awaiting your approval. Please review the attached documenty and indicate whether your approval decision in one of the following ways Use the following link to open the worklist item: Click to open workli