- Add a column called “Admin” in the Tasks table, always write “Admin” to that column when you create a new task. You can follow these steps.
-
Set that column as “Row owner”.
-
Also use a special form value to pass ̶t̶h̶e̶ ̶r̶o̶w̶I̶D̶ of the user who created the task to the Tasks table. (Edit: pass the email, not the rowID)
-
Also set that column as “Row owner”.
-
In the Users table, make sure you have already set the “Role” column with values being Admin and Members.