Solved

Views Seen via the Web (Notes 4.6)

Posted on 2000-02-29
14
196 Views
Last Modified: 2013-12-18
We have a database view which comprises of a number of columns.  The second column displays the entries from a Country field which can contain multiple country names.  For example, BOSNIA HERZOGOVINA, FORMER YUGOSLAVIA REPUBLIC, UNITED STATES OF AMERICA.  If the country field contained all the previously mentioned names, when viewed thru Lotus Notes the column width is seen as it is in the template (ie only showing BOSNIA HERZ, the rest being hidden).  The 3rd column is a Subject column.

However, when viewed thru a browser, all the countries are displayed thereby hogging all the screen. and making it only possible to view the Subject field by scrolling across.

My question is: How does one control the width of the columns when viewed thru a browser so that they are the same as when viewed thru Notes.
0
Comment
Question by:Chris_m
  • 8
  • 6
14 Comments
 
LVL 6

Accepted Solution

by:
ghassan99 earned 50 total points
Comment Utility
Try one of those, whichever suits your data, in the column formula:
"[<TD COLSPAN=n>" + field_name + "</TD>]"
"[<TD ROWSPAN=n>" + field_name + "</TD>]"
"[<TD WIDTH=n>" + field_name + "</TD>]"

If you check the source of any rendered view on the web, you will see that the contents of the data is surrounded with a <TD></TD> tag.  Which is logical for the contents of the cell.

-Gus
0
 
LVL 6

Expert Comment

by:ghassan99
Comment Utility
Also you might try a combination like this:

"[<TD COLSPAN=n ROWSPAN=n>" + field_name + "</TD>]"

-Gus
0
 

Author Comment

by:Chris_m
Comment Utility
Thanks for your help, when you mention the column formula, do you mean the box in the designer pane or the formula window in the properties dialog box.  We have formulae in that window already, are we allowed to put the HTML in the designer pane as well?
0
 
LVL 6

Expert Comment

by:ghassan99
Comment Utility
Yes in the designer pane, in the column formula.  There is no place to add code in the column properties dialog box.  Just make sure that the final output will be the field name surrounded with those HTML tags.

-Gus
0
 

Author Comment

by:Chris_m
Comment Utility
One last thing, is it not possible to restrict/size the width of the column thru the view?
0
 

Author Comment

by:Chris_m
Comment Utility
Disregard my last comment, we are working in the view -- sometimes, I can be dumb!  However, when I try your suggestion of
"[<TD WIDTH=n>" + Country + "</TD>]" it does not modify the <TD> </TD> created by Notes; it creates a new data cell -- and not just one, but one for each country listed in the country field.  
0
 
LVL 6

Expert Comment

by:ghassan99
Comment Utility
You mean some setting in the properties dialog...no its not possible.  But if you want you can just truncate the value, say '@left(field_name,10)' will restrict the value to the first 10 chars.

-Gus
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:Chris_m
Comment Utility
Did you see my comment about the "[<TD WIDTH=n>" + Country + "</TD>]"?  This seems to be an excelent approach to the problem if I could only modify the existing <TD> tag.
0
 
LVL 6

Expert Comment

by:ghassan99
Comment Utility
Country field has multiple values to show?
I have seen another approach...I cant recall, but it involves putting half of the tags in the column name and the rest in the column formula.  Also this way it should work, its working for me.  I think the field you have is multi value, I didnt try that.  I will look it up.

-Gus
0
 

Author Comment

by:Chris_m
Comment Utility
Yes, sorry, the field accepts multi values.  But as I said, If I put it in in this way, it is almost as if I am creating another column for each country name in the field (even if only 1 name is there). The original column called Country is empty.
Regards
0
 
LVL 6

Expert Comment

by:ghassan99
Comment Utility
But if its a normal column its working fine, is it not?  Try and play around with the 'Multi value seperator', choose space or comma.
0
 

Author Comment

by:Chris_m
Comment Utility
Sorry for the delay; I was out of the office since thursday pm.
When it is left to Notes to convert the view to HTML, we get the following:
<TD NOWRAP> Country1, country2, etc </TD>
when I put "[<TD WIDTH=20]" + country + "[</TD>]" as the column formula, Notes converts as follows:
<TD NOWRAP>
<TD WIDTH=20>Country1</TD>,
<TD WIDTH=20>Country2</TD>
,<TD WIDTH=20>Country3</TD>
</TD>

Notes is now surrounding each country with an opening <TD WIDTH=20> and a closing </TD>and seperating it from the next country with a comma.
This is all put inside the original
 <TD NOWRAP>...</TD>  tags.  This instead of adding the "WIDITH = 20" to the  <TD NOWRAP> tag.  When viewed thru Notes, the HTML code is seen on each side of each country.
0
 
LVL 6

Expert Comment

by:ghassan99
Comment Utility
Yes I noticed your point...I'm sorry, as I can see this, its the way Notes is handling the multi value field.  I think a workaround would be to try and create a hidden field on the document, that takes the value of the country field (which is a list of values) and implodes them (with @implode probably in the field translation formula) to make a text string then display this field on the web view in place of the multi value original country field.

-Gus
0
 
LVL 6

Expert Comment

by:ghassan99
Comment Utility
Did u try it?
My last comment will work a treat by the way.

-Gus
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now