Chore App to Maintain Chores

I made an app that you can make and maintain chores. There is a calendar that can show when your chores are do. There is also an email notification bot just in case you need the extra reminder.

I made this app because my stepdad needed a way to maintain chores in the house because it is a mess.

You need a computer that is reliable.

These steps show how to set up a Google Sheet which is the baseline for the app.

1. Open Google Sheets and create a new document.
2. Name A1 ID, B1 Task Name, C1 Due Date, D1 Status, and E1 Person

This step shows how to make the app function and allows you to customize the app.

1. Go to Appsheet and link the Google Sheet
2. Name the new app “Chores App”
3. Click on the UX tab on the left side of the screen
4. Press the tab below Primary View
5. Press “table” below View type
6. Go to Sort by and put “Due Date” for the first box and “Ascending” for the second box
7. Go to Group by and put “Status” and “Descending”
8. Go to Display, go to the tab below Icon, type in “tractor” and choose any of the three tractors
9. Then go to Data then Columns and click on the box
10. Go through the things and make sure that it says and check mark the boxes in the picture above.
11. Press the little pencil next to the “Status” column and add the values “Incomplete” and “Complete.” Do the same thing with the “Person” column but place the people instead.
12. Go to your actual app and scroll down and click on the view
13. Scroll down and click on the ref view which includes your documents name then detail
14. Add card layout and you can customize how the task details can look in here, you can customize it by changing the header layout.
15. After you are done customizing the layout, go to “Quick edit columns” and add a column with “Status”
16. Go to UX then Format and create a new format rule
17. Name it Complete and type in the box below “If this condition is true” [Status] = “Complete”
18. Go down and press Task Name for “Format these columns and actions” and go to Visual Format and choose green for the text name
19. Do the same thing but for Incomplete and instead of green choose red.

1. This step may be optional but it will make a calendar that allows you to see when your chores are do.
2. Go to data and then slices and create a new slice
3. Name it “Incomplete Slice”  and put [Status] = “incomplete” in the row filter condition bar
4. Go to UX and make a new view called “Calendar” and press the calendar as view type and choose the “Incomplete Slice” as the box for “For this data”
5. Go to view options and mark the boxes as seen on above:
6. Go to display then the Icon and choose a calendar icon
7. Then go to UX and then Ref views then go to the App detail and copy it
8. Name the new copy Incomplete Detail and put “Incomplete Slice as the “For this data” box

This step is optional but it shows you how to make a bot that emails you the day before so that you know.

1.  Go to the Automation and then Bots
2. Make a new bot and call it “Email Notification Bot”
3. Press “Configure event” and type in “Email Event”
4. On the right of the screen, press the little gear symbol above your app, Press Schedule for Event Type, choose your app for the table.
5. Press Daily for Schedule and put a desired time to email you.
6. Turn on the switch below “ForEachRowInTable”
7. For Filter Condition type in (TODAY()+1)=[Due Date]
8. Add another step and enter “If [Status] is Incomplete
9. Below that box change Run a Task to Branch on Condition
10. For the box type in [Status] = “Incomplete”
11. Then below the Yes add a task and search up send an email to the app user and tap it
12. Then type in “Reminder!” in the Email subject
13. The final step of the email bot is to type in “ You have <<[Task Name]>> due tomorrow!”