I have a situation that shouldn’t be too uncommon.
User A links entities X and Y. Entity Y’s fields are effectively an extension of X and wholly reliant on X for formulas. Once Y has been assigned to X, it should never be removed unless either entity is deleted.
User B comes along and links Y to Z. This not only removes Y from X in this many-to-one relationship, but it breaks the data in a way that’s hard to catch.
I need a way of locking down this field so that users can only create and link, not link existing entities or reassign.
Hey! I feel you. I wish you could specify the behaviour per relation view (compact view as well as the larger relation views)
For the time being, I’m assuming this is a to-many relation, this behavior (in the larger relation views) is only for the list view. So what i find myself doing a lot in these scenarios is to make a board view and set the size to “line” this basically makes it a list view, without the ablility to link, or even unlink! only create and delete.
While annoying you can’t set this per view, you are given the ability to choose this behaviour based on which view you choose.
More about linking and unlinking? Choose list, more about creating or deleting? Choose any of the others.
Not a real solution, but you could create a Rule that triggers on the unlink, and generates some sort of warning/notification (though not as a toast/pop-up when the change actually is made).
A workaround: I sometimes use (and should use more often) a formula column. Say I’m linking something to a project. In the create Form, I’ll use the relation field, Project Link to choose the project. Then, in views, etc. I’ll use the formula field Project (formula being [Project Link]) which shows the project relation as a read-only field.
Obviously, this means doubling up on fields, which isn’t ideal, but works. It does assume that team members aren’t going to make their own views and add Project Link instead of Project though.
I do the same for State fields if they’re updating based on other things, or only via button, etc.