@varun - I believe you can actually achieve this using Airtable Interfaces. Some caveats are that your users can see the names of all other users who have access to the base and that they need to access the interface with an Airtable login that you will need to manually add to their user record. And you'll need to be on the Pro plan yourself to restrict users viewing the other base data.
First set up your base with a "Members" table that includes a 'User' field type. In your main "All Details" table, add a 'Member' field that links each record to the respective member in the "Members" table. Then add a lookup field for this 'Member' field to add the 'User' field from the "Members" table.
Then in the main "All Details" table, add an 'Edit' button using native Airtable forms and automations (detailed here in the community forum) or you can use Fillout.
Now set up your Airtable interfaces with two pages or views. In the first "All Details" page, this is for members to see everyone's details, so you won't show the 'Edit' button. On the second "My Details" page, you will show the edit button but most importantly, you will need to only show specific records by adding a filter where the 'User' lookup field is exactly the 'Current user'.
After you publish the interface, share it with all your members with the 'Read only' permission. And when they log into the Airtable Interface, they should only be able to see the 'Edit' button for their details on the "My Details" page.
In terms of the order you need to add your members to the 'User' field, they can be added upfront if they already have an Airtable account. Otherwise, you'll need to share the interface with them first and after they've signed up with an Airtable account, you will then need to re-add them into "Members" table's 'User' field.
I haven't test this on 500 members, but it does work for a handful of users I test it on.
