Help

Re: Allow individual to Update his/her Record

156 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Airtable_Admini
4 - Data Explorer
4 - Data Explorer

I have a base called "All Owners."  How do I allow the individual records within that base to see and update their information ONLY?

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Most people do this with Fillout’s advanced forms for Airtable.

Fillout is 100% free and it gives you the ability to update Airtable records from a form, so you would give each person their own unique Fillout link to their own record.

Fillout also offers hundreds of advanced features that Airtable’s forms don’t offer.

Otherwise, if you want to pay for your users to have Airtable accounts, then you could create an Airtable interface which is filtered by the email address of the currently logged-in user. Then, you would share that interface with them, and they could update their record that way.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

TheTimeSavingCo
18 - Pluto
18 - Pluto

Try using an Interface for that.  You'd set up a 'User' type field and make sure each record was tagged with the correct user, and you could then create a filter in the Interface that only displays the records that are tagged to the logged in user:

Filter current user.png

As each user can only see their own records due to the filter, they'll also be the only ones who can edit them.  Note that this would require all of the users to be paid though

---

If they're not paid members you'll need to find another way for them to edit the data, and for this you can try using Fillout (https://www.fillout.com) which allows for 1000 free submissions a month, where each record will have their own unique link via a formula field.  You'd show this field in the Interface and so each user would be able to click on the form link and make edits.  Again, since each user only sees their own records they technically will only be able to edit their own records.  If any of the form URLs get into the wild then anyone will be able to make edits with that form URL though

You could also attempt to keep it in house by using Airtable's forms, but it's more tedious to set up (https://support.airtable.com/docs/use-case-update-records-via-a-form) so if you're expecting fewer than 1k submissions may as well just use Fillout really