====== ThenThat ====== ===== Subscribe to atomic changes in excel spreadsheet ===== Potential applications: * organizing event with attendance confirmations (wedding) * 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