2 Replies Latest reply on Apr 5, 2014 1:46 PM by garyjones

    Dashboard Style Layout Using Portals

    garyjones

      Title

      Dashboard Style Layout Using Portals

      Post

           Hi 

           I am a newbie and struggling a bit with relationships and portals though what I am trying to attempt may not be possible and would be grateful for any advice.

           I have created a series of databases that manage magazine assets etc such as images and editorial and these work well.

           There is also a table which contains the various production stage deadline dates for 4 monthly magazines. I have attached a screen shot showing the table, though this only shows the dates etc for just a couple editions of each mag.

           I have been trying to build a dashboard-type display that shows the key deadline dates in a panel display for each mag, the edition title and a countdown to two stages by comparing the tables dates in an If calculation that uses Get(Current Date) etc.

           To do this I created a database with a layout and one single record that acts as the Dashboard page. I then placed a portal on the page that relates to the Schedule table and placed its fields within a graphic sitting in the portal. My objective is to get all four panels displayed on one single page. Attached is a rough screen grab that shows the general idea albeit only one panel.

           The problem I have is only one record is showing in the portal and when I have played with fields and other relationship definitions there have been more records in the portal but they show the same date.

           Do I need four portals on the page? If anyone could help clarify what I am doing wrong and the correct relationship etc I would appreciate it.

           Thanks

           Gary

            

            

      DashboardAndTable.png