Archive

I have been looking for a way to conditionally validate a lookup selector field in Nintex Forms. Basically, I need the field to be required when a previous column has specific values selected and not be required if any other values are selected.This seems like it ought to be simple, but using anything like the below does not work:isNullOrEmpty(LookupSelectorField) && (ChoiceField == "A" || ChoiceField == "B" || ChoiceField == "C")This doesn't work either:LookupSelectorField == "" && (ChoiceField == "A" || ChoiceField == "B" || ChoiceField == "C")Is there any way to conditionally require a lookup selector on the form?

I have a site workflow that using RunParallel action with 3 branches (1, 2 and 3). But it only works with 2 branches (1 and 3), the branch 2 not working at all. I used LogHistory action but it did not still run into.Please let me know what's happening ?Thanks and regards,Tan Nguyen

Hi EveryoneI have a sharepoint list which retutns me some name; I store this name in a collectionAfter that; I'd like to execute a sql querry like that:Select [Role], [Name],[Incoming]FROM MyDBWHERE Name IN mycollectionWhen I execute this WF; I get the following error message: Incorrect Syntax near 'Bob' (Bob is a name which is in my collection)Any idea of what I'm doing wrong?Thanks

I'm using a "Calculated Value" form control with a lookup function along with the parseLookup function to pull information from a Vendor list.  Sometimes the Vendor list does not have values in all the fields (ie:  "Contact Name" or "Fax" may be empty) which results in #Value! on my form.I have unsuccessfully tried IsNullorEmpty(ControlName) rules to hide any blank answers.Examples of my lookup function:lookup("PReq XTbl Vendor", "Name - Biz Partner No", parseLookup(Vendor), "Contact Name")Question:How can I either hide the #Value! on my form when there is no returned value from the lookup function-or-How can I only run the lookup when there is a value to returnEither of the above should be viable solutions in my scenario.

This blog post has been heavily leveraged but unfortunately is outdated. Please refer to the following Knowledge Base article for further guidance:   Updating Workflow and Forms for SharePoint On-Premises https://community.nintex.com/t5/How-To-s/Updating-Workflow-and-Forms-for-SharePoint-On-Premises/ta-p/119304

We have a workflow that shows that it has errored. It is one that was created by an external consultant and I cannot see why it has errored, no meaningful message.What is the best way to diagnose why the workflow errored?

Is there a way to run a workflow on a Document set and have all the documents in that document sent as individual attachments in an email?  Thanks.

I have a workflow in which I must both update an item and set the item permissions. Intermittently the workflow throws an ambiguous error (e.g. "An error has occurred in [name of the workflow]"). E.g. an error occurred somewhere in this series of actions...In this instance, the "Update Action" item was successful, but the item permissions were not set, and the workflow did not proceed beyond this point.I've tried reversing the order of these actions (set permissions first, then update item) and have tried with and without the "Commit pending changes" action.I'm speculating that either I'm stepping on my own toes (one action makes the list item unavailable for the other action) or that users are trying to update the item at the same time (making the list item unavailable), but I don't know how to diagnose this further.Next step is to create a new text field, write something unique to it in the "Update item" action, then use it in conjunction with a "Wait for item update" action and put

Hi,I want to use a Nintex workflow to check in a document automatically based on a field written from an Infopath form. When I try to trigger the workflow, though, I get an error message saying that workflows can not be run on a document that is checked out. However, in Nintext workflows, there is a "Check in" option available under "Lists and Libraries" so it looks like the "check in" should work.Here's a bit more back story:I have a very complex Infopath form. I want to keep more than one person from opening it at a time because SharePoint allows multiple people to access it at the same time if they're opening it in a browser. Data is getting lost when the form is saved if two people have it open at the same time. To try to stop this from happening, I created a workflow that automatically checks out the form when it is modified. That works great. However, I created a field that changes when the form is saved and closed in order to trigger a "Check in item" workflow so that the form w

