Hi 
I am looking for help from our community.
During my study of engineering, I required to build an app for work schedule of shifts arrangement via glide app,
The app will contain an option of weekly shifts that will be chosen by each employee, after all the employees will insert their priorities, all that information will pass a prosses automatically (placement algorithm), and eventually the employer will get the optimal final work scheduling.
I have a few problems for solving that.
First: Do I have to use an external database in order to pick the priorities from the employees or I can do it via “user specific columns” ?
Second: how can I make an auto automation to process the data? (how can I apply the “placement algorithm”)
Third: how can I set a different types of users? (employees and employer)