Table A has value form Table B (tableB.id) and I need value from Table B( tableB.code).
I want to use custom function with ew_ExecuteScalar (Select TableB.code FROM TableB WHERE ??) in global code and then call this function from custom attributes field.
Please for some good example, because I’m starting to learn.
thx :)
You can put JavaScript function in Custom Attribute only. But your code is server side. Elaborate in detail what you try to do.
I have Table Customer with fields (name, surname, address, post, state, etc). Fields post, state are FK from table sif_post and sif_state.
I would like to have link on field address (for googl emaps).
I manage Prefix (url for googl emaps), HREF value is address, I need post_code from sif_post and state_code from sif_state
You can create Custom Field to get the value (test your SQL expression first) and use these fields to create full address. Read Custom Fields in help file for more details.
thx