Simple Work Schedule List

I chose to create a solution to my jobs scheduling problem. The restaurant I work at is relatively new so there is no scheduling sheet or system. One day after work I had a talk with my boss about the scheduling issue. He said because of the current method which is just what we say to each other, it often leads to confusion. So I decided to create a simple work schedule list using honey code. In the list contains information about the employees like days/times they work, names and phone number to contact them if needed. It also includes an add employee tab incase my boss wants to add anymore employees to the list.

There are no physical materials needed for this project. All of the work was done within Honey code and Excel. The Excel spreadsheet to place and organize the information. And the Honey Code to implement the information from Excel into app format.

The first thing I did was layout the information in an Excel spreadsheet. On the "A" columns I placed a co workers name into each box. Then in the "A" rows I put the days of the week. The data you put in to this graph will be the times they work. This way the info is neatly organized and easily editable.

Once logged into Honey Code, click "create app", and then add a blank table and make it a 5x4. Type in the names, days, time and role like shown above. Then for column E you can copy the code shown in the formula bar. Make sure to type this code in each box under column E.

Click the tables menu and add another blank table. Make this one a 2x5. For column "A" title it "Phone Numbers" and then fill out the boxes with the phone numbers. For column "B" title it "Employee" fill out all the boxes with the names. When all filled out, right click on each box and select "Row & picklist" for the Format and the "Employees" table for the source.

Title the content box "Employees". Below that, click "Add objects" on the bottom left and add a button. Title the button "Add Employee" (Finishing the button will be in a later step). Now go back to the "Add objects" button and add 3 segments and 2 content boxes in each of them.

In the properties of the first content box paste: =Employees[[#Headers], [Employee]] into the Set shared source. In the box below this one, in the properties paste: =[Employee] in the shared source.

In the 3rd content box paste: =Employees[[#Headers],[Days]] into the set shared source. In the content box below, paste: =[Days] into the set shared source.

In the 5th content box paste: =Employees[[#Headers],[Time]] into the set shared source. In the content box below, paste: =[Time] into the set shared source. And paste =TRUE into display for all 6 content boxes.

Add a new screen and title it "Employee Detail". Insert 4 segment boxes, and 2 content boxes side by side in each one. In the 1st content box paste: =TRUE into the display. In the content box beside that put a "Input row" and paste: =FINDROW(Employees) into the set initial value. Staying at the same content box, go to display and select the format options as shown above.

For this content box paste: =Employees[[#Headers],[Employee]] into the properties tab. In the content box beside that paste: =[Employee] into the properties. One row down paste: =Employees[[#Headers],[Days]] into the properties tab and beside that paste: =[Days] into the properties tab. And the last row paste: =Employees[[#Headers],[Time]] into the bottom left content box then paste: =[Time] into the content box besides that.

Add a content box at the top title "New Employee". Then add 4 segments below with 2 content boxes side by side in each one. In the first content box paste: =Employees[[#Headers],[Employee]]. In the box directly below paste: =Employees[[#Headers],[Days]]. Below that paste: =Employees[[#Headers],[Time]]. Then lastly below that paste: =Properties[[#Headers],[Phone Number ]]. For each content box on the right side, go into properties and set format selection as auto and set visibility as: =TRUE.

Go back to the first employee screen and go into the properties of the "Add Employee" button. paste: =TRUE fore the set visibility. And in the actions tab, select "navigate to new screen" and select "New Employee".

Clicking the Honey Code symbol in the top left, it should show you what your screens look like from the app view.