You can calculate the difference between the time an item is created and modified via the following formulas: =TEXT([Modified]-[Created],”h”) Displays the hours between the two times; =TEXT([Modified]-[Created],”h:mm”) Displays the hours and minutes between the two times; =TEXT([Modified]-[Created],”h:mm:ss”) Displays the hours, minutes …
Calculated Column: Calculate the difference between two times Read more »
To view the SharePoint list items that are created this month you need to create two calculated columns and a custom view. Add a new calculated column StartMonth and at the following formula: =DATE(YEAR([Created]), MONTH([Created]), 1) For the second calculated …
Calculated columns: Display items created this month Read more »
An short post about how to create a view displaying the list items that are created this week: Create a calculated column named WeekStart and add the following formula =[Created]-(WEEKDAY([Created])-1) Create a calculated column named WeekEnd and add the following …
How can you add an newly created SharePoint list or library directly to the left navigation (Quick Launch) with Nintex Workflow? There is a way to do this via the lists web service method UpdateList. and then set the listproperty …
Add the created library automatic to quick launch Read more »
I was getting the following error when I wanted to create a site with Nintex workflow: Failed to create site. http://portal/sites/Martijn contains illegal character ‘:’. When you look at the action you think that everything is filled out ok There …
Failed to create site. Site contains illegal character ‘:’ Nintex Workflow Read more »
If you want to add all items from a repeating section in InfoPath to a SharePoint field via Nintex workflow you can. Create three variables: Two text: “SoftwareToRetract” and “SoftwareRetracted “and one collection: “software collection” Use an XML Query and select …
Add each item from InfoPath repeating section to SharePoint field with Nintex Workflow Read more »
How to update a column in a InfoPath repeating table based on the selected user in a other column? I wanted to add several users to a repeating table and after submitting the form the computer, location etc. from the selected …
Update InfoPath field in a Repeating Table with Nintex Workflow Read more »
A workflow crashes with a HTTP Status 400: Bad Request error, strange that it only happened on one list item. The workflow needs to copy an item in another site collection via a Nintex web service action. As it turned out …
Nintex Web service gives a HTTP status 400: Bad Request error Read more »
When you use the standard create item in Nintex you have the option to store the new item ID in a variable, this option isn’t available when you create an item via web service. The solution is to use the …
How to get the ID of item which is just created with Nintex call web service Read more »
When working with a personfield in SharePoint you need to remember that the field doesn’t save the username from the user but his SharePoint userID. If you want to use this field to get the emailaddress, firstname or other userproperties …
Retrieve user properties from SharePoint person field with Nintex Workflow Read more »