Archive

So there is a way to manually import a excel sheet into a SP list, but is there a way of doing this automatically.So - Excel documents are stored in document library, then nintex workflow is run to pull the data in to the relevant columns on a existing list.I have managed to use query excel services to pull one column correctly A2:A5, but as soon as I try and capture the next column A2:B5 all the results (variables) from column 1 and 2 end up in the first column.Any ideas? Vadim Tabakman any ideas?FYI- I want a way where scripts are not used.When trying some WF-I received :The error:Coercion Failed: Unable to transform the input lookup data into the requested typeThanks

Fancy Forms with NintexI have a Flexi Task running on a list Item, with Delegation and everything is fine. Further when the Flexi task gets status User input needed a Task User input will start with the question forwarded, naturally delegation is activated. Everything work fine and as expected when using SharePoint Forms.After all the Tests, I started building the Nintex Forms. In the Flexi Task I could still use the delegation functionality. Coming to the user input Task I could not find any delegation link in the Form nor did I find anything similar to delegation in the toolbar!Am I missing something? Should I add any extra Tools to get that functionality? I just want to allow Delegation in User input Tasks.Does anybody has a clue?

Hi everyoneI have a workflow which creates metadata from the filename.  This is mostly simple just using Build String and counting characters.  I have a challenge though when trying to extract a customer name from the file name, for example: "Invoice 11111117 for Order 1011111 for Customer ACME International  Flavours Ltd.pdf" - this is due to customer names obviously not all being the same length so I cannot just count characters like I would to get the Invoice Number or Order Number as these are always fixed lengths at the same place in the file name.Is there a way to get the customer name out, even though the character counts would be different for almost every file name?

There is a workflow which reads rows from Excel, process data and insert items into a SharePoint list. The workflow runs as expected for lesser number of rows in excel(works well for 10,16,108, 112 rows). But, when the number of rows increases (we tested it for 250), the workflow never terminates its instance. It goes till the last action in the workflow and repeats itself again from the first action.There are loops in the workflow to read cells in excel and convert them to SOAP XMLs. All the excel data is processed and is inserted into SharePoint list using a single web service (lists.asmx) call. The workflow comes out of all the loops and executes the actions outside the loops, like creating items in the list, sending notifications, but it never terminates and unfortunately re-execute the actions like reading Excel, creating SOAPs and adding items into SharePoint list.

Hi, I'm trying to configure the Workflow Chart Viewer web part to show data from Approver Perfomance Statistics chart. I've tried several different configuration (chart type, column to use, from all to just Approver, etc..) but all I get is a text error: "Columns selected must be numerical. Check your column settings" Is there any guide or instruction on how to configure this webpart? Thank you Giacomo

Dear Community, currently I am working on a status indication column like a "traffic light" for a Sharepoint list that is able to display a green/yellow/red light depending on the fulfillment of a task. I've found very interesting blogs from users which are doing quite similar things via  https://www.abelsolutions.com/creating-a-simple-kpi-column-in-sharepoint-2013-list-views-using-js-link/ Ampelfunktion für Aufgabenlisten hinzufügen – Nico Thiemer – SharePoint Enthusiast seit 2001 My requirements for this status indication are a bit more demanding - the column logic has to check two things at the same time. First, how much time is left until a deadline (4months, 3months, ..., down to 1month). Second, what is the fulfillment status task considering the time left until deadline. This means that a task fulfillment of 10% and 4months left would i.e. result in a yellow light, whereas 10% and 3 months left would result in a red light. So it is basically a comparison of time until deadline a

Good day everyone. I have list lookup on the left side, an add item label button on the middle, and a multiline text on the right side.My problem is, users will have a hard time configuring the multiline since I want them to be able to delete the items there easily. I want my multiline text (hostname/local zone) to have a list behavior where they can select items. Is there any workaround or a way in javascript to automatically highlight a row in multiline once it is clicked?

HiHaving weird sporadic issues whereby the workflow has run against an item but the status column is blank.  If I view workflow history against the item I can see one or more Completed workflows that have run:When I look at the workflow history diagram I can see all actions are green and processed but the status is blank:This is really preventing me being able to report on items where the workflow hasn't run!Has anyone seen this before or know how to fix it?Marian Hatala‌ Andrew Glasser‌ Chris Ben‌ Eric Harris‌Your very frustrated friend, Cassy

