4 Replies Latest reply on Mar 1, 2014 6:23 PM by colinmatthews

    Portal filtering calculation

    colinmatthews

      Hi all,

       

      I have a Timetable of weekly tasks that a user needs to complete and I would like that user's dashboard to display only the tasks from that timetable that corresponde to the particular day of the week.

       

      For example, if a user signs in today they will see on their dashboard a list of Friday's tasks only. Below is a screen shot of the timetable:

       

      Timetable.PNG

       

      - Each row in the timetable is a portal

      - Each portal relates to a table for each task (tasks listed on the left)

      - All task tables have a field for each day of the week.

      - I have the following relationships in place: PKDashboard -< FKTimetable, PKTimetable -< FK*whichever*Task

       

       

      Is it possible to do this?

       

      Many thanks for your help.

       

      Colin