Skip to main content

Tables

Examples and information on using tables.

Definitions:
Concept

Knowledge Acquisition Tool

One of the most frustrating things in SAP implementations. is the amount of knowledge that gets hidden in emails. And when you need it, it is a search and a scramble to find the information in time to respond to a query 3 months later. To address that, I have developed the linked CODA document. I called it Knowledge Acquisition Tool, because it is not about Knowledge Management, it is to facilitate and improve the process of developing the knowledge in the first place.

It also does not replace the other repositories of information in a typical SAP (or... (More)

Task lists

The first thing EVERYBODY does when they start with a no-code app, is to do their own, unique version of a task list, and a project manager.

And yes, I did too.

End-user version of task list on steroids With pretty pictures, ready to use.

Maker version of task list on steroids A version for makers, with everything in one page, making it easier to cut and paste from the document.

What was important for me was to keep it simple, so at this stage, I only make use of one table to store tasks. (There is one or two... (More)

Show the maximum value of each group in a table.

One often has the need to show the largest value of a subgroup of records.

In this Coda Archive doc, the person wanted to make notes for stock symbols, and have a view where only the most recent note for each stock symbol is shown.
(But the applications are endless: the best student in each class in the form or grade; the winner of each even at an athletics meet, etc.)

Please refer to the document for an example implementation.

Step 1 Add a column to determine the latest date for each stock symbol.

Step 2 Add a column... (More)

The simplest method to have a checklist for a column in a table, is to make use of the Select List column type.

There are various options that can be used, e.g, storing the options in a separate table, allowing multiple entries per row.

Search for the page "Table Joins and Lookups" in the doc below.