i am trying to create new invoice print format, in our item there is is field called City, it should be part of items discretion, but it should be in 2 language English & Arabic.
i called this filed in English successfully like this : {{ frappe.db.get_value("Item", {"item_code": row.item_code}, "City") }}
and called translation manually {{frappe.db.get_value('Translation',{'language':'ar','source_name': 'Riyadh'},"target_name")}}
need to change the source name to be Variable?
try with many ways but without success, any Idea?