Sticky:
Plugboard, template, and custom composite column recipes
Has a lot of custom templates designed for specific needs, and the first post collects a bunch of generic ones.
UDFs are not quite as common, mostly because the template language is mostly all that people need.
But you can do literally anything you want so long as it can be programmed in python based on the input of a metadata column.