Differences

This shows you the differences between two versions of the page.

--- thenthat [2025/03/06 08:07] – [Subscribe to changes in excel spreadsheet] arie
+++ thenthat [2025/04/01 20:40] (current) – arie
@@ Line 1: / Line 1: @@
 ====== ThenThat ======
-===== Subscribe to changes in excel spreadsheet =====
+===== Subscribe to atomic changes in excel spreadsheet =====
-  - "register" document in web UI, get link to samba share
+Potential applications:
-  - upload document
-  - Set update triggers in the web UI using "anchors" (row) and "needle" (the content cell)
+  * organizing event with attendance confirmations (wedding)
-  - The document is then inotify monitored. On change subscribeable "DocumentChanged" and "FieldChanged" shard is created.
+  * appointments cancellation or timing change in Health Clinic
+  * update of debt in house commitee
+  * important notification that members must confirm receival
+  * results of exam
+  * work shifts changes notifications with confirmation
+==== Health Clinic appointment Flow ====
+  - Recognition: mandatory steps for Clinic to subscribe to user
+      - Client performs lookup for the Clinic "NewClientRegistration", fills up data
+      - Clinic is subscribed to objects of type "NewClientRegistration", human verification is likely necessary
+      - Clinic creates targeted "Welcome" message, with links to various services
+  - Slots creation
+      - Publisher (Secretary in the Health Clinic) creates slots document:
+        - Prepare excel document with empty slots. The slots must have field "State" with possible values "Taken", "Free" or "Canceled". A daily template might be used
+        - The document is uploaded using web interface.
+        - Publisher receives WebDAV link, so he can edit the file
+      - Publisher subscribes for targeted objects of "WantToReserveSlot"
+      - Client discovers "registration" page and creates targeted object "WantToReserveSlot"
+      - Publisher confirms user's identity and fills up rows in the excel file - probably using WebDAV, to lock the document properly
+      - Publisher creates targeted object "SlotReservedSuccess" for user with link to the excel file.
+      - User chooses whether to subscribe to changes in the file. He might filter changes to individual rows, for example using the row data as "Anchor" and field "State" as Needle.
+  - Human notifications to the document
+      - The document is then inotify monitored. On change "DocumentChanged" is created.
+      - User receives the "DocumentChanged". If Anchor/Needle is specified, additional check is done.
+      - TBD: InteractiveNotification with Answer Options