Restrict the data of a column in a datagrid. So that the data is not repeated.
The situation is as follows: I have a form that has a dropdown, there I select an option with some additional data and save them in mendix DB that are reflected in a datagrid. What I want is that it does not let me add a new data with the same option of the dropdown. For example: in the dropdown I have four options (Apples, bananas, oranges), I select apples and save, this is reflected in the datagrid column. Now I want that in a next filling I can't save more apples in the column. Something like this. Thanks.
Add a validation microflow behind the safe button that checks if the value already exists in the DB