2 Replies Latest reply on Oct 11, 2015 4:28 PM by RuiSampaio

    Calendar occupation views




      I have a table with two fields, one is checkin date and other with checkout date.

      I would like to know if there's some ways to show the calendar, and show the occupation marked between those two dates.


      Thank you,


        • 1. Re: Calendar occupation views

          I think you mean to do this:


          • create a date field with global storage (say, gDateFilter )

          • create a self-join for your table: create a new table occurrence, give it a meaningful name (i.e. YourTable_selfByDate), and create a relationship where

          YourTable::gDateFilter ≥ YourTable_selfByDate::checkInDate

          YourTable::gDateFilter ≤ YourTable_selfByDate::checkOutDate


          Put the global fiel onto the layout and format is as calendar; then add a portal into YourTable_selfByDate. Selecting a date from the global field should show all matching records by date.

          • 2. Re: Calendar occupation views

            Thank you for the reply.

            It wasn't exactly what I was looking for, but is also very useful for another option.


            What I would like, is to have a month view (a calendar view) showing the occupation of the five apartments on it (apartment is also a field of the table).


            It is to have an overview of the occupation and always know when the apartments are available and booked.