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.
LinkedIn
Twitter
