Hello! I am trying to create a way to record for my barn which volunteers cleaned which stalls on which day, that I can then view by volunteer to see what days they’ve worked, and yet another view to count how many stalls they’ve worked in a day, week, month, etc.
I got created my first table and form for inputting that day’s records, and it’s working great! The first column is “DATE” and the rest of the columns are “Stall 1”, “Stall 2” etc. The cells contain the date in the first column, and then the Volunteer’s names under the Stall columns. I created a second table with volunteer names, but I’m not sure I’m linking properly.
Suggestions on how to set up my data so I can create views to see by single day (original table), By volunteer’s # of days works, and also by volunteer’s # of stalls cleaned? This will help immensely for us all to track their hours so they can get the credit they deserve.
Thank you so much!!