Archive

I have SQL look up object that find list of names in a sql database and that works fine.  I want this field to be required but I found a bug where a user can pick a name and then go back and pick default blank user.  It will by pass validation on the field and I added validation in the rules and both of them didn't work making the field required.

In a SharePoint 2013 list there are 15 priority items. Each item is assigned a 'priority number' from 1 - 15. Sometimes there are only 10 items that are active in the list.    When an item, for example priority number 5, is 'Archived' (choice column 'yes' or 'no'), it is no longer counted in the priority order (it still exists in the list and has a priority number, but is no longer displayed on most views). I am trying to update all active items in the list ('Archive' equals 'no') to updated their priority number. Number 6 becomes number 5, number 7 becomes number 6, and so on. So that there is always Priority 1-10, without any repeats of numbers (no use of a number twice).   How do I loop through all active items in the list and update their priority number?

Hello,   I am creating a large checklist that when the Yes or NA has been selected I need it to then populate a Calculated value on the form with the date/time and the person who updated the column.  I would then like to make that completed Yes/NA checklist item not editable once it is populated and the form is saved.   I tried many variations and here is the latest calculated value:  "isNullOrEmpty(APP ADMINS: Disable XXXX User Login);Current User" but get the following results.   I am new to formulas and can't seem to get them right in Nintex.  Ultimately I would like it to say:  "Completed on 7/14/2020 11:02 AM by John Smith"   Then the final part of my question can I keep the Yes/NA column from being edited again once it is completed?   Thank you.   Devon

In workflow A I would like to setup a a schedule for workflow B to run on the first day of the quarter.   This thread gives me a perfectly adequate way to compute the first day of the next quarter.  However, I don't know where to implement the formula in the workflow.  The "Calculate Date" and "Math Operation" blocks are both extremely simplistic.   How can I carry out a complex date computation that I can then use for scheduling a workflow?   I'm on SP 2013 with Nintex 2013.

hi There,    i am trying to get some documents to move frequently to move to another site collection. I tried using list workflow using Copy to SharePoint, it only copy the first item but not others. Copy Item action only picks up 1 documents. is there another action i can used to copy multiple documents from one site collection to another?     Please advise? 

Apologies in advance if this is a simple question but I'm really struggling to find resources on how to do this in responsive forms.    In my list I have two types of columns: Col1 is a choice column, the options are Yes, No, N/A Col2 is a multiple lines of text column.   In the responsive Nintex form, I want the Col2 control to be hidden, unless the user selects a certain value in the Col1 control. Sometimes, the value will be Yes, other times it will be No. Then Col2 control should be visible.   Can anyone help?

Workflow to get hyperlink data in body field of an email enabled announcement library to body field in a list   Ok I have got an email enabled Announcement library. I have survey gizmo form that auto sends in an email as well as a hyperlink to an excel spread sheet, to the "Announcement Library".   I need to figure out how to extract the excel to a document library and than parse to a SharePoint list for easy search by the department.    I cannot change the survey gizmo to only have one item on the form, ie the excel with multiply items. Fire wall will not allow outside venders to access and fill out Nintex form therefore survey gizmo is used to outside venders.  ie we need to parse information received into a list if a excel link is in the form and save the form if only one item is on the form ie no excel. I hope I have explained that well enough.   Any Ideas would be greatly appreciated. I have been working the issue for about 6 months now.

We have a list with 2 colums Company name VAT number We also have a library where we want to create a Document Set for each company. My workflow does the following Query List For each Create item It works fine to create the Document Sets for each company name. But I would also need the column with the VAT numbers. Anyone having a clue how to do that ? 

I'm using Nintex for SP 2016 and current Chrome browser for a responsive form.  I have a Rich Text Box control with text, a table, and references in it, but when I try to make changes to the control, the configuration panel is blank.   If it makes any difference, the RTB is nested in a Panel control and the control shows up fine in a published form.   The control as it shows in the Nintex Forms Designer:   When I try to edit the control, it's blank: I've tried closing and re-opening the form, closing and re-opening the browser, and clearing the browser cache.  Anything else I should try?   Thank you, Anneliese

I have a list (task with calendar) that will serve as a class signup sheet. Since we're limiting the classes to 20 people, I am trying to write a workflow that is based on the following:  - For any date (class), if the number of people signed up is 20, you can no longer sign up for that date.    I'm very flexible on the structure of the list as well - We can change it to make it work.  However, even with this, I'm having a hard time wrapping my head around the workflow and list, and how to make this work.   Any ideas?

Looking for a way tu run a workflow only on the last item created. Multiple items get created at the same time on my list triggered by a different workflow and once they are created on the list I have a workflow that will export all list items into csv.The problem I’m having is that when items are created the workflow runs for each of them and I have multiple csv files created. I’m trying to find a way for the workflow to wait until the last item is created and then run the workflow on that last item. The list is a temporary list after items are exported in csv files all items are deleted.any help is appreciated 

We are on to a older version of Nintex Workflow 2013 (3.2.2.10) with SQL server 2012 on to all our environments and trying to upgrade to the latest, but the release notes for Nintex Workflow 2013 points out SQL Database as SQL Server 2014.   Product version: 3.5.2.0 Database version: 3.2.5.2 Release date: 3 March 2020 SP Service Pack/CU: November 2019 SQL Database: SQL Server 2014 To upgrade to the latest version is it mandatory to have SQL Server 2014 and what are the other prerequisites. Currently we are on "3.2.2.10" Product version for Nintex Workflow 2013.  Any help is greatly appreciated. Thanks, Nirmala

