1 of 1 people found this helpful
Leaving aside performance considerations, one method would be to filter the portals by day of week of task entry.
- Each portal relates to a table for each task
Why don't you have a single task table with categories? What happens when you introduce a new task type? Create an entirely new table? That's not a good (and certainly not a flexible) structure.
- Each row in the timetable is a portal
I didn't know we finally were blessed with horizontal portals …
Do you want to be able to edit the entries, or only display them? Maybe take a look at this thread for a somewhat related topic. Of course this approach becomes unpractical if you need to peruse n tables, instead of a single one (but AFAICS, this goes for all other approaches, too)
Yes, ideally the user could edit the entries rather than them just being displayed. How would this work with just one table?
I had a similar project going; see if this adaptation gives you some ideas.
Instead of repeating fields, you could of course use a Virtual List technique and a bunch of (filtered) portals.
CrosstabOnceMore_eos.fmp12.zip 109.7 K
This is really helpful. I will try this is my database.