Most suggested
Everyone's suggestions, counted. The tally shows titles and numbers, never who sent them.
- Loading…
Your suggestions
Only you can see this list. The database itself shows each person only their own rows.
- Loading…
How this form is built
The page posts to the pages-demo application's endpoint on this site's own address. The endpoint checks the fields and writes one row to the application's suggestions table.
Your email comes from your sign-in
The form never sends it. The database fills it in from the signed-in session, so nobody can make a suggestion in someone else's name.
Private rows, public counts
Row-level security in the database shows each person only their own suggestions. The tally comes from a database function that returns titles and counts only.
Checked twice
The endpoint checks length and channel before writing, and the table's own rules check them again, so a bad request can't slip through either way.
For a form open to the public, Plexara also has platform forms: the form is described in a script, and the platform validates each submission, adds a bot check and stores it before the script runs. See Public applications.