I would like to populate a personalisation field (say account balance) into my email template. Unfortunately this account balance field is not available yet in the database (Recipients). Just checking is there a way to populate this account balance into the email template via the list instead of adding a new account balance field into database ?
It is a known issue with the DCE. You will not be able to see the targetData section in the personalization helper menu.
Workaround is to open the source tab of the editor, locate the point in HTML where you wish to add the targetData personalization and then use the same menu at top to now reach targetData personalization.
Is it possible to compute it using other fields already present in the database?
Is it available in an external file?
Using workflows, you should be able to compute it and enrich the recipients data (without having the filed existing in the database). This field would then be available in the personalization fields of the delivery as a "target data". Here is an example: Synchronizing audiences