Archive

I have an Form with an 2 Date Fields. Example:I want to calculate some things:end of year from date "Project Start" (31.12.xxxx) as a date value to calculate morecondition for: "Project End" can not be greater than year end of "Project Start" + 2 yearsExample:Project Start: 31.10.2018 --> to calculate "31.12.2018"to calculate: "01.01.2019" and "31.12.2019"Project End: 30.08.2020 --> to calculate "01.01.2020"I need the values to calculate all quarter from every year between "Project Start" and "Project End"Everything I've tested so far does not work, because the form does not load or the control shows #value.

Hi every body, So I'm newer with Nintex Form, My issue is to retreive user profile information, when I add an item in my SharePoint list, I'm using a calculate field   where I put this formula : userprofileLookup (Current user, "FirstName") , but it returns   #Value! Any one can help, thanks for Advanced , Best regards

Hello,I'm evaluating Nintex Forms and Workflow for SharePoint 2016 and have found some conflicting answers to a question I have.  In InfoPath, we were able to add multiple views to a form and switch to those views via a variety of mechanisms, including button logic, logical rules on form load, etc.  A few questions:1.  Does Nintex support rule execution on form load?2.  Is it possible to add multiple views/screens to a single form and switch between them based on things such as column values?I've seen some recommendations about adding panels to a form and enabling/disabling the panels based on column values (as an example), but I was hoping that something more along the lines of views was supported.Thanks

Hello all!So, I'm fairly new to the Nintex World, only started working with it since last October. Now I'm developing a form that needs input from various departments. The way I set it was in the inicial form, I have some fields that are filled in by the iniciator. Then, on the same form, I have multiple panels with controls (mainly star dates and end dates). When the item is created, the workflow sets a Request Review for Department1 to fill in. The diference between start date and end date cannot be bigger than 120 days. If it does, the list item must be considered as "Overdue" (I plan to write this information in a list column). The Workflow goes forward if Department1 introduces the end date, as the start date is set as the date when the list item is created. Then it promps another Request Review to another department do to the same thing (introduce dates), where I have to validate the same thing, but with a difference between dates of 30 days. At this moment, I have in the workflo

I am working on a site workflow that will notify the document owner when the next review is 90, 60, 30, and 14 days away then notify the admin the review was completed and is ready for their approval. After their approval I need a document that says who approved it with date and time. Also, their will be a past due notification if the review isn't complete in time and it will be sent to admin.Should I make multiple workflows for the different times or will they all work on (1)? I am currently using the Calculate Date action but it wont pull the Last Review date from my site list so I can set the reminder. Can anyone point me in the right direction?

I have a WF that creates ("Create New Item") about 400 items nightly to a List.  The WF runs nightly from the Nintex scheduler.  Occasionally I get an error that says "Failed to Start".  The problems is even though I get the message "Failed to Start" it appears that it really did run and it also appears that automatically a "Retry" occurs.  Thus, in my case the items are getting duplicated whenever a "Failed to Start" occurs.  My question isHow do I have the WF not attempt to restart if the Failed to Start occurs.Also, a totally separate question is if the WF successfully does run then how can I trigger another WF to run but again only if WF1 was completed successfully...

Hi,I am creating a Nintex workflow for the discussion boards in SharePoint 2013 on-premise. The criteria is as below.Discussions board has a custom column called Category added to all content types.Based on the category, the worflow should send notifications to specific sharepoint groups.All the discussions and Replies notification should be sent according to the category.I understand that the discussions list has two content types "Discussion" and "Message". I am able to send notification based on the category for the new topic in the discussion. However, I am facing issues with the replies. I am unable to query the Category from the "Discussion" content type using the "ParentItemId" of the reply, as the workflow would be running on the "Message" Content type for the replies. Is there anyway the category column value can be updated by default in the Message content type so that it is easy to query based on the reply Id? Or is there a way we can get category from Discussion content typ

I have a form with a calculated value control, and want to use the lookup function to retreive the value from another SharePoint list. The value to compare would be the current user, and a people picker value on the second list. The results are returning #Value!Calculated Value Control:The control with the current user has the Item Property set to NameLookup List:Returned Value:

I have a list, it has 5 content types inheriting from a base content type.In designing a form for the first content type there is a person and group field missing from the List Columns section in the form designer. This person and group field is in the base content type included in all content types in the list, it is an optional column.I have checked creating a list workflow and the person or group field is available to be updated in the workflow. Any idea why it might not be available in the form designer?Thanksusing Nintex forms for SharePoint 2013

I'm attempting to get a calculated field to update as the dropdown values change.In the example below - the problem is that the calculated value refuses to change if only "Landscape" is selected and subsequently unchecked. This issue does not occur if "Portrait" is already checked.There is no problem with the "Portrait" option - the calculated value always updates correctly.Is there something wrong with my script?NWF$(document).ready(function () {    NWF$("#" + PosterOrientation).change(function () {        if (!NWF$(this).find(':checkbox[value='Portrait']').prop('checked')) {        NWF$("#" + NumberRequiredPortrait + " option:selected").removeAttr("selected").trigger('change'); }        else         if (!NWF$(this).find(':checkbox[value='Landscape']').prop('checked')) {        NWF$("#" + NumberRequiredLandscape + " option:selected").removeAttr("selected").trigger('change'); }    });});

Hello,Is there a way to overwrite an existing list when creating a new list?The original list can be deleted or renamed, as long as the new list can have the old lists name.I tried to do this with the Create List action, but I could not figure it out.I am using an On Premise version of Nintex which is installed on a local SharePoint server.Any help is greatly appreciatedThank you.

HelloI am using Nintex to create forms and use the Desktop view.I have made all the relevant changes required and it looks great on a computer.However, when viewing on a mobile, the font-styel is not the same and therefore it alters the look of the form.Where do I change the font-style within the form for mobile devices ?I have editted the custom view as following:Forms > Settings > Custom CSS/* Mobile styles */ .nf-mobile-form {background-color: inherit;font-family: "Segoe UI Light","Segoe UI","Segoe",Tahoma,Helvetica,Calibri !important;}

I have a repeating section in my form. It contains two drop down lists. When the user selects and entry in the first drop down, it filters the list for the second drop down. The workflow needs to go to the person responsible for the combination. I can explain this by using the following table:ItemLocationPersonItem 1Area 1Person 1Item 1Area 2Person 2Item 1Area 3Person 2Item 2Area 1Person 3So it's possible that the person it goes to could be the same for a lot of the combinations, or it could be possible that every combination of item and location could have a different person where the workflow needs to go. Also, because this is a repeating section, there could be one item selected, or 20 items selected and the workflow approval would need to go to each person.I previously had a requirement where it was only based on Item and I had a parallel workflow for each item. But this isn't going to work since it's now based on item and location. I'm really struggling with how to lay this out us

is there any way to Insert Multiple items into list using nintex form

Hi All,I have a nintex form with a radio button choice field and a drop down.Now based on the drop-down value I wanted to display few radio buttons only and rearrange the controls without spaces.I am able to hide the radio buttons using jQuery. But the space issue exists after hiding the values.Please suggest how to proceed further.Thanks and Regards,Usha

I have a "Department" drop-down list on a form, which I would like to set as default to the current users department within Active Directory, but retain the list of values so that they can change this value should they wish.I know how to pull the users department into a text field using the code : userProfileLookup(Current User,"Department")I've tried putting this in as the default value on the field, but it doesn't work. Anyone managed this? I've had a look on the forums here but can't quite work it out.Cheers!

 Symptoms When using a picker control to filter for users, we want to show all the users that DO NOT have the word "external" appended to their usernames, in other words the picker control should not return any users that have the word "external" in their usernames.It's easy to set a filter to only return users with "external" by using the Contains filter, however there is no "Does not contain" option. Diagnoses This issue is related to the non-existent filter "Does not contain" Resolution This has been linked to an existing feature request to implement the "Does not contain" filter.A workaround to this issue would be to use an Expression that looks like this: CONTAINS ( DisplayName , External ) ) - where DisplayName uses the SmartObject output. This would either return True or False. 

I have a repeating section in my form.  There are 3 calculated fields within the repeating section that are all currency fields.  Two of those calculated fields are lookups to fields in the list that are setup as currency fields.  I have all 3 of the controls in the repeating section set to display currency formatting with the thousands separator, but both in Edit and View mode, the values do not show the Currency Formatting.Why do calculated fields within a Repeating section not display the formatting setup within the control?

