Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 10, 2022 04:57 AM
Hi, I’m wondering if there is any way to create a form view in such a way that submissions can be made (by anyone with the link), but so that the record wouldn’t go live in another shared view until each entry was approved by a Moderator (i.e. me!)?
I can’t think of a simple way to implement this function, but wondering if anyone else has tried this approach and found a work around?
May 10, 2022 05:30 AM
That’s what filters are for. Change the filter on your shared view so that it doesn’t show the records until you approve them.
May 10, 2022 06:25 AM
Welcome to the Airtable community!
To expand on Scott’s recommendation, add a new field to your table, such as a single select field with the choices “approve” and “reject”. Do not include this field on the submission form.
When the submission is created, this field will be blank. You can then review the submission and approve or reject the submission.
Finally, in your shared view, set the filter to include only records where the field is “approve”.
Some people prefer using a checkbox field. I prefer a single select so that it is easier to see which records have been reviewed (and rejected) versus which haven’t been reviewed.