Hello,   We have 5 nintex WFs where most of them (4/5) have the Call Web Service action (get user collection from group) under the same credentials/configuration. However, we get error 401 just in one of the workflows.   The weird thing is, when using the "Test Connection" button in the action returns a "OK" message, and the "Refresh" button in the action returns the list of available web services to populate and be selected. It is only when the actual call is attempted that it returns with a (401) Unauthorized response.   Also, we have tried opening the web service on the server. The behaviour is exactly the same as on the desktop. We can browse to the web service definition but any time we try to access it via workflow we got unauthorised.   Finally, we tried disabling Loopbackcheck (in both servers) and configuring a BackConnectionHostNames entry in the registry App Server. However, the problem persists.   Configuration:   Enviroment: Sharepoint Server 2016 on Premise within minRole

Hi! I have a responsive form I'm building and am looking for the functionality so that once the user keyed in a submission specific identifier (title or number), is it possible to, real-time, determine if there's a matching submission within the list and if so, return a corresponding value from that found item?    Example: I key in "Offer1234" there's a query in the background to find that match and if true, it returns the created date for that prior item.   I know I can hookup a workflow, but that can only run when an item is added...I'm hoping for a more responsive result.   Thank you for your time!

Hi, I am a beginner with nintex workflow. Can anyone help me to capture the first modification date and time of a list? Once the first modification date and time are captured the workflow has to stopped. Means the next modification date does not require to capture.   Thanks in advance for your kind help.

I have one requirement where i have to save my nintex form data to external SQL server database. Is this possible in nintex with workflow or execute SQL or by other means.   Thanks in advance.

Within my Workflow, I utilize a Query List action to get a set of records to obtain the values for a 'total' field and put them into a collection. Then use a For Each action.  The values are a string in currency format; ie:  $32,000.00.  I need to convert it to a number so that I can perform a calculation.When I utilize the Convert Value action within the For Each action, I get an error:  Value '$32,000.00' is not compatible with the selected output variable type Number (double). I want to convert it to a number and keep adding it for each item within the collection to get the grand total. Can someone offer some assistance?

I have a Document Set content type library in SharePoint with Email Notification workflow to attach the document set files in an email.  The ZIP attachment has the documents (excel files) of the document set, File Folder and XML Documents.   Question - Is it possible to send only the excel files without the file folder and XML files?   Thanks!

I created a flexi task which is assigned to a group (multiple users) In the workflow web part .. there is one user who is not seeing all pending tasks for him .. while other users in the group can see.. why? (Note: I am ticking the option of create individual task for each  user inside the flexi task)

I have a unique user ID I'm pulling into SharePoint via an Alteryx query. My list item in SharePoint that it's populating is formatted as a Single line of text. I need to look up either the Name and/or Email of that user but every solution I find needs the list item to have a People or Group format. SharePoint won't let me put the user ID in my list with that format. I found a potential solution using LDAP but my Nintex App in SharePoint didn't have that as an available Action. HELP! I'm stuck 😞

Hi All,   I am very new to Nintex workflows, so most probably my situation can be solved pretty easily although unfortunately I do not find the solution.   I am trying to make a List B updated by List A being maintained.   I have created a workflow with a copy action item in List A, which is started when item created, therefore the SAP ID appears in List B. This works fine (I am using it just for the create item option, as when modifying, it keeps duplicating every change - therefore I've created another workflow, to update)     Then I have created a second workflow, which updates List B when related detailes (based on ID Lookup) are maintained in List A. (workflow starts by modifying item) Unfortunately the below update item workflow keeps running on error.   Can you please help me with screenshots?   Thank you,

Hi all, I have a Problem with the validation rule on my Multi-line textbox. In the picture below you can see two multi line textboxes the first one is a list column, the second one is a multi line textbox out of the General section. Both of them has added a rule with the same condition.    Why does the rule not work on the multilinetextbox from the list column?      

Hi,the title really says it all. I have a collection of all the Task Title of the Workflow task list.I want them to all stand under each other in a mail.Maybe a workaround? Thanks!!

In my form, I want a People field to default to CurrentUser if it is being filled out by the employee but default to blank if it is filled out by a manager (on behalf of the employee). I am passing a query string of 'E' or 'M' to a text field (EmpType) when the form is opened. I know this piece is working because I created a calculated field and set the default value as fn-If(EmpType=='E', 'yes', 'no') and tested with both values.   It seems I should be able to go into the formula builder for the People field's default value and enter something like: fn-If(EmpType == 'E', CurrentUser, ''), where I'm using the empty quotes at the end to signify a null value, but I haven't gotten anything to work. In fact, just as a test, I used: fn-If(EmpType == 'E', CurrentUser, CurrentUser), in which case it should have displayed CurrentUser regardless of whether it evaluated to true or false, but it didn't.   So, is it possible to use fn-If (or any other method of evaluating a condition) to set a Peo

It was working properly with the following script.  Any solution to resolve this? //hide ribbon NWF$("#s4-ribbonrow").hide();