โFeb 24, 2023 05:19 AM
Hello,
I've built my database and it is currently working really well. I am now getting users to help grow the database. However, this information must be verified by me before it is directly updated in the database. Is there a possibility of adding the option of verification?
Thanks in advance.
Solved! Go to Solution.
โFeb 24, 2023 07:44 AM
Hey Taylor,
There's no real way to 'stop' data before it enters the system if someone is an Editor or Owner/Creator user-level. However, here are some options that will allow you to know what's being updated:
For creating new records, you can create an automation that automatically adds a Status such as "Pending" to each new record.
Then, you can create a View that filters the 'Pending' Status so you can review the information. The data will still be "in your base", but will be filtered and you can see what was added by someone before 'Accepting'
For updating existing records, giving Editor permissions will allow someone to edit records. While you can limit changes to your base layout (fields, etc), you can't limit record data that's edited. You can always use Airtable's Revision History to review what changes were made in a record.
You could create an Interface with only specific fields to be edited, but again no way to 'stop' the data from entering or changing.
To limit editing to specific records and/or fields, we also have an app, On2Air Forms, that lets you choose specific data that can be updated.
โFeb 24, 2023 12:36 PM
First, add a Single Select field with PENDING as an option. Then, create a View that filters records to show only PENDING as the Status. You could further filter this by adding a Created by field or Last Modified By field in your table and adding that to your View filter. This way only specific Users who create or update records get the PENDING status, instead of every record getting the Status.
Use the 'When a record is created' Trigger, then the Action would be Update Record
Your Action would be insert the Record ID into the Record ID field with the blue + icon, then select the Status field and choose PENDING.
Now every new record automatically receives a PENDING status.
Here's more information on Airtable Automations
โFeb 24, 2023 07:44 AM
Hey Taylor,
There's no real way to 'stop' data before it enters the system if someone is an Editor or Owner/Creator user-level. However, here are some options that will allow you to know what's being updated:
For creating new records, you can create an automation that automatically adds a Status such as "Pending" to each new record.
Then, you can create a View that filters the 'Pending' Status so you can review the information. The data will still be "in your base", but will be filtered and you can see what was added by someone before 'Accepting'
For updating existing records, giving Editor permissions will allow someone to edit records. While you can limit changes to your base layout (fields, etc), you can't limit record data that's edited. You can always use Airtable's Revision History to review what changes were made in a record.
You could create an Interface with only specific fields to be edited, but again no way to 'stop' the data from entering or changing.
To limit editing to specific records and/or fields, we also have an app, On2Air Forms, that lets you choose specific data that can be updated.
โFeb 24, 2023 11:18 AM
Thank you for your advice, I've been playing around with how to add the "PENDING". Could you please advise on the correct automation to put in place to enable this to occur correctly? I'm yet to have any luck with testing this out so far.
โFeb 24, 2023 12:36 PM
First, add a Single Select field with PENDING as an option. Then, create a View that filters records to show only PENDING as the Status. You could further filter this by adding a Created by field or Last Modified By field in your table and adding that to your View filter. This way only specific Users who create or update records get the PENDING status, instead of every record getting the Status.
Use the 'When a record is created' Trigger, then the Action would be Update Record
Your Action would be insert the Record ID into the Record ID field with the blue + icon, then select the Status field and choose PENDING.
Now every new record automatically receives a PENDING status.
Here's more information on Airtable Automations
โFeb 24, 2023 04:22 PM
Hi Hannah,
You're amazing! Thank you so much, I've just integrated it and it working perfectly.
โFeb 24, 2023 06:43 PM
Great! So glad you got it working!
โDec 05, 2024 09:57 AM
Hey there, if you prefer avoiding Airtable automations for this, our miniExtensions Form has a neat way of doing this, too. You can prefill any field, both on the form or hidden, from the form's configuration page, so any new record will have that field populated with the value you choose automatically. This takes just seconds to set up and doesn't require an Airtable automation to run every time. In contrast to conventional URL prefills for forms, this can't be overridden by your users either!โ
You can try this out now by signing up for a free account! ๐