The required fields (above) is a good first step in what we’re missing in our workspace, which is what I would call validations.
Validation is where a user is not allowed to take certain actions unless another condition is fulfilled. A few examples:
Only allow updating to state “done” when “rich text” field is not empty.
Only allow creating a todo if the deadline is also entered
When disapproving something (state = disapproved), a text modal appears where you need to state the reason why it’s disapproved.
Forcing certain items to be marked as done in a certain order. Ideal for checklists, where you want somebody not to finish task 2 before task 1 is done.
Only certain permission groups are allowed to update the budget field of a project
Some of these things are already possible with a bit of workaround, as @ChrisG already greatly helped us with. But would be ideal if this was natively possible, on a per-field basis. It probably intertwines quite a bit with permissions and automations, and maybe most of this is already possible, but I felt it deserved it’s own thing.
I also would like to see the integration of Conditions. I don’t know if adding that at a Field level is the best solution but at least if it can be added in Automation, this will already be a good step forward in my opinion.
So far I’ve seen alot of great things in Fibery, but a big blocker for me actual moving company data inside is the lack of field validation and unique fields.
I need the ability to make any field I create unique, so that an error pops up or I’m simply unable to input a new row if that field is a duplicate.
I also need the ability to do more complex field validation, such as field A can’t be x when field B is y.
Without these things there’s a very big risk of data duplication and errors.
If you search this forum for “unique” you will find that there has been some discussion on this topic, including some ways to enforce/warn about uniqueness violations.
Hello. I can’t find this in examples and settings - please help.
I want to implement validation when entering new row into a table: e.g. IF field A is OPTION1 then field B and C should be not empty, IF field A is OPTION2 then field D and F should be not empty, and so on.
Is it somehow possible?
If not - can I at least have formula that will do the same and if it is FALSE displays ERROR label/text?
Hi, Konstantin
We would suggest boolean formula (checkbox) and color-coding on top
There is no need in the If formula - just a combination of and/or showing boolean
Btw, if you could share with us your case with details, there is a chance, that we can find a better solution
