Fabrik Virtuemart List Elements - ID #'s into Labels

[Metabern]

Greetings,

I want to be able to add some php to Fabrik list elements that are returned from a virtuemart table.

I am assuming that is a pretty generic php to be added to the elements in question

Here is what I am looking for:
Currency - Fabrik returns a numerical currency ID of 38, I would like it to go to jos_virtuemart_countries___country_3_code and match the country id with a name (In this case Canada $CAD)

Country ID -> Country Name
State/Province ID -> State/Province Name

Can you help?
Thanks

 

[troester]

Go to your Fabrik list, in "Advanced" set" Alter field types" =no.

Edit your Fabrik currency element,
change to type=databasejoin
select jos_virtuemart_countries___country_3_code as table,
set Value and Label as you need.

 

[Metabern]

Success! Thanks!