Sheets

Title	Program	Status	Rows	Available	Updated

Programs

A program is a group of sheets that share PINs — one retreat, one class, one kitchen. Collectors get the Program PIN; the person in charge gets the Manager PIN too. Change a PIN here and every sheet in the program follows.

Name	中文	Program PIN	Manager PIN	Sheets	Note

← All sheets

Collector link

Sheet

Title

Note to collectors (optional)

Program (holds the PINs)

Status

Available from (optional)

Available until (optional)

Inclusive — collectors can write until the end of that day.

Collectors may add rows not on the list

Rows and columns what collectors see

Paste from a spreadsheet

First line = column headers. Copy cells straight out of Excel / Google Sheets (tab-separated) or CSV. A header named row_id is kept; otherwise rows get r001, r002, … Headers containing "amount", "price", "fee" or "$" become money.

Columns (JSON)

The first column is the row's headline. Types: text, number, money, date.

Rows (JSON)

Inputs what collectors fill in

Types: text, number, money, date, select (needs "options"), checkbox. Add "required": true to make one mandatory. Everything else is optional.

Entries

Open in new tab ↗