I took a look at the Airtable Universe (love this place) to see if anyone had already created something similar and found this Family Chore Tracker example. I'm not 100% sure if it solves all the things you were hoping to achieve, but I thought the views by kid as well as the chore point tallies were handy. At the very least, maybe its something to borrow some inspiration from. Source: about 3 years ago

I prepeared this comparison table for my own clients, featuring Glide, Stacker, Noloco, Softr. Source: about 1 year ago

What we use at a series B startup that actually helps our sales & customer service teams leverage Airtable without needing engineers 1. Stacker: No-code software builder tool on top of Airtable. Build internal tools for user-facing interfaces 2. Mini extensions: Useful extensions on top of Airtable for common use-cases 3. Bracket: Pull your database data into Airtable and write back to your database from Airtable.... - Source: Hacker News / about 1 year ago

You could and probably should build your own portal using: Noloco, Stacker, Glide. Source: over 1 year ago

You should really try building one using Glide Apps, Stacker, or Noloco. Source: over 1 year ago

Because you mention integration with spreadsheets, I think this is a perfect idea to develop a bespoke CRM with platforms like Glide Apps, Softr, or Stacker. Source: over 1 year ago