Not sure if this is what you need as it depends on your architecture aswell, you can have a table that contains all the time for the slots then an boolean to check if it is still avail or not.

Hello @Manorama Malviya,

Could you please proved demo oml with your problem statement.

So will get to know exact requirement.

Hi @Manorama Malviya 

Your requirement is not clear ,can you please send  screenshots or oml file to better understanding.

Thanks

Mansur

it would be better if you have an entity for the date and time, so you dont need to manually check if there is an appointment. that table should contain the appointment date and time and the status of it, you can have a table to auto create these record, for example 3 month in advance so they can select 3 months ahead. you can change depending on your scenario