I created this quick demo to show that such thing is indeed possible. The code is not optimized but the goal is to show possibility. Of course I did not code all possibilities of the sign in process but enough for the demonstration to provide meaningful results.
The project is using Local Data Source but the same blocks would be valid for Airtable.
Happy Thunking