Is there a way to create uniqueness constraints for an Entity? For instance, I would like a Contacts DB where each contact’s email is unique/primary key, so that an automation that tries to create a new contact with an email that already exists should fail. Or is there some trick i can use to get t…

Unique values for fields released today as experimental [image] May 8, 2025 / New "this week/..." filters, Unique field values (experimental) Changelog We are back from the Spring holidays season and can finally release something (many large things are in prog…

Fibery does not currently have validation rules (e.g. uniqueness, required fields, range-checking etc.) You can implement automations that flag up violations, but there is no enforcement mechanism.

Is there a feature request for this? I feel like I saw one but can’t find it now. Having a unique/primary key constraint for new entities is high up on my feature wishlist.

[image] Unique data fields Ideas & Features In our customer management system we assign customers unique ID derived from our accounting. I have created a field for this, and already made a misstep of creating a duplicate customer as I could not find them in my list at fir…

You could define a Rule to flag “illegal” entities like so (where ‘Pages’ is the DB, and ‘URL’ is the unique field): [image] It sets the violating entity’s name like so: If( Pages.filter(URL = [Step 1 Page].URL).Count() > 1, "**DUPLICATE** " + [Step 1 Page].Name, [Step 1 Page].Name )

Has there been any progress on this request? Validation is vitally important to using this software in production. Without it, one can only rely on this as experimental or prototyping software.

Have there been any changes regarding the validation of fields? Even just forcing users to fill in a field would be better than nothing. Any updates on this?

There is nothing to report, I’m afraid.

[image] cleghornp: Even just forcing users to fill in a field would be better than nothing. Any updates on this? You can always require a value for a given Field now: February 20, 2025 / 👮 Required Fields, Comments on Whiteboards, Asana integration, some permissions improvements .

Uniqueness constraints for Entities?

Get Help

Chr1sG February 8, 2022, 7:58am 4

Topic		Replies	Views
[DONE] Enforce unique entries + Data validation + Required fields Ideas & Features	12	338	May 8, 2025
[DONE] Unique data fields Ideas & Features	8	1887	May 8, 2025
[DONE] Validations / automations Ideas & Features	14	399	January 22, 2026
Issue: New relation suggests creating existing entity, which leads to duplication Bugs & Issues	9	358	August 18, 2023
Form Improvement: Duplicate Check Ideas & Features	8	628	May 8, 2025

Uniqueness constraints for Entities?

Related topics