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?
- 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.
Thank you so much, ThinhDinh! This is great – extremely helpful!