Autofill form field based on user input

[Alex3]

Hey there!
We’re trying to make our team check and update their own info already recorded in a table.
Everyone will get a unique user and password.
Let’s suppose John signed in correctly… the form will check if his user and password does exist and will show some fields like his full name, address,… that are in the table. Now John can update his info if needed.

Is there a way to populate the fields based on the table’s records?

Thanks in advance.

[ScottWorld]

Welcome to the community, @Alex3!

It depends on how much security you need for this.

Do you want to make sure that nobody ever sees the rest of your Airtable base, and that nobody ever sees other people’s information? If so, then you would need to use a portal tool like this one from MiniExtensions:

miniExtensions for Airtable

miniExtensions Portal for Airtable

Share records with people without giving them full access to Airtable. Limit them to only see their records and allow them to update some parts of the records.

If you don’t really need the security, and you’re just looking for a more user-friendly interface for your Airtable base, then you can turn to Airtable’s new Interfaces feature to do this, and filter your records by the currently logged-in user:

Airtable

Getting Started: Airtable Interface Designer | Airtable Guides

A step-by-step guide to getting up and running on interfaces and sharing them with your team. Get started on Airtable’s Interface Designer today!