2. PHPRunner General questions
  3. 4.1 View As Different in List and View
This topic is locked

4.1 View As Different in List and View

 		10/6/2007 8:07:55 PM
PHPRunner General questions
M
 MikeB941 author

Hello:
Just starting to use version 4.1.
Question - I have a field that's an email address that I wish to display (View As) a link with the work "Link" on the List Page (to save space) but I want it to appear as a link with the FULL email address displayed on the View Page.
In 4.1 it appears the "View As" attribute is linked to the field and if you change it in the Visual Editor on the List Page it's also changed for the View Page (and I'd like to have the "View As" set differently for the field on the List Page versus the View Page.
Thanks for any help.
Take Care... Mike.
J
 		Jane 10/8/2007

Mike,
I recommend you to do the following:

  • edit SQL query on the Edit SQL query tab.

    Here is a sample:
    select FieldName1,

    FieldName2,

    FieldName3,

    FieldName3 as FieldName3View

    from TableName


  • check FieldName3View on the view page only on the Choose fields tab
  • and set up different "view as" formats for FieldName3 and FieldName3View fields on the Visual Editor tab.