Hi  All,I'm trying to create List view filtered by controlled value on my form but it doesn't work.Value comes from metadata field.Displaying all values I'm getting without any problems but once the value is set in the field list view start causing the error Something Went wrong. ULS logs :Error filtering the list view control: System.ArgumentNullException: Value cannot be null.  Parameter name: staticName     at Microsoft.SharePoint.SPFieldCollection.GetField(String strName, Boolean bThrowException)     at Nintex.Forms.SharePoint.NfsFilterUtilities.GetFilterCondition(SPList list, String fieldName, Object value, LookupFilterMode filterMode)     at Nintex.Forms.SharePoint.FormControls.ListViewFormControl.ProcessFilter(String filterField, Object filterValue, LookupFilterMode filterMode)     at Nintex.Forms.SharePoint.FormControls.ListViewFormControl.FilterView() Any one faced the same issue ?M.

My calculated fields are not populating back to my list.  Any ideas why?Also, in display view, the "total line cost" will not display and the calculations are incorrect:

I have a Flexi Task I tried to assign to a Distribution List.  When I put in the Distribution List (DL) for the Assignees field it finds the DL on the AD and it displays the name of the DL properly.  However, as soon as I hit save and go back into the FlexiTask the Assignee is all garbage.  It shows C:0+.w|s-1 and then a bunch of numbers...Can I not assign a DL to the Assignee.My goal was to send the Task to the DL and anyone could complete.  

Hi,I am trying to validate the date in a form via the rules and there are two fields: StartDate and EndDate.The purpose is to validate the date and time when:StartDate (including time) is equal to or greater than the EndDate (including time)For example the below entry throws the error because it sees that 00:00 is lass then 08:00 which in fact are 8 hours from 00:00 midnight until 8:00amStartDate:    25/10/2018 00:00EndDate:     25/10/2018 08:00The new formula should validate when dates are equal and the Time in EndDate is less than in StartDate otherwise let it go through any time when endDate is more than startDate. In simple term, dis-allow date/time in the past!Validation formula used: formatDate(FromDate, "dd/MM/yyyy hh:mm") > formatDate(UntilDate, "dd/MM/yyyy hh:mm")

I am attempting to set item level permissions in a list. Here is what I currently have set. It appears to apply the permissions correctly. When I check the list I see permissions exceptions for the item which correspond to the permission level assigned. The end user in the Assigned To field cannot view the item. What am I missing? Is this level of item permission level setting supported in standard or task lists?

We're looking to add hundreds of items to a SharePoint O365 calendar. We would like for an email to be sent out 3 days prior to the due date with a custom message to the groups/users added to the calendar event. I've not done this before and am not sure if there is a simple way to do this using a Nintex workflow. Any advice or recommendations will be greatly appreciated.

I'm trying to create a Nintex form in Sharepoint 2013 that helps prohibit double-booking in a Calendar List. To do this I've created a relatively simple formula, using a rule of type "Validation". The formula is not(isNullOrEmpty(lookup("ARB Calendar","EventDate",StartTime,"ID")))When using trying to submit the form I get an on-screen error message that states "Validation Error - There was an issue validating the data entered on the form; please try again. If the problem persists, contact the form owner.". In the browser's debugger I see "Handling all asynchronous validation rules failed". I've been able to validate that the proper data comes back from the server using Fiddler to inspect my web traffic and seeing the JSON response that contains the event that otherwise fulfills the lookup query.For an interesting twist, I used the same formula for a "Formatting" rule, and that fires just fine turning the label red to help indicate the problem. Is there a better way of preventing double

Hi Folks,I have successfully configured a list lookup and when a value is selected, I am getting the expected values from the source list item in a series of calculated value controls. My next task is to get some of my list fields/form controls updated with the values that are showing up in the calculated values.In the image above, I select my name from the dropdown (list lookup control). That loads my last name, first name, and employee ID three calculated value controls currently visible up in the header. I want the values calculated to appear in the appropriate fields below the list lookup control.I know I could just use the CV controls and bind them to the list fields but I need the user to be able to optionally use manual input if the person is not found I the list.What is the most straight forward way to do this?Thanks and Regards,Patrick Kelligan

