General Caster is here. Get rid of formula columns!

Hey @Jof
General Caster doesn’t retrieve the email address at the moment, because it has no permissions to read the Users table.
Next major version will be able.

In the meantime, the SWITCH() function is a possible workaround, but, as you said, it works with one element only.
By the way we have now added the user’s name to what is returned by General Caster.
You can read about this and all other improvements in the Release Notes section on our website.