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 and seconds between two times.
For the methods to work, hours must not exceed 24, and minutes and seconds must not exceed 60.
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 column EndMonth use the following formula:
=DATE(YEAR([Due Date]), MONTH([Due Date])+1,1)-1
Now create a new view and add the following filters:
StartMonth is less than or equal to [Today]
and
EndMonth is greater than or equal to [Today]
now you have a view for all calls created this month.
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 formula =[Created]+(7-WEEKDAY([Created]))
Now create a view where there’s a filter that [Today] is bigger than or equal to WeekStart and a filter that [Today ] is less than or equal to WeekEnd
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 OnQuickLaunch on true.
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 error comes from the Url field, you need to define the name the url is going to be.
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”
Add an For Each
Buid dynamic string
After the For Each add an Update item
*You can get your XPATH code by opening your InfoPath form in InfoPath 2007. Now go to the field in the data source
task pane and right-click, copy XPath to get a field’s xpath code. Past it in the process XPATH field of your Query XML.
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 users needs to be added via a workflow in the form.
The structure of the form is as follows: we need the field AccountId that is a child from Person, which is a child from gpContactSelector, that is a child is from group4, which is a child from group 3 and finaly the parent is myFields.
The XPath for this field is:
/my:myFields/my:group3/my:group4/my:gpContactSelector/my:Person/my:AccountId
The workflow has the following actions:
Add a Query XML on the Current item and add the XPath path, store the results in a collection variable
Add an for each action that process the collection and a text variable.
An Update XML
XML source is current item
Create the following Xpath query:
Select Update node value
Add the variable you want to set in the FromLocation
Just a last few point:
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 the reason is that the title contained an ampersand (&) character and the web service crashes on special characters. So we have to excluded the parsing of the title, this can be done with the term CDATA.
Add an build dynamic string action and wrap the Title around “<![CDATA[” and end with “]]>”.
Store the result in a variable and replace the title with the newly created variable.
Screenshot in Dutch.
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 Store result in option in the Call web service action.
Now add the Query XML action and query the result from the web service with XPath (//@ows_ID)
This result will be your newly created item ID
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 from the user you can use Nintex workflow to retrieve these items.
Create two text variables, one for web service result and one for Query XML result.
Add an Call web service action
Add an Query XML