I have a form in Nintex that has a dropdown control with many options to choose from. My question is, is there a way to validate for individual choices selected in the dropdown. For example, if "commercial" is selected from the dropdown box can I validate a text box to recognize the selection and apply validations for the choice? Where the text box would be labeled "account #" and validated to only allow so many numeric characters.

Currently I have a form that contains a calculated field that displays the Current "Job Function" and I also have a corresponding drop-down for the Requested "Job Function".  The Requested "Job Function" is using another list as a lookup to obtain its values for its drop-down (name of lookup list is "Job Functions LookUp"). What I would like to occur is that the Current "Job Function" calculated field dynamically set the default value of the drop-down for the Requested "Job Function" so that they are always equal to one another just as the picture I have inserted below illustrates.I believe this article gets me partially there; however, this only sets the default value of a drop-down to something that is fixed and I need this to be dynamically updated as the calculate field is changed.The use case for this is that in most cases the Current "Job Function" and the Requested "Job Function" will be equal to one another so auto-populating avoids additional data entry; however, in instances

Hi EveryoneI suspect that this issue may not be a Nintex issue. but I'll try here anyway.  I have a list that has a People / Group picker field.  Works great when I select a person or a group on SharePoint.  However in our company we have email boxes that are shared.  For example one of the shared email boxes (team boxes) is confermationteam@companyname.com  with an internal name of "Confirmation Team".When I just the people picker to and type in "Confirmation Team" it says it can't find it.  When I try confermationteam@companyname.com  (that would be considered in domain address)it says I can't share externally.  How do I get the people picker to bring up the shared email box?  is there a setting on SharePoint?  Keep in mind that I have very limited access to SharePoint's inner workings.  The company has locked down most of the functions. Using SharePoint 2013.Help.  Thanks

I am building a workflow on a SharePoint list. It is set to run when an existing item is modified.I want to "Send an Email" to the item creator and in the Body, I want to include only the fields that were modified. Is this possible?

Hi All,Recently took over SP2016 environment, which is about to go prod, but has been set up before my time...Nintex Workflow and Forms have been already installed.I am worried that Nintex has not been configured properly.The setup is:2xApp servers - SPAPP1; SPAPP2, 2xWeb Servers - SPWEB1; SPWEB2 and database servers. The App & Web servers are load balanced.As Seen from CA Solution Management (see attached pics) Nintex modules have been deployed globally.I see that on one server some services (in connection to Nintex) are stopped and on some are on.Please see the screenshots of the each server services.Could someone let me know whether Nintex has been configured properly and all required services are running properly per server.Do I need to start Nintex services on ALL servers, or there is a dependency on the server role?Please let me know which services per server should be on?Let me know if you need more info. Thanks in advance!

I have a field on my form that need to be "required" when the approver makes changes.  I first tried referencing the field itself (TradeApproval), and when that didn't work, I tried using a variable to store the value.  Either way, the validation does not happen and no validation message appears. Is there a trick to make validations work on a form?

I have a form that has a begin date field and an end date field.  How can I validate it so that the end date cannot be prior to the begin date.  I already tried applying the following to the end date field and it didn't work.  lessthan(beginDate)Thanks for your help.

I am using Share point 2010.I have a list. Multiple attachments are added to an item at different times. The attachments are stored in a separate document library. An workflow copies all the attachments to the attachment document library.  As the attachments are added at different times I have set the workflow to start when the item is modified, but this means every time the item is updated and saved all the attachments are copied to the attachment library which means existing attachments already copied are copied again.I need a workflow that is triggered when the item is modified and checks if the attachment is already listed in the attachment library. If it is then do nothing if it isn't copy to the attachment library.The only way I found is to use the overwrite option on the copy action that adds for any new name that already exists the current date and time at the end of the name  ie Name (02-08-2018_16-34-40). Then on the attachment document library I have a workflow to delete ite