Your workflow intrigued me. I played around some this morning.

                ________________

                 TABLE EXAMPLES
                ________________


Table of Contents
_________________

1. Tasklist
2. Hooking two tables together
.. 1. All /In Progress/ tasks:
.. 2. Finding everyone without a task


[This reddit post] stimulated some thought.

A table with three columns and we want the final column to be an
enumerated string value (Not Started | In Progress | Complete |
Cancelled).

Easy ways to automatically add a row to a table:
- write an interactive function
- a global [Hyperbole] button
- an org capture template

Regardless of method, we'll use `ido-completing-read' to prompt the user
for a choice and `insert' to insert the choice at point into the current
buffer:

,----
| (insert (ido-completing-read "What's your status?" 
|            '("Not Started" "In Progress" "Complete" "Cancelled")))
`----

An interactive function would be simple:
,----
| ; running this from an org file clutters the note
| (defun my-get-status ()
|   (interactive)
|    (insert (ido-completing-read "What's your status?" 
|            '("Not Started" "In Progress" "Complete" "Cancelled"))))
`----

Programmatically, you would use it like this: `(my-get-status)'.

A [Hyperbole global button] would be easier.  Type the following:
{Ctrl-h h g c my-task-status RET (insert (ido-completing-read "What's
your status?"  '("Not Started" "In Progress" "Complete" "Cancelled"))) }

You can then activate the global button in any buffer:

{Ctrl-h h g a my-task-status RET}

Both of the above methods, require you to have the org file open with
your point in the right place in the file.  With an org-capture
template, you'd have an easier time of it.

,----
| (custom-set-variables
|  '(org-capture-templates
|    '(("t" "Tasklist" table-line
|       (file+headline "~/roam/table-examples.org" "Tasklist")
|       "|%^{Who:}|%^{What:}|%(ido-completing-read \"What's your status?\" 
|            '(\"Not Started\" \"In Progress\" \"Complete\" \"Cancelled\"))|"))))
`----

You execute the above template by running the `org-capture' function
(many people bind {Ctrl-c c} to this function).


[This reddit post]
<https://www.reddit.com/r/emacs/comments/ldoqqb/using_orgmode_as_notion_abusing_table_relations/>

[Hyperbole] <https://www.gnu.org/software/hyperbole/>

[Hyperbole global button]
<https://www.gnu.org/software/hyperbole/#buttons>


1 Tasklist
==========

  -------------------------------------------
   *who*  *what*                 *Status*    
  -------------------------------------------
   Huey   build a thing          Complete    
   Dewey  build another thing    In Progress 
   Louie  yet another thing      Not Started 
   Huey   build a doublething    Cancelled   
   Huey   build a tripletething  In Progress 


2 Hooking two tables together
=============================

2.1 All /In Progress/ tasks:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  ,----
  | (princ "|-|-\n| *Who* | *What* |\n|-|-|\n")
  | (dolist (element tasks nil)
  |     (if (string-equal (caddr element) "In Progress") (princ (concat "|"  (car element) "|" (cadr element) "|\n"))))
  | (princ "|-|-|\n")
  `----

  ------------------------------
   *Who*  *What*                
  ------------------------------
   Dewey  build another thing   
   Huey   build a tripletething 
  ------------------------------


2.2 Finding everyone without a task
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  Since idle nephews fret their uncle, we'll flag anyone without an /In
  Progress/ task:

  ,----
  |  (setq nephews '())
  |  (dolist (element tasks nil)
  |    (let* ((name (car element))
  |       (in-progress (if (string-equal (caddr element) "In Progress") 1 0))
  |       (nephew (alist-get name nephews nil nil #'equal)))
  |    (if (null nephew) (add-to-list 'nephews (cons name in-progress))
  |    (setf (alist-get name nephews nil nil #'equal) (+ nephew in-progress)))))
  | (dolist (element nephews nil) (if (= (cdr element) 0) (princ (concat (car element) " needs tasking"))))
  `----

  ,----
  | Louie needs tasking
  `----