User Tools

Site Tools


thenthat

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

  1. Recognition: mandatory steps for Clinic to subscribe to user
    1. Client performs lookup for the Clinic “NewClientRegistration”, fills up data
    2. Clinic is subscribed to objects of type “NewClientRegistration”, human verification is likely necessary
    3. Clinic creates targeted “Welcome” message, with links to various services
  2. Slots creation
    1. Publisher (Secretary in the Health Clinic) creates slots document:
      1. 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
      2. The document is uploaded using web interface.
      3. Publisher receives WebDAV link, so he can edit the file
    2. Publisher subscribes for targeted objects of “WantToReserveSlot”
    3. Client discovers “registration” page and creates targeted object “WantToReserveSlot”
    4. Publisher confirms user's identity and fills up rows in the excel file - probably using WebDAV, to lock the document properly
    5. Publisher creates targeted object “SlotReservedSuccess” for user with link to the excel file.
    6. 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.
  3. Human notifications to the document
    1. The document is then inotify monitored. On change “DocumentChanged” is created.
    2. User receives the “DocumentChanged”. If Anchor/Needle is specified, additional check is done.
    3. TBD: InteractiveNotification with Answer Options
thenthat.txt · Last modified: 2025/04/01 20:40 by arie

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki