You are better served with using a composite columns to store you template, which should be updated automatically anytime any other member column is changed.
Composite columns use calibre's
Template Language, so for example if you have a template like this:
Code:
{authors} - {series} - {title}
Anytime any of the above column changes, it will be reflected automatically in your composite column. To learn more about this, consult the
calibre documentation.