Has there been a feature wherein you can filter records that are related to me?
any chance to do this?
I don’t think it is doable so far.
I had a guess at the API creating your views in a detached synchronised base. But it seems the API can’t create views… Too bad.
The only ways I am seing right now for you are :
Creating a softr app (or something like that) so that they can only access the data with their account. You can then filter the data within softr. It is the cleaner, but longer and more expensive approach.
Manually creating the 400 views they need… sorry… Each of them could do that in a detached synced base if you give them access to this base only, before removing their access, then adding syncing the data. It doesn’t seem to be what you need.
Creating a shared view and sending them a prefilled link to the view with a filter. That a MAJOR security breach and probably not what you want, as they would only have to change the filter parameters to access the data. But maybe you can do some extract of the data using a script ?
Manually creating the views prioritizing their need of that view and doing that painful job time to time before Airtable creates such a feature…
Good luck with that, let me know what you did.
Hope there is another solution !
Given the requirements you stated, you cannot currently use interface designer. Interface designer requires that everyone have at least view access to the entire base.
It also isn’t clear how you identify “records they have created”. Airtable has a “created by” field that shows the collaborator that created the field. However it sounds like your 400+ people are not collaborators on your base, and thus you need something other than a “created by” field to identify who created each record. This is probably a linked record to a users table.
I recommend using a portal (Softr, MiniExtensions, Stacker, Pory, etc.) and giving everyone their own login.