Idea Summary
We can edit data sets in IG. We can copy rows etc…. all good.
But very often we enter values that are breaking unique constraints. So we have to do manual validations to check for these things which has been a topic of many forums chats around. Data in IG lives in a browser meaning only way to do this is using JavaScript or even worse using APEX collections where there should be the easier way for such a common thing.
It would be great to have an on/off option or a way to say this column needs to contain only unique values. Extension on this would be to do the same on multiple columns but lets start small.
Use Case
Very often data in IG needs to be unique on a column level. Simple validation to validate this would go a long mile. Problem is that IG has client and db site where these checks need to be performed which is currently not available out of the box.
Preferred Solution (Optional)
Idea would be to have a column level setting On/Off prevent duplicates or validate duplicates so we do not have to do this using JS.