Unique User ID

[tuajahf]

Hi, 

How can I make that when a new user signs up he gets a unique ID in the Accounts table and every time he adds a new record in other tables his ID shows in the column?

[MattZaporator]

You can create a column of the type Created By which will always be tied to that user.

[kuovonne]

You can generate a unique ID by using either an Autonumber field or a formula field with RECORD_ID().

As for guaranteeing that his ID shows up in other records you create, it depends on how he is creating records. Are you using a portal? Is he entering records via forms? Is he creating records directly in Airtable while logged into Airtable?

If he is creating records directly in Airtable, you can use a {Created By} field that will be associated with the user's Airtable account. You could then have a table that matches the Airtable user account to your ID and an automation to create any links. On the other hand, you would have to pay Airtable for every user.

If you are using a portal system, look into how the portal creates records.

If you are using Airtable forms, you could do some things with prefiiled fields and/or requiring the user to be logged into Airtable and using a {Created By} field.

[CristianCG]

Hi there!

At miniExtensions, we've created a third-party portal that integrates seamlessly with Airtable. You can set any field, such as an email or an auto number field, as the primary identifier, and our portal automatically links created records to the logged-in user. There's even an audit trail that tracks the last user who modified a field!

Users will be able to view and manage records linked to them, but you can customize permissions as needed and use any combination of fields as login credentials.

For user management, you can create forms for new user registrations, automatically create accounts when someone logs in, or manually create users. You can also allow users to update their full profile or just specific fields.

I hope this helps! Feel free to try all of these functions with a free account at miniExtensions 👍