I am building a workflow to delete documents that are 7 days old.  Have tried using  "Delete Item" and "Delete Multiple Items".I have a field in the list that calculates the created on date against the current date to get the number of days old.  Also have a calculated yes/no field that says if the number days old is greater than or equal to 7 then delete = yes.When I do a "For Each" action with the "Delete Item" action filtering on items in the list where days old greater than or equal to 7 or delete = yes, one item is deleted even though there may be several that meet the critera.When I use a "Delete Multiple Items", all the documents are deleted regardless of the specified criteria.What am I doing wrong here?  

Hello,We've had some Nintex forms & workflows in production for a few months now in our On Prem SP 2016 farm.  I was about to make some modifications to the existing form and am now experiencing an issue where I get prompted for credentials when I attempt to modify a control that is tied to a multi-value look-up column.  IE and Edge will prompt me 3 times for credentials then stop, whereas Firefox and Chrome will prompt indefinitely.  My account is site collection administrator, so there shouldn't be any permission issues. The only change that I am aware of is that I updated the site column to pull and additional column value, but the issue still occurs if I remove this value.  The site is SSL so I can't really take a look at the traffic in a network trace.Has anyone ran into this issue before?  Any suggestions on what to check?

I'm working on a public Nintex Workflow Cloud form that anyone can fill out.  This form has two page/steps: first page for initial questions and second page displays information based on choices in the first page.  On the first page, users answer three required Yes/No questions and click the Next button. They are then taken to the second tab/page which displays information based on what they answered in the Yes/No questions on the first tab/page.  What I'd like to do is hide the Action Panel with the Previous and Submit buttons on the second page/tab so the user can't go back and change answers.Is it possible to hide the Action Panel with the Previous and Submit buttons on the second page/tab? Can I add a rule to this control to hide the Previous and Submit buttons on the second page/tab?

 Symptoms  How to check-in K2 form on behalf of another user?  Diagnoses  Usually this happens when a user leaves the company or goes on vacation for a long period and the developers are stuck with a checked out/in form and they cant access it.You can change this with the K2 DB with the correct scripts.  Resolution In SQL Management Studio, you can run this SQL query to find the Form that has been checked out:SELECT * FROM [K2].[Form].AuditLogFor example, let's say I have a Form that has been checked out by Bob on 06-02-2014 at 12:47, then please copy the following:UserID = K2:DENALLIXBobID = 4E04425C-58A1-4AB0-95AF-7D219235F381In your K2 Database, browse to K2 -> Programmability -> Stored ProceduresIf you want to Check In the Form *with* the changes that Bob has made, find the Proc named Form.aCheckInFormIf you want to Check In the Form *without* the changes that Bob has made, find the Proc named Form.aUndoFormCheckOutRight click -> Execute Stored ProcedurePass the values you

HiI'd like my Nintex form to have this field auto populated with the current user's Full Name however I can only find 'CurrentUser' which prefix's the username with the domain name. Is there another way to do this without using the people picker? Thanks

Hi Everyone,I have a problem in updating an appointment in Outlook using Web Request Action. The scenario is this I have a workflow that will create an appointment to Outlook when an event is created in a sharepoint calendar and this workflow is just working fine. The next workflow is when an event is modified in the sharepoint calendar the changes will reflect on the Outlook calendar. Thanks to Caroline Jung‌ answer to https://community.nintex.com/thread/1783. I successfully created a workflow that will update the Outlook calendar when the sharepoint calendar is modified. But here is the problem. In every event the user will also input several attendees and I can't update their Outlook calendar and I don't know why I cant update it my best guess is that I don't have their username or password that the web request action is requesting for. I also mark it as a red text on the codes below and the only information I have to the attendees is their email addressURL : https://your-exchange-s

Hi,I am trying to programmatically import historical data for a SharePoint list.  The list has a customized Nintex Form that uses a SQL Request Control.  I have updated the 'ID connected to' and the 'Text connected to' field values, but when I open the form for an item that was programmatically added, the values don't load in the SQL Request Control.  Is there something else that should be updated as well?Thanks,Amy