How to make the DNI field unique in Softr databases?

Ask the community
1

Hello everyone!
I’m creating an app using Softr’s databases.
I need the ID (in my app, I use the client’s national ID) to be unique so that when creating a record, it doesn’t create redundancies (the system won’t allow a client with an existing ID to be entered into the database).
I can’t find an option in the database to make it unique.
If you can help me, I’d appreciate it. Thanks!

2

Hi,

Is it what you are looking for?
This field gives a unique ID to a record

Capture d’écran 2025-07-22 230318
Capture d’écran 2025-07-22 230318541×563 26.6 KB

3

Hello!
I understand that the Record ID option provides a unique ID per record.
But I want my record ID to be a text/number that I define. The Record ID option generates a non-editable text.
I’m looking for an option in Softr that prevents the generation of a new, existing ID.

4

Is there a best practice to implement UNIQUE constraints on other fields?