Skip to main content

OK, I have a SharePoint list tracking licenses owned vs. licenses in use for 4 software: MS Visio, MS Project, Photoshop, and Visual Studio Enterprise.

 

Title          Licenses Owned          Licenses in Use          Total Licenses Remaining

MS Visio   75                                 61                                14

 

QUESTION: I want to create a Nintex site workflow that sends a weekly email notice if a software has more 'licenses used' than 'licenses owned'.  Each software is an item in the list and a 'Total Licenses Remaining' column calculates an integer that MAY show a negative number.

 - How do I create a workflow that checks the 'Total' licenses for each software and sends a notice if  the number is below zero/negative?

Thanks!

Hi @Ed5 



 



You can create a scheduled site workflow to check the list for any licences where Licences used > Licences Owned, that will return a list into a collection that you could then format into table using a loop.



 



Then you can send an email based on that.



 



Personally I would prefer to know when licences are exceeded immediately but that depends on your needs, If you wanted to do it that way you could just build a workflow on the licence list its self and notify any time there is overuse.



 



https://help.nintex.com/en-US/nintex2016/sp2016/Workflow/SharePoint/SchedulingWorkflow.htm

Thank you sir!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings