Elastic for Appointment Availability

Hi everyone,

I'm in the process of evaluating the best technology stack for an appointment booking system, similar to that of Acuity and Calendly.

Does anyone have any experience using ES for this sort of thing?

Would it be possible to have an engine full of appointment documents, then run a query against those appointments to return a list of available time periods that aren't in the engine.

So for example let's say there were 3 appointments in the engine, 1 at 9 am, 1 at 12pm and 1 at 2pm.

Then let's say the appointment time is fixed at 1 hour, and appointments only ran between 9am and 5 pm.

Would elastic be able to analyze this request and return the following available times?

10am-11am
1pm-2pm
3pm-4pm
4pm-5pm

If so could you give a generalisation of how this would be achieved or even just guage the amount of work to run such a query?

I have a client that is looking to either build a MYSQL based solution in house, using generated tables, but also wants to consider ES.

Thanks,
Rob

Welcome to our community! :smiley:

You could use something like Range field types | Elasticsearch Guide [7.15] | Elastic to store the time block of the appointment, and then query over that.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.