Nintex for SharePoint

We changed the DB Compat mode on our content databases post upgrade and migration. Moved databases from SQL2016 to SQL2019 and upgraded to SharePoint 2019. After migrating and finishing the upgrade many of our content databases were still in SQL Compat Mode 130(2016) so I changed them to 150(2019) and didn’t think anything of it as all of our components should be SQL2019 compatible by Nintex Standards they support whatever version of SQL your SharePoint environment supports.Later today I received notice that one of our workflows was not working. Looking through the logs I found this error: “Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.” Knowing that I had changed the compat modes of the content databases yesterday I went straight to the content database the users were having issues with a Nintex form and workflow. Set compat mode back to 130 and manually fired t

has anyone used MDM to “allow” cross site tracking to the Nintex forms . have had not much success , and it is an option that should fix : https://support.apple.com/en-ca/guide/deployment/dep36877776f/1/web/1.0 payload is in Domains as of ios 16.2 , should be similar to this, but still getting “contact administrator”, but doesnt seem to use the string values.  <dict>    <key>PayloadDescription</key>    <string>Cross-Site Tracking Allowed Domains</string>    <key>PayloadDisplayName</key>    <string>Cross-Site Tracking Allowed Domains</string>    <key>PayloadIdentifier</key>    <string>com.apple.domains.ACCDBF25-6565-4DA9-A97A-610D2A7FCF29</string>    <key>PayloadType</key>    <string>com.apple.domains</string>    <key>PayloadUUID</key>    <string>ACCDBF25-0661-4DA9-A97A-610D2A7FCF29</string>    <key>PayloadVersion</key>    <integer>1</integer

How do I connect Nixtex workflow 2016 to Azure SQL using execute SQL task ? 

