Hello ,
My requirement is to Select one or more seats from available seats for a selected date. Create and use your own data source.
Hi ,
we should have 3 different data types one for desks allotted , desks in progress and available desks
Available desks will be based on base location / Office location
Desks allotted will have the data related to selection done by the employees for particular date
If you select particular date , you need to check whether seat information present in desk allotted table (if multiple records are there sum up them ) and subtract it from Available desks table .
Desks in progress is used if we have any approval process, and if we need to insert in allotted table only after approval . we will use this as place holder