Rambling Pete's (Makers) Shopping List on Steroids

Rambling Pete's Task List on Steroids- Maker version

Under dev - Buttons and forms

Explore

Rambling Pete's Task List on Steroids- Maker version

A flexible todo list that starts simple, but provides great flexibility

Piet Strydom

General Note: This document is contained in a single page which is not the way an end-user product would typically be developed. The reason is to make it easier to cut and paste. It is intended to be a building block that can be mixed and matched with other building blocks that I am developing, or your own Docs. For example, I am also working on a building block to manage real estate rentals. The real estate rental building block will have a very simple to do list, but if needed, that can be deleted, and the Steroid Shopping list copied in. (Some assembly required.) Feel free, once you have copied the document for your own use, to organise and beautify the document in any way you see fit. For example, if you copy the different views each to their own page, the links will be clearer to use.

A “pretty” end user version

is at this link⁠

Click on the relevant button to add a new item to the task list.

⁠

Add/ View Simple Tasks

⁠

Add/ View Appointment

⁠

Add/ View Birthdays

⁠

Add/ View General Todo

⁠

Overview/ Readme

Executive summary

⁠

Very Simple Tasks⁠

Birthdays⁠

Appointments⁠

General Todo List Simple⁠

shopping list⁠

ProjectLite View⁠

gantProjectLite⁠

⁠

Rambling Pete’s Shopping List on Steroids is designed to be a very simple to use list to manage date driven tasks.

You start out by creating

Very Simple Tasks⁠

with just a task name, a date and a checkbox to mark completion. It is also very simple to capture

Birthdays⁠

. Add the person to the colPerson column. (The name will be added to a checklist, and will not need to be captured again). Once you have sent your congratulations, click on the “Move to Next Year” button to schedule a reminder for next year.

The next step up is probably to schedule

Appointments⁠

. Obviously for this a time is needed as well. Add the topic or purpose under colTask, e.g. the doctor’s name if it is a doctor’s appointment. In colPerson, add the person for whom the appointment is, if not for you.

Having three separate lists, does not seem very simple, does it? However the simplicity comes in that all of these lists, are stored in the same table. So far all that we have done, is to use views of that table, tailored to the specific list that we want to maintain. To see everything that needs to take place on a specific day, use the

General Todo List Simple⁠

view to see everything that needs to happen for the next few days. You can select at the top of the view the number of days into the future that you would like to see. Note that now the view is grouped by the date, so that all of one day’s activities is in one block. This enables increasingly complex topics to be added, while keeping everything still in one table, with the option to see everything in a single view.

Topics. To be able to group the tasks into different views, each view was assigned a default Topic, SimpleList, Birthday and Appointment so far. Other entries that are available to use in the standard implementation is Shopping List, Reading List and Other Topics.

If you want to create your own Topics, you can do so by simply typing it into the colTopic column. This is handy if you want to group together a number of tasks. (Much more on this later on.) These Topics will show up in the General Todo Lists. You can also create your own View that filters only that topic, so that you can see them all grouped together.

You can also use this todo list to manage your

shopping list⁠

. By default the Topic Shopping list is EXCLUDED from the General views, as a 20 item shopping list will just clutter the list. If you would like to have a reminder in your General views, create an entry with the Topic “Other Topics” with the task do Grocery shopping or something similar. The Shopping view (as all other views) can be called up on your mobile, and the items mark as completed as you purchase them.

The Shopping List View adds four new columns. The first is the column colExplanation. This is a generic column for any comments on any of the lists. For the Shopping list you could use it to split the list between different stores. The column colItemDescription is where you record the items to be purchased. Again, this has a check table behind it, and once you have added an item to the list, it will always be available for reuse. The last two columns are self explanatory - a quantity and a unit of measure column.

As mentioned before, sometimes several tasks are related to each other, and you would like to keep track of them. As an example, there is a colTopic Project1, with an accompanying

ProjectLite View⁠

. I have created a simple project to purchase a new property. New on this view are two sub task columns that will give you three levels of details in the project. The next new column is called Details Page. This is a free text column, anything can be recorded here. In this example, it links to an area lower on this page where information about the Property Search can be recorded. Any URL, e.g. the agent’s website, could also be recorded here. The time column is back, in case one of the tasks is an appointment.

Record the tasks that needs to be performed as required. The report is groups by Topic, Task, Sub task and sub task 2.

However, it is always good to have a Gant view as well, especially if some of the lower level tasks overlap with ones in other groups. This is shown in

gantProjectLite⁠

. And in this view, it immediately stands out that the last task “Make Decision and Make Offer” needs attention, because on the 16th the meetings with the experts have not taken place yet. So either the meetings needs to be scheduled earlier, or the decision postponed.

Using the filter control at the top of the Projectlite View, it is possible to switch topics. Bear in mind that for the Gant chart to work, both a start date and the duration must be maintained.

vwVery Simple

vwVery Simple

⁠

Birthday Range :

Jan 1, 1 - Dec 31, 3999

⁠

vwBirthday

vwBirthday

⁠

vwAppointment

vwAppointment

⁠

Date Range for General Todo List :

Nov 17, 2024 - Nov 17, 2025

⁠

vwGeneral Todo Simple

vwGeneral Todo Simple

⁠

vwShoppingList

vwShoppingList

⁠

colTopic :

All

⁠

vwProjectLite

vwProjectLite

colTopic

colTask

colSubTask

colSub-task 2

Details page

Completed

Activity Date

Time

colPerson

colExplanation

End Date

Duration

Task 1

2021-02-06

1 day

Task 2

2021-02-06

1 day

Other Topics

Medical Savings Account - When was it paid out

1 day

Build the financial planner overview

1 day

Weekly Planning

2020-12-07

1/6/1900, 12:00 AM

1 day

Monthly Invoice

2020-12-23

12/27/2020, 12:00 AM

Talk to Attorney

Follow up

2020-12-08

1 day

Personal

Check Disability Policy

2020-12-04

Request new policy from 1-800-297-2012

1 day

Build Financial Planning Overview

1 day

Project1

Review Available properties in price class

Review what is available on the web.

⁠

Property Search

⁠

2020-12-05

1 day

Visit Property in Johanneburg with Agent

⁠

Property Search

⁠

2020-12-08

11:00 AM

Agent1

1 day

Visit property in Mumbay with Agent

⁠

Property Search

⁠

2020-12-14

4:00 PM

Agent2

1 day

Compare and evaluate properties

2020-12-17

1 day

Meet with experts

Valuation expert

⁠

Decision Working Papers

⁠

2020-12-16

10:00 AM

Expert1

1 day

Consulting Engineer

⁠

Decision Working Papers

⁠

2020-12-16

3:00 PM

Engineer1

1 day

Make decision and make offer

2020-12-15

1 day

Appointment

2023-10-27

Spoiled Brat

Grandfather

1 day

Dr O’Barr

2021-08-01

11:00 AM

Ester Strydom

1 day

Bible Study

Revelation

2020-12-06

10:00 AM

1/6/1900, 12:00 AM

1 day

2020-12-08

Alta Jacobs

1 day

Birthday

2021-02-24

Jan Strydom Jr

1 day

2021-03-01

Ester Strydom

3/1/2021, 3:00 PM

1 day

2021-03-10

Dolf Strydom

1 day

2021-03-14

Jan Strydom Sr

1 day

2021-07-19

Ri Strydom

1 day

2021-08-24

Ruben Strydom

1 day

2021-12-01

Piet Strydom

12/1/2020, 3:00 PM

1 day

2021-12-02

Diederik Basson

1 day

2021-12-03

Marina Otto

1 day

2021-12-04

Hennie Symington

1 day

2021-12-07

Andre Kennard

1 day

2023-12-01

Piet Strydom

1 day

Update new Facebook Birthdays for next week

2021-12-07

Jon Hayes

1 day

Coda Customer

Tattie

1 day

Jan

1 day

Brigitte

1 day

CODA Quick Examples

Lookups and joins

⁠

Quick Examples Coda doc

⁠

2020-12-07

2:00 PM

1/6/1900, 12:00 AM

1 day

CrossDoc Integration

⁠

Quick Examples Coda doc

⁠

2020-12-07

1 day

Video on Table editing

⁠

Quick Examples Coda doc

⁠

2020-12-08

2:00 PM

1/6/1900, 12:00 AM

1 day

CODA Templates

Shopping list

1 day

Rentals

2020-12-03

1 day

Recipes

1 day

Create Meal scheduler

1 day

Reading List

⁠

Book: Thinking in Systems

⁠

2020-12-03

1:00 PM

1 day

⁠

Book: The Chimp Paradox

⁠

Vino Coaching

1 day

⁠

Book: Molecules of Emotion

⁠

1 day

⁠

Book: The Great Mental Models - General Thinking Concepts

⁠

1 day

⁠

Book: Personality isn't Permanent

⁠

1 day

⁠

Article: Stages of Parkinsons

⁠

1 day

⁠

Article: Nine Types of Ants

⁠

1 day

⁠

Article: Why are we so negative

⁠

1 day

Shopping List

Bible Study

2020-12-05

1 day

SimpleList

Task 1

2020-12-07

1 day

⁠

gantProjectLite

gantProjectLite

⁠

The below view allows you to prioritise unscheduled Topics. My definition of unscheduled topics is as follows

When I do not have a specific date yet when a topic needs to be done, I enter it with an entry in the “colYear” column, rather than the “Activity date” column. Optionally you could also add a quarter or month.

On a regular basis I go through this view, to see what is to be done next, and refine the colYear and Period if necessary. If a Topic needs to be addressed soon, I fill in the “Activity date”. Once the Activity date is added, the entry will appear in the General Todo Simple view for day to day follow up. Longer term topics are grouped into year = 10000, and 40000 for even longer term projects, ideas.

A topic can be divided into tasks, tasks into subtasks, and subtasks into subtask2s, which allows for a simple project view with 3 levels of additional detail.

Topic also have a lookup table called lkupTopic, which will provide a simple list of topics. If a list of topics with some detail is required, create a task entry for each topic with a unique identifier, say ZZZZ, fill the fields needed, and then create a view that filter on Task =ZZZZ.

Funnel View

Funnel View

⁠

Property Search

Record details of the property search here

Property in Johannesburg

Location

Quality

Tenants, etc

Decision Support Information

Return on Capital

Rate of return

Risk

Tables

Technical stuff lives here

Activity Date:

Jan 1, 1 - Dec 31, 3999

⁠

List Table

List Table

⁠

lkupShort Description

lkupShort Description

⁠

lkupTopic

lkupTopic

⁠

tabPeople

tabPeople

⁠

Year Selections

Year Selections

⁠

Add Birthday

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.