I have a form with the below fields:field 1: Org (choice): Internal, Externalfield 2: Internal (choice and a hidden field based on field 1 selection)field 3: External (choice and a hidden field based on field 1 selection of neighborhood, city, state, Otherfield 4: Other (choice and a hidden field based on field 4) I need to hide a panel with additional fields based on the below rules. Because ‘External’ and ‘Other’ are hidden fields, I am having difficulties in makng the rule work. Any assistance would greatly be appreciated:Org == “External”External == “Other”Other == choice A || choice C || choice E

Currently, on SharePoint 2019 on-prem I have a workflow that resulted in this error. Coercion Failed: Unable to transform the input lookup data into the requested type.it is falling when trying to create an item on another list. this is the only item it has failed on. I'm not sure what this error message means any assistance will be appreciated. 

Hi how to trigger validation rules via Javascript? I have tried using Page_ClientValidate() but it is not highlighting the fields not like when clicking the Save and Submit Button.   Thanks for your help.

Hi everyone, I need some help with calculating scores. I have a form with 26 categories, each category has about 7-12 choices column with correct and incorrect choice. I would like the scoring to be calculated. User will be doing one category at a time. what would the best approach to avoid 300+ rules, as i tried Calculated column within SharePoint but i have hit a limit of number of column reference within the formula. this is what i did in SharePoint calculated column but it has reached a limit, so can't use it anymoreTotalCorrect:+IF(SA1="Correct",1,0)+IF(SA2="Correct",1,0)+IF(SA3="Correct",1,0)+IF(SA4="Correct",1,0)+IF(SA5="Correct",1,0)+IF(SA6="Correct",1,0)+IF(SA7="Correct",1,0)+IF(SA8="Correct",1,0)+IF(SA9="Correct",1,0)+IF(SA10="Correct",1,0)+IF(SA11="Correct",1,0)+IF(SA12="Correct",1,0)TotalInCorrect:+IF(SA1="InCorrect",1,0)+IF(SA2="InCorrect",1,0)+IF(SA3="InCorrect",1,0)+IF(SA4="InCorrect",1,0)+IF(SA5="InCorrect",1,0)+IF(SA6="InCorrect",1,0)+IF(SA7="InCorrect",1,0)+IF(SA8="In

I have a hyperlink that appears in a calculated field. Users are unable to click on this hyperlink because it appears as just a line of text like this www.hyperlink.com. How can I make this into a clickable link w/in the calculated field? 

Hello,I am new to Nintex and designing a form with Classic designer. I need to update the Status column to “Completed” when a Yes/No Checkbox (Column name: Done ) is ticked.Just trying to find the right expression which will action this within the form itself.Any help would me much appreciated ! Thank you

I am building a form for making appointments with these fields:Appt Category (Choice): Make appointment or block appointments Supervisor (people picker) Supervisor Not Listed (checkbox yes/no - default is no) Supervisor (Manual Entry) - text fieldI already have a rule where ‘Supervisor (Manual Entry)’ is a required field when ‘Supervisor Not Listed’ is equal to ‘Yes’… But need a validation rule to make the ‘Supervisor’ (people picker) field MANDATORY on these two conditions. I tried this rule, but it does not work:  ‘Appt Category’ = “Make appointment” AND ‘Supervisor Not Listed’ is equal to ‘No’So that when ‘Appt Category’ = “block appointments”, the supervisor fields are not mandatory.Thank You.

I’m just starting to learn Nintex on SP 2016 OP.  I’ve got a list that containing multiple columns pertaining to vehicles, their registration numbers, assigned drivers and; maintenance intervals.I had no problem creating a workflow to notify drivers when their vehicles are coming due for inspections (although it seems to send duplicate notifications to at least some recipients).My intent is to create a WF to send a consolidated list of vehicles along with their respective registration numbers and driver info, to the maintenance supervisors.Using Query List, I’ve been able to gather the requisite data into collections (Vehicle type, registration, driver info) however the only way I can get this info to display in the email notification is   ∑ Vehicle type,∑ Vehicle Registration etc.What I aim to achieve are individual lines that are easily interpreted such ie.Vehicle 1 type, Registration #1, Driver #1Vehicle 2 type, Registration #2, Driver #2 etcIt seems to me that Merge Collections wou

I have a list workflow and design to start when new item added. But when the workflow run. how do i get the current item which triggered the workflow run? I want to get the value of the column of current item 

I have a form that was submitted for approval.  The form was rejected because some information was missing.  I would like to know how to edit the rejected form before resubmitting for approval again. Thanks 

Hi,I managed to extract the repeating rows data into a separate list call “Master” from a Nintex classic form, now my users are asking if there is any way to allow users to tick on the individual row of the “Master” and then combine it back to a new instance of the Nintex classic form as a repeating table again? This will allow the user to reuse the data entered in the previous form but with the ability to select those rows that are applicable.

HiI am using Nintex 2019. I have a requirement for validation on a single line text field that I am hoping would be detailed in the pseudo code below. The code is activatedLoad existing values from a column in another list. Split the values to identify the required text (ABC123 <User input>) - ABC123 is the required text. Split the values in the single text field, with the similar text entry as in (2). Match specifically the required text. If this exists / matches, display an error message.The functionality I can think of that is required is tostore values in a variable to be retrieved. RegEx to match the required text. Split the text input into components - similar to Regex Debugging - console.log?I was thinking of writing this, NOT using JavaScript but in validation syntax. I would appreciate any advice in this too. I will be implementing this in the ‘Save’ button in the “Causes validation - Expression’. What I was thinking of is something like this -List-Name “The List” (and t

hi Team,My workflow requires manual start. Whenever i start the workflow manually. System will direct user to this page and user need to click start to make the workflow start? Can we start the workflow without seeing this screen? 

Hi,I have a workflow which creates a subsite. For this new site I create a new group, assign the role (Contribute) to the new group and assign the members to the new group - everything via web service., It seem’s  to work, I got no error messages, the group was created, the members assigned. But when a Member of my new group wants to open the new site, the error message “You need permission to this site” appears. If I change the web service where I assign a role to the new group from “Contribute” to “Full Control” everything works fine. For me it seems, that only the role “Full Control” is accepted?I’m using Sharepoint 2019 on Prem

I have a SP list with 4 columns: Date1 Date2 Days between: Calculated field: Date2 - Date1 Reason for delayHow can I make the field Reason for Delay required in the Nintex form if the column Days Between > 22?if possible, please explain step by step since I’m completely new to Nintex forms.Thanks!

Hello,is it possible in Nintex Workflow Cloud to create a long term delegation rule like with SharePoint 2019? With best regardsNiklas

Hi,I am trying to create a item in Sharepoint list using excel data(csv) which is stored in a document library. How can we do it through workflow?Please guide me!Thanks!

In SP 2016, I have a list view web part on my Nintex form. It is fetching out field/values from a view in a list. At run time, I am seeing the “Add new item” at the bottom of the web part. Want to get rid of Add New items.  How do I accomplish that. Thanks Mayank

I was having an issue opening Workflow for SharePoint so I uninstalled it.I re-installed it and now it is not available on the list. It does show on the site, and all I can make are Site Workflows. The New button just lauches the Nintex FormList menuHere it is at the Site level 

Dear fellow community membersWe migrated SP2010 sites with Nintex workflows to SP2019 + Nintex. So far 1 workflow behaves differently as it still shows in the Running workflows overview, but does not show a status in the workflow status column and where the workflow details say that an Error has occurred and the workflow has stopped running.It's an on-premise envorinment where a visitor (for this InfoPath forms library the Visitor has Contribute but not delete permissions) successfully can submit a InfoPath form and where the Nintex workflow properly triggers. However, one of the first actions is to rename the InfoPath form. And here it goes wrong. Although it seems the Update item renaming the file and following Commit are successful (green) but the action set they're in remains yellow while the next action inline does run (remains white). On SP2010 this worked like a charm. So what am I missing here?When a Member (or Owner) user runs the workflow it runs just fine. Kind regards,Jean-

Hi, I'm new user.  Seek sime advice sometime the Lazy Approval the Approved/ Rejected aNot show up in the body email messages (outlook) How to solve this or anything to check in Outlook?Thank you .

Suppose I want to query multiple list in a Site to get a list of all the documents where modified date is before 2018 . How to achieve the same?