Skip to main content
Nintex Community Menu Bar

Is it possible to look for conflicting schedule in calendar app?

  • Jun 22, 2017 2:39 AM UTC
  • 10 replies
  • 18 views
  • Translate All

Forum|alt.badge.img+7

Hi Everyone,

Is it possible to find conflicting schedule in the Calendar App using Nintex form or Nintex workflow.

What my workflow is currently doing is querying a calendar list and sending all scheduled activity for the whole week.

What I want to happen is to put additional information in my notification that a specific activity is conflict with another activity.

For example:

Maintenance 1 - June 22, 2017 -- 8am to 5pm

Maintenance 2 - June 23, 2017 -- 9am to 4pm

Maintenance 3 - June 22, 2017 - 1pm to 3pm

The logic I need to create in the workflow is, If any time overlap to each other it will be considered as conflict even just by an hour.

Notification Email:

Maintenance 1 is conflict with Maintenance 3

In regards with Nintex Form I don't have any working prototype. But if it is possible in Nintex Form I am open to suggestions.

Regards,

Rogelio

10 replies

Forum|alt.badge.img+7
  • Author
  • Jun 22, 2017 10:26 PM UTC

It's been hours so it seems this is impossible? sad.png

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 23, 2017 2:05 PM UTC

little patience, holiday season is coming happy.png

basically, you can use one of two approaches

1. use CAML query to identify overlapping events in calendar. you can get an idea of how it might have looking eg here  

it might seem a bit complex at first sight, but advantage of this approach is that is could handle recurring events.

2. brute force way - read in all the events including their start and end dates into collection variables and then within a loop compare single events to each other.

Note that this will not work for recurring events, since this way you will not get them expanded and will just dates of first occurrence.

Translate

Forum|alt.badge.img+7
  • Author
  • Jun 23, 2017 10:40 PM UTC

Thank you ‌. I'll try this approaches.

Translate

Forum|alt.badge.img+7

Hi ‌,

I have successfully created a working workflow. Will the workflow crash if it becomes so big? Because comparing each dates that I queried creates a very large workflow.

Thanks

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 27, 2017 10:29 AM UTC

if you were able to publish it, it shouldn't crash due to size at runtime.

but I wonder why it would be so big.

what approach you decided to go with?

Translate

Forum|alt.badge.img+7
  • Author
  • Jun 27, 2017 10:14 PM UTC

Hi ‌,

The workflow I created will read in all the events created and compare them to each other. So if I have 10 events I will use condition to compare 1 item to the other 9 and so on.

Thanks

Rogelio

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 27, 2017 10:46 PM UTC

and if one adds 11th, 12th, 13th, etc event you want to always redesign the workflow???

as I said above, you should read in all the events to compare mutually into collection variables.

then, within 2 nested for each loops compare single events.

Translate

Forum|alt.badge.img+7
  • Author
  • Jun 27, 2017 11:16 PM UTC

I still can't visualize it. If you're not that busy it is possible if you can show me a very simple representation of what you are saying? Also, to answer your question if one adds nth number of events I will modify the workflow again.

Thanks a lot.

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 28, 2017 5:33 PM UTC

I've posted a blog with an example and detailed explanation.

have a look here  

hope it helps happy.png

Translate

Forum|alt.badge.img+7
  • Author
  • Jun 29, 2017 12:29 AM UTC

Hi ‌,

Thanks a lot happy.png. This really help me solved my problem.

Cheers,

Translate