List Lookup based on entered start time & end time

  • 27 March 2018
  • 3 replies
  • 3 views

Badge +4

Hi All,

is it possible for us to filter the sharepoint calendar list based on the entered start time & end time in the nintex form either using the formula or list lookup option in the form?

Thanks


3 replies

Userlevel 5
Badge +14

it's not possible with lookup control nor with lookup function. they both support only simple single condition for equality.

I guess it might be possible with web request  control, if you are on enterprise license.

Badge +4

Hi Marian,

Thanks for your replied.

I wanted to use sharepoint calendar as our meeting room booking. but the current calendar allow overlapped booking (events).

do you have any suggestion on this ?

thanks

Userlevel 5
Badge +14

you could make the overlapping check with a workflow. there you'd have much more flexibility.

consider it just like user is requesting to book a room. but booking is performed by a workflow.

if there is no other overlapping event, workflow writes new event to the calendar and sends confirmation. if it overlaps with already booked event workflow would send a reject notification.

just like outlook does...

Reply