Committee user management and site activity.
Members with login access to gated pages. Change roles here — the profiles table updates immediately.
| Name / ID | Role | Change Role |
|---|
SOMA/standards/soma-auth-profiles-admin-write.sqlSend a magic-link invitation so a new member can access gated pages.
Bug reports and feature suggestions submitted by committee members, with Bill's analysis and Greg's approval queue.
View Recommendations Admin →Members submit these directly through Bill (the AI widget). They route here for Greg's review before any action is taken.
| Date | Type | Description | Member | Page | Status |
|---|
CREATE TABLE IF NOT EXISTS public.bill_feedback (
id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
type text NOT NULL CHECK (type IN ('bug', 'feature')),
description text NOT NULL,
member_name text,
member_email text,
page_context text,
assistant_id text DEFAULT 'legends-bill',
source text DEFAULT 'bill-widget',
ip text,
user_agent text,
status text DEFAULT 'new',
created_at timestamptz NOT NULL DEFAULT now()
);
ALTER TABLE public.bill_feedback ENABLE ROW LEVEL SECURITY;
Responses from the Member Needs Assessment form, stored in Supabase.
| Submitted | Name | Membership | Source |
|---|
SOMA/standards/soma-assessment-submissions.sqlControl whether each resource is open to everyone or restricted to committee members. Changes are saved to the server immediately.
This page is restricted to site administrators. If you believe you should have access, contact Greg Foster at gfos44@gmail.com.