The URL column type should let me construct a string that includes a URL that is a combination the prefix, the field value, and the suffix as a single html link. Currently, it looks like I would need to do that concatination in mysql, which is doable, but much less than ideal. Since the field already lets a user display three values in a sort of concatenation, why don’t you just make your formatting optional. Better still, create a new column type that enables string concatenations of column values and text.

If I understood the request correctly, I believe nowadays the Transform value feature can do exactly this.
