Right now, the default setting for transformations is "Custom." The overhwelming majority of transforamations we do are "Fixed," and it would be nice to be able to set this as the default type when adding a transformation.
In addition, when you add transformations to one field and select another, the transformation type snaps back to Custom no matter what. This adds several additional clicks if you are adding many transformations that aren't custom.
If the option for a default transformation type can't be added, then at least maintaining the current transformation type when changing fields would be really useful.
The use case here is that we are adding fixed values to handle cases when DSK or lookup surrogate foreign keys are empty. When repeating this process for dozens of fields across multiple tables, selecting and re-selecting the transformation type begins to feel very laborious.
