That is easy, you should start by
1.creating a table called Choices with the columns:
[ID]-text, initial value =uniqueid();
[Choice1]-enum,initial value =“Choices”, enum input mode = dropdown;
[Choice2]-enum,initial value =“Choices”, enum input mode = dropdown;
[Choice3]-enum, initial value =“Choices”, enum input mode = dropdown;
[Student],ref to the Key column on your student table.
[Week], ref to the key column on a table with School Week numbers in it.
Then create a slice for each [Weekday]
Then create a Detail View for each Weekday slice, and ensure that [Choice1],[Choice2] and [Choice3] are in the quick edit list.
Then create a table view for students–ensure all your student names are in there.
Then create a table view for School Weeks—ensure all your school weeks are in there.
Then create a record in your “Choices” table, for each student, for each weekday, leaving the Choice Columns as “Choices”. This ensures the detail views actually appear when you click on the student and the appropriate school week in the dashboard.
7.Then create a dashboard and include each Weekday Detail view on it. Also include your student table and “School Week” table view at the top.
- In the view editor, select Behaviour/Interactive mode.
This should give you what you want, i.e. -a single view that has dropdowns for choices
-for each weekday -for each student -for each school week
On a PC it will line up side by side as in your picture. On an Ipad or phone it might be stacked on top of itself. But it will look good.
What do you think?