Hi everyone 
I’m building a mobile planning board app in AppSheet, using Google Sheets as backend.
The idea is simple:
-
Show a calendar view with all work entries.
-
When I click a date, the app should:
-
Save the selected date in a “context” table
-
Filter all entries by that date
-
Open a daily table view showing only those entries.
-
Data Structure
Table: eintraege (entries)
| Column | Type | Description |
|---|---|---|
| id | Number / Key | Unique ID |
| datum | Date | Work date |
| baustelle | Text | Project |
| mitarbeiter | Text | Employee |
| taetigkeit | Text | Task |
| sonstiges | Text | Notes |
Table: tageskontext (date context)
| Column | Type | Description |
|---|---|---|
| id | Number / Key | 1 |
| datum | Date | Currently selected date |
The tageskontext table always contains exactly one row with the active date.
App Logic
Calendar View
-
Type: Calendar
-
Data:
eintraege -
Start date:
[datum] -
Row selected → Action:
SetzeTageskontext
Action: SetzeTageskontext
Used to update the selected date in tageskontext:
For: eintraege
Do this: Data → set the values of some columns in another table
Table to update: tageskontext
Referenced rows: SELECT(tageskontext[id], TRUE)
Set these columns: datum = [datum]
Slice: Eintraege_Tagesliste
Filters entries for the current day:
[datum] = ANY(SELECT(tageskontext[datum], TRUE))
Daily Table View
Type: Table
Data: Eintraege_Tagesliste
Shows only entries for the selected date.
Problems I’m running into
The action type “set the values of some columns in another table” doesn’t always appear.
Clicking a date doesn’t always refresh the daily list.
The “Overlay” display position is missing.
Sometimes I get this error:
“The column 'id' cannot be modified.”
My Question
How can I correctly configure AppSheet so that clicking a date in the calendar:
Saves that date in tageskontext,
Filters all entries by that date,
Opens a table view showing only those filtered entries?
Goal: Fast and mobile-friendly planning app (Google Sheets backend, no Streamlit or PostgreSQL).
Any help or working example for this setup would be amazing
