We have a website for Holiday rentals and have been trying to create an availability calendar to match with an existing dynamic page (villa rental title, description with photos, prices, etcetera). On every dynamic page needs to be a different calendar. There was no matching widget or grid that connects with a database besides the tables, so now I have worked on a table which is connected to a database that will showcase all the houses in rows with months and date numbers (in the fields with colors I added colored images):
Now these were the steps to slowly change the table after this in the editor:
Now I ended up with an availability calendar looking like this::
Looks nice. Yep. Only this is a lot of work and now I only added 2 houses of a total of about 50 Holiday rentals (still to add in the database, which is 600 rows of data in images ). In this way I have to add all the houses in the database with in the first column the name of the house, the 2nd the 12 months and after that bit by bit adding images of the right color per availability (which we receive from our vacation rentals in iCal, Google calendar, etc).
Long story short: a hell of a job. So I hope anybody knows a faster way of connecting the multiple calendars of all different houses that need to match with each and every seperate dynamic page of a vacation house. Anybody any idea how else we could match something with the database? For example linking the URL of the calendars in the database?? To?? OR a faster way to connect the tabel with it? Some help is highly appreciated. Kind regards