I was hoping you could help me. I have a calendar in SharePoint 2010 that I want to run a Nintex Workflow when the following conditions are true:
- A new item is created
- The "Type of Leave" field equals "Vacation". This field I created as just a category for the types of requests.
- The date that the item was created for already has an entry with the "Type of Leave" field equaling "Vacation."
The use of this will be that the first person to enter vacation on a day will be automatically granted. But if more than one person enters vacation on the day that another vacation day is on, it will go through an approval process through their manager.
Here's what I've tried/reviewed: - Using a Condition within a workflow. I can't find an option that would complete this. - I did try looking on line searching for different solutions. I've watched some tutorials but nothing with this kind of solution was present. - One thought I did have was to have an additional calculated column that counted how many entries for the same day with "Vacation" and then use that in a condition if the column was greater than 1 but I couldn't figure out the syntax.
This is on SharePoint 2010.
Thank you!