How to let public users suggest additions to data & then we approve the data to be added

[coastal]

I have a simple bibliographic app that is publicly accessible. It uses Glide Tables for the data. The data fields are Title, Author, Date, and a few other basic things like that. I want a button that enables public visitors to suggest a new bibliographic record to be added. I need to approve the record before it is actually added. Is this possible, and how would I do it?

[ThinhDinh]

• Add an “Approved?” boolean column to the table.
• Add an If-Then-Else “Status” column, if "Approved’ is checked then return “Approved”, else “Pending Approval”.
• Add a form that is visible to users, let them add the fields required.
• On a separate tab that is only visible to Admins, add a collection targeting the table above, group by the “Status”.
• Add a switch in the details screen/edit screen of each record so you can approve/unapprove a post.
• If you want to add posts yourself as well, create a form in the Admin screen, copy the components from the users form, but add a switch pointing to the “Approved” column and have it defaulted to true.
• Alternatively, you can let the Admin use the same form as the Users, add a “Default Approval” column to the User Profiles table, if “Role” is Admin then true, else leave it empty. Use that as the default value for the “Approved” switch.

[coastal]

Thank you so much, ThinhDinh! This is great – extremely helpful!