Hello,
I am trying to create staff resourcing functionality and am having an issue with how best to design how time is allocated to a project by week.
What I need to capture is:
User
Project
Week commencing
Number of Days for that week
Part of the difficulty is that I am looking to replace an existing solution, which has been setup in Excel. In the Excel version, each week is a column, meaning that a user can enter their weekly commitment of days on a project for the entire year with just one row.
Creating each week as a column in a table in dataverse seems like a sub-optimal design. I could create "Week Commencing" as a choice(s) field or even as another table and use a lookup but, as far as I can tell, a new row would have to be submitted for each week. If a user wanted to enter: "Week Commencing 5/5: 4 days, Week Commencing 12/5: 5 Days", it would be two different entries. As a result, our staff complain that the process is slower than entering data in Excel.
If anyone can think of a way this can be achieved, I would be very grateful.
Thanks!