I am assessing whether AppSheet will suit our business needs and need to know if it is possible to build a form/display of some sort that will facilitate scheduling.
Ideally I’d like to have the names of current staff going down the left of the page, the days of the week across the top and the cells filled with the jobs they’ve been assigned to. I think the easiest structure is to have a Jobs table, a Workers table and the data table. The data table contains the WorkerId, Job Id, Date Assigned and associated details. I’d like to be able to click on a Job or Job slot to select a Job to fill that slot.
Most of our jobs are full day jobs but some are part day jobs so eventually I need to expand the structure to incorporate that but before I embark on the learning curve to master Appsheet I’d like to know if this is going to be realistically possible and if so is my proposed structure right.