HiThe approval section of the workflow was working perfectly until:1.  I added approval required in Versioning Settings of the Workflows Task list and then removed the setting.2. Deleted a Status choice column.3.  All permission groups were working previously.I am not getting the error that Something has gone wrong when trying to approve any task.I am assuming I need to reset the Workflows Task List to the default one without deleting the customised Nintex Form that I have created. You help would be greatly appreciated.RegardsRenee

This simple utility allows you to easily change the GUID of an existing service instance. When you create a SmartObject that uses a service instance, the SmartObject binds to the GUID of the service instance, not the name. When you move to another environment, if the service instance is created dynamically or you don’t specify a GUID when you register it, a GUID will be generated for you. When the GUIDs don’t match SmartObject deployment will fail with “Deploy smartobjects: Tas

I am being really dull and can't figure out how to achieve this.Warning newbie!!In our Nintex environment, I don't have a lot of permissions or the ability to do things like write to databases etc so I am trying to come out with a hybrid solution that works within the confines of what I am allowed to do:-The solution I am trying to build:- Training Attendance Register formI am breaking it into two parts as I need to do reporting ...Form 1: Training Load Form. The trainer will load the training form with their details ie. name of trainer (people/group field), date of training, time, type of training etc. There is also an an attendees field (people or groups - multiple selections allowed) where the trainer can add everyone who has attended this training.A workflow on this form, will then take the newly created training event and for each attendee selected in the Load form, will create in a separate list , "My Training Records", a single list item with all the information listed in the lo

Hi everyoneI'm trying to build an email answer with Nintex by using a table and I meet two small problems:So I built a string for my talbe:<table cellpadding"22 style=border=collapse; border=1px solid #d9d9d9; font=family:"Helvetica","sans-serif";"><thead><th bgcolor="#F2F2F2" align="center" style ='font-size:11.0pt;font-family:"Helvetica";"sans-serif";color:#1E90FF; font-weight:bold'>Name</th><th bgcolor="#F2F2F2" align="center" style ='font-size:11.0pt;font-family:"Helvetica";"sans-serif";color:#1E90FF; font-weight:bold'>Title</th><th bgcolor="#F2F2F2" align="center" style ='font-size:11.0pt;font-family:"Helvetica";"sans-serif";color:#1E90FF; font-weight:bold'>Output</th><th bgcolor="#F2F2F2" align="center" style ='font-size:11.0pt;font-family:"Helvetica";"sans-serif";color:#1E90FF; font-weight:bold'>Comment</th><th bgcolor="#F2F2F2" align="center" style ='font-size:11.0pt;font-family:"Helvetica";"sans-serif";color:#1E90F

Hello EveryoneI am currently working on Nintex Form where I want to reset Multi select list lookup control. On the form I have a Reset button. When user clicks Reset button I have to reset all controls on the form. I can reset all the controls using JavaScript but not sure how do I go about resetting multi-select List Lookup. I came across an example where using JavaScript we can set the default value for the multi-select list lookup but in my case I would need to do the reverse of that. https://community.nintex.com/thread/10276 Thank you in advance for your help.

HiI have a SharePoint list with a Nintex workflow which tests a number of conditions.  I want to test whether the new item or the edited item is a duplication of a previous entry.  I have created the following Query list action using a collection which lists all the entries based on Salary ID, Full Name and Webinar Name.  I can see them listed when it runs but am not sure how to progress from here. If the item is a duplicate, I want it to have the status of wait list so that the administrator can accept or reject the item. I know that I need a For Each with a Target and an index etc but am not sure how to test whether one equals the other items:Not sure where to go from here.

Hi, Is there any way to create sub-tasks of a task that has any number of bullet points in it's description?  There should be sub-task for every bullet point.  Number of bullets can vary. Thanks.

I'm trying to set up some rules to hide a List View control when nothing is showing up in it.  (Specifically, when nothing is showing up in the view set up on the library referenced in the List View control settings.)  I can't find any good way to target it, though.  I tried setting a rule on the control to hide the control if isNullOrEmpty({Self}), but I found that that rule hides the entire control no matter what.Is there any way to set up rules affecting List View controls?  It seems like you can't name them or target their properties.  Any ideas?

 Symptoms Issue:The client migrated from 4.6.11 - 4.7. When they try to create a new package, they get the following errors in PandD and Smartforms:"[Form Name]' Form is referencing the 'Control with Guid: [GUID] that could not be found" Diagnoses Resolution:The developers identified an issue in the product, and fixed the issue in the Cumulative Update (CU) and Fix Pack (FP7). Resolution Resolution:The developers identified an issue in the product, and fixed the issue in the Cumulative Update (CU) and Fix Pack (FP7). 

I have a workflow with a state machine governing an approval process. As it was becoming too large I split it out into separate workflows and call those child workflows from within the branches of the state machine. I have 4 branches with child workflows, 3 of which behave perfectly. The 4th however is behaving very strangely. When the workflow runs, initiated by the start workflow action, the single flexi task that is contained within it is created 4 times! I have added logging before the task and that too is shown 4 times. There are no loops in my workflow, it's a simple linear process, do some stuff before the task, create the task and do some stuff afterwards. The start workflow action is configured to wait until the workflow finishes before progressing and not to start if already running. What I have also observed is that if I run the child workflow manually it behaves as expected, a single task is created...it is only when started with Start a Workflow that it behaves this way. N

Hi,I have a list named Personnel which has a people picker filed that can be multiple person. There is a second list named MTarget, Dept and Position are lookup fileds to the Personnel listI have a workflow on MTarget, this workflow runs on item creation and has to create an item per person in a third list.the workflow does a query list to Personnel, filters based on Dept and Position, returns Personnel, then I put this personnel in a Multipleline of text, split with ";" and set the result to a collection variable: But I got this on running workflow:this is the foreach action:I used both string and peoplepicker type for varPerson and got the same error!Ant thoughts would be appreciated!

I'm having a bizarre issue with the Change Content Type control.I have a library with multiple Content Types. When I use the OOTB SharePoint form I have no issue.The minute I try to add a nintex form to the default content type and apply it, I get the following problem:-Upload a doc, try to change the content type from the drop down. Fill out all required metadata. Click Save.-Content Type change is not applied, still says it's the default content type (top one in the list).I have run dozens of scenarios and this always breaks when I try to add a simple nintex form, even if it's the default layout without any changes except adding the content type selector control.Any ideas?

Is there a chance to download (or buy) a Nintex for Sharepoint (concrete the on premise version, if that's important)handbook? Preferably in german?I would like to set up and use workflows and am currently rather overwhelmed.Best regardsChristiane

I have a control for the current date. I also have a control for an activation date. I would like the activation date to auto-populate with a date at least three days in the future of the current date. Can I do this on a responsive form?Thank you.

I have a form with a lot of validation based on what item is selected from a dropdown.  An issue I just discovered was that even though I have the NotValidIfNullOrEmpty the data can still accepted (Saved) if a space is "entered" - I go into the field and physically enter a space. What is the best way to handle that problem? I tried adding on to the statement in the attached graphic: OR IF Field = " " THEN it would be invalid, but I was able to save the item.Update 1: I am now trying to work with the Regular Expression. I am getting closer but still not the desired output: I entered this expression:^.*(?=.*d)(?=.*[a-zA-Z]).*$It works to some extent BUT I can still enter a blank space and the form saves

Hi,I have a mandatory Text field with the following validation rule formula.Visitor1=='' && (isNullOrEmpty(trim((Visitor1FirstName))||Visitor1FirstName =='') && (Visitor1LastName!='' || Visitor1Organisation!='')The validation should work like this: if the drop down (Visitor1) is not selected then Visitor1FirstName and Visitor1LastName and Visitor1Organisation should not be empty. [See below Image]It work perfectly, if the these three fields were empty when Visitor1 is not selected. However, if a space was entered to any of these fields, somehow it ticketed the blank space as a value and bypass the validation.So how to validate the blank or whitespace in Nintex form Text field?Thanks,Emily

Ok, here is a weird one.  I have a text column that contains an employee number.  On my form I set the value of this column using a List Lookup control.  This is so that it is not truly a list lookup column, but the possible entries are restricted to the list of available employees.  So far everything is working great.  The problem comes in whenever I try to create or update an item using a workflow.  I am using Nintex Workflow and Forms 2010. If I upload the document to the library and use the item form to update the fields, then the value is visible on the form when viewing the document properties. When updating Employee Number using the Nintex Form When updating Employee Number using a workflow I have tried to discover if there was any extra information being stored in the field to make it link properly on the form but there isn't anything.  No ID or anything like that.  Not sure how to set a field like this and still have the value on the form.