User Account -> Aggregated Table

Hello,

I have a simple question, I think. Apologies in advance if I have not explained this clearly. I am considering using AirTable for a specific application but don’t know if this is possible. I am trying to do a turn key system that will not require the manual step of setting up a user and sending a link for access.

1. User clicks on an a URL to setup an account
2. User receives email confirmation and logs into their account
3. User enters information into a form
4. Data is aggregated into master table
5. User has the ability to go in at anytime and update their account information as well as any data they provided

Thanks!