problems with view

Hi Henrik

I have mocked up something that gives what you describe. You will need to use a Kanban view and counter intuitively this is in the Activities table, not horses. Kanban views need a choice field to use as the columns, so set one up with 7 choices Monday to Sunday. If this field is called Day and the date of the activity is called Date get this populated with a Trigger after update 

Day := weekday(Date) + 1

You only want to select one week at a time so add a function field in Activity using this formula

yearweek(Date)

Now you can set your kanban up with Day as the column header, the name of your horse and its activity. Also include the yearweek field so thst you can search for this in the Kanban. It has the form 2021/15 and thankfully runs from Monday to Sunday. This kanban only makes sense once you have searched for a single week.

I can provide screenshots if this doesn't make sense.

Regards John

Morning Henrik

From my structure you can view the Activity as a Kanban or as a Pivot (not so successfully). In each of these you need to include the yearweek field so that you can search for it. You could, of course, use the Calendar instead of any of the above!

Regards John

Hi Henrik

If its hidden with the Hiiden attribute of the table ticked then you can untick that to show thae table again, or if it's not showing because Compsition is set to Yes it can be accessed from the small down arrow you can see on your Heste table. The yearweek() is a Ninox function that turns a date into a year week like 2021/15 as I explained in my first reply. Create a formula field in Activity and use yearweek(Date). This is what you need to search for to just have a single week's worth of activities showing

I don't think Kanban and Pivot Table views are available as dashboard elements - unless other forum members know differently.

Regards John