Permissions to allow uploading to records without making changes to table

Probably the best way to do this with built-in Airtable functionality is to use the form view.

But — here’s the catch — Airtable forms can only create new records in your system, so you’d have to be a little bit creative with this:

In your main “assets” table, you could create a link to ANOTHER table that would be used for the client-facing information (your “client’s provided information” tab). Then, you could base your form on that new table, instead of the assets table.

So then, whenever they create a new record in that new table by submitting the form, their data will automatically be linked back to the “assets” tab, because you have already setup the links ahead of time in your database. So each asset will reflect the new information & the new attachments that they just submitted on the form.

Some caveats with this:

1. When they’re choosing an Asset to update, they will see a list of ALL the assets in your system, not just their own personal assets.
2. They can’t go back in afterwards and UPDATE old data that they have submitted, or even update existing data that you have already typed in. The form will only let them submit NEW data into your system.

If you want to give them the ability to update old information, and possibly even restrict them to only seeing their own personal assets, then check out this tool: Stacker. What’s cool about this app is that it lets you create your own set of user accounts on their website based on a field in your Airtable base, so people can log in & only see their own Airtable records in your system.

(If you go down the Stacker route, it can be a little tricky the first time you set it up, so if you need an Airtable consultant to help you in setting this up, feel free to send me a private message.)

We’ve built a client portal for Airtable. You can use it to allow users to login and update their records. You can select which fields they’re allowed to update (or just see).