2. PHPRunner General questions
  3. Custom Expression in Edit as Lookup table
This topic is locked

Custom Expression in Edit as Lookup table

 		4/15/2008 14:26:00
PHPRunner General questions
M
 mmponline author

I use this custom expression to display info on a table:

concat(AgentName,'Tel. ',AgentPhone,' ',AgentFax,' ',Email)
It works fine.
I would like to add enters (breaks ) between the fields. Tried
but obviously it's not html coding.
What would be the way to go?
Lastly: Is it possible to make the e-mail address hyperlinked.

Thanks for your help.
A
 		alang 4/15/2008

The concat function is SQL. Not sure what database you are using but you could try the '\n' sequence (Google: "mysql string newline").
I haven't used it myself but imagine you could use "Email Hyperlink" on the View As tab in visual editor.
M
 		mmponline author 4/26/2008

Sorry for the late reply. BUSY!!!
Your solution works perfectly. Thanks!
What code can be used for Bold and Italic, etc.