CHECK DOUBLE BOOKING

%3CLINGO-SUB%20id%3D%22lingo-sub-198924%22%20slang%3D%22en-US%22%3ECHECK%20DOUBLE%20BOOKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198924%22%20slang%3D%22en-US%22%3E%3CP%3ECase%20scenario.%3CBR%20%2F%3E-I%20have%20added%20a%20calendar%3CBR%20%2F%3E-Added%20some%20extra%20columns%20to%20the%20Event%20Content%20type%3CBR%20%2F%3E-Added%20the%20check%20double%20booking%20formula%20in%20the%20validation%20settings%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20challenge%20I%20am%20facing%20is%20that%20when%20I%20create%20a%20new%20event%20I%20get%20the%20warning%20that%20the%20room%20i%20am%20booking%20is%20already%20taken%20up%20during%20the%20selected%20period%20however%2C%20I%20have%20not%20created%20any%20event%20as%20yet%20and%20the%20calendar%20is%20empty.%3CBR%20%2F%3E%3CBR%20%2F%3EKindly%20I%20need%20some%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35090iD7128EE6831B171D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Empty%20calendar.JPG%22%20title%3D%22Empty%20calendar.JPG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EEmpty%20Calendar%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20640px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35091iBF40A9AFECE6BDD8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Event%20and%20Error.JPG%22%20title%3D%22Event%20and%20Error.JPG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ENew%20Event%20and%20Error%20but%20calendar%20is%20empty%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20640px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35091iBF40A9AFECE6BDD8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Event%20and%20Error.JPG%22%20title%3D%22Event%20and%20Error.JPG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ENew%20Event%20and%20Error%20but%20calendar%20is%20empty%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-201770%22%20slang%3D%22en-US%22%3ERe%3A%20CHECK%20DOUBLE%20BOOKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201770%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20%40Velegandla%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20response%2C%20the%20formula%20is%20%3D%5BCheck%20Double%20Booking%5D.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20also%20tired%26nbsp%3B%20a%20formula%20for%20the%20dates%20such%20that%20the%20end%20date%20is%20never%20less%20than%20the%20start%20date%20%3D%5BEnd%20date%5D%26lt%3B%5BStart%20Date%5D%2C%20the%20event%20is%20never%20created%20even%20when%20I%20enter%20the%20dates%20correctly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-201593%22%20slang%3D%22en-US%22%3ERe%3A%20CHECK%20DOUBLE%20BOOKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201593%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F129806%22%20target%3D%22_blank%22%3E%40cyro%20sylas%3C%2FA%3E%26nbsp%3Bwhat%20is%20the%20formula%20you%20have%20used%20in%20validation%20settings%3F%3C%2FP%3E%0A%3CP%3Eyou%20may%20check%20JS%20solution%20for%20this%20issue%20%3CA%20href%3D%22http%3A%2F%2Fspjsblog.com%2F2012%2F02%2F25%2Fspjs-resource-management-no-more-double-booking%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fspjsblog.com%2F2012%2F02%2F25%2Fspjs-resource-management-no-more-double-booking%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Case scenario.
-I have added a calendar
-Added some extra columns to the Event Content type
-Added the check double booking formula in the validation settings

The challenge I am facing is that when I create a new event I get the warning that the room i am booking is already taken up during the selected period however, I have not created any event as yet and the calendar is empty.

Kindly I need some help

 

 

Empty CalendarEmpty CalendarNew Event and Error but calendar is emptyNew Event and Error but calendar is emptyNew Event and Error but calendar is emptyNew Event and Error but calendar is empty

2 Replies
Highlighted

@cyro sylas what is the formula you have used in validation settings?

you may check JS solution for this issue http://spjsblog.com/2012/02/25/spjs-resource-management-no-more-double-booking/ 

Highlighted

Hey @Velegandla,

 

Thanks for the response, the formula is =[Check Double Booking].

I also tired  a formula for the dates such that the end date is never less than the start date =[End date]<[Start Date], the event is never created even when I enter the dates correctly.