Table Pick Page
What TablePick allows you to do, is show a database, and allow you to select one or more items from the database, using a simplified view of the data. Once you have done this, the data is marked as in-progress.
You can edit in-progress items to mark them as completed.
This example uses stories from the Old Testament.
Can all this be accomplished with a sequence of pages and existing table technology?
I think so...
Old Testament Stories [edit section]
Here's a view of the table showing only unread items.Please choose a story to read from the following table: (Specifically, select Edit Table in Place, and change the state of the desired story to "reading")
| story ^ | scriptures ^ | state ^ | date_completed ^ |
| Ezra Rebuilds the Altar | Ezra 3:1-13 | unread | na |
| Jonah and the whale | Jonah 1:1-4:11 | unread | na |
Stories we're currently reading [edit section]
When you're done reading a story, mark it as "done" in the table, and fill in the date in date_completed.| story ^ | scriptures ^ | state ^ | date_completed ^ |
| Daniel in the Lion's Den | Daniel 6:1-28 | reading | na |
reference data [edit section]
data page [edit section]
The data for this table is on the following page: TestPickDataYou can see the raw data by selecting "Show in raw mode" from the toolbox in the left pane.
full view [edit section]
| story ^ | scriptures ^ | state ^ | date_completed ^ |
| The Red Sea | Exodus 14:5-31 | done | 2015 |
| Ezra Rebuilds the Altar | Ezra 3:1-13 | unread | na |
| Jonah and the whale | Jonah 1:1-4:11 | unread | na |
| Daniel in the Lion's Den | Daniel 6:1-28 | reading | na |
configuration block [edit section]
The configuration block for the TestPickData table is in this section, in a block names PickDataConf
PickDataConf source_spec=TestPickData field=state type=Select possible_values="""unread reading done""" field=date_completed type=Text default_value=na