Hi guys, I’m new here and so far I’m quite impressed with Fibery - it has a huge potential. I did however react to one thing that baffles me: How come we cannot - in an easy way - prevent a field from having duplicate values? My use case is that we want to move our product database into Fibery, but …

Is this duplication of existing topics? [image] [PLANNED] Required fields on the layout Ideas & Features We have several types, where we need to be sure some fields are not empty. It would be great if we can mark fields as required OR create a validation rule if fields ar…

Hi Chris, By the look of it, these two topics should address Data Validation and Required fields. Sorry, I haven’t seen them. The most important function for me however is “Unique entries” as a field setting. [Field setting] E.g. say you have an automation set up where an article-number / SKU is…

I understand the issue, but it’s worth pointing out that (unlike when you create/update a custom icon) changes to Fibery entities do not require an explicit ‘save’ action by the user - the data is updated as soon as it is typed. This adds complexity to any solution that would be implemented. For e…

Would it be an idea to autosave the entry but make it inactive until the Unique-field has been entered correctly? Another approach: Would it be less complicated if you could only have one Unique-field per table? (I am aware you have the autogenerated key field, but that is not very useful if our ow…

[image] petugg: make it inactive I’m not sure what you mean by ‘inactive’. In Fibery, an entity exists or it doesn’t :person_shrugging: [image] petugg: I suppose that’s what you mean when you say gradually - one step at a time. :+1:

[image] Chr1sG: I’m not sure what you mean by ‘inactive’. In Fibery, an entity exists or it doesn’t :person_shrugging: I meant that it should exist but in a third state, like a draft of sorts. It would allow you to enter the whole entity, but until fields that are required or unique are corre…

[image] petugg: I meant that it should exist but in a third state, like a draft of sorts. It would allow you to enter the whole entity, but until fields that are required or unique are correctly entered, that particular entity won’t automatically be included in calculations, lookups, forms, view…

Fibery can do many things “in the background” via Automations and Integrations, including creating new entities, and there is not always a way for those operations to interact with a User, e.g. to warn them about a duplicate field value. The best that could be done in such a situation is probably t…

Unique field value across the whole database is in plans for Q1 2025

Adding a request: unique only within the entity. Within the project I want the Project Roles to all be unique from one another. But Project Roles can be can have the same roles, across different projects. Project + Role must be unique. Either alone do not need to be. Not sure if it’s within the scop…

[DONE] Enforce unique entries + Data validation + Required fields

Ideas & Features

Chr1sG December 16, 2024, 7:00am 2

Is this duplication of existing topics?

Topic		Replies	Views
Uniqueness constraints for Entities? Get Help	9	1033	May 8, 2025
[IN DEV] Validations / automations Ideas & Features	14	307	January 22, 2026
[DONE] Required fields Ideas & Features	23	2285	February 20, 2025
Form Improvement: Duplicate Check Ideas & Features	8	609	May 8, 2025
May 29, 2025 / Import a new Database, Require values in a Field to be unique, Add images in bulk on Whiteboard Changelog	19	565	June 19, 2025

[DONE] Enforce unique entries + Data validation + Required fields

Related topics