Monday, 10 January 2005

Splitting a RestrictToCategory view into Columns

While answering queries on the Notes forum, i came across this tricky requirement (still haven't managed to crack it). Check this view. The arrangement of data is Top - Bottom then a split and again Top - Bottom which is totally amazing. However, i got close to it and here is what i did :

1) Create a VIEW with the following attributes :
----- Treat View Contents as HTML
----- Appropriate VIEW Selection Formula
----- First Column
Hidden Column
Show twisties when row is expandable
Sort should be 'Ascending'
Type should be 'Categorized'
Formula should be CATEGORYFIELDNAME
----- Second Column
Formula should be ""
----- Third Column
Formula should be :
root:=@ReplaceSubstring(@ReplaceSubstring(@Subset(@DbName; -1);" ";"+");"";"/");
url:=root+"/0/"+@Text(@DocumentUniqueID)+"?OpenDocument";
""+NOTESFIELDNAME+""
----- Fourth Column
Forumla should be ""
2) Create a $$ViewTemplate form for the View you just created in step 1
This form should have a $$ViewBody field within a table i.e.
'' Make it PASS Thru HTML
******* Place your $$ViewBody field here, it should be of TEXT and EDITABLE ***************
'' Make it PASS Thru HTML
Put the following 2 functions in the JS Header :
function StartRow(DocNumber) {
if (DocNumber==1) {
document.write('')
}
}
function EndRow(DocNumber) {
if (DocNumber % 2==0) {
document.write ('');
}
}


01:55 Posted in Blog, Tips | Permalink | Comments (4) | Tags: Just talk Lotus

Comments

kkd

Posted by: cabdifitaax | Monday, 21 November 2005

Good post, very useful i like it very much

Posted by: tamiflu | Wednesday, 19 April 2006

url=http://portable-washer-and-dryers.beeplog.com]portable washer and dryers[/url] portable washer and dryers wet saw blades [url=http://wet-saw-blades.beeplog.com]wet saw blades[/url] steam shower [url=http://steam-shower.beeplog.com/]steam shower[/url] portable-washer-and-dryers.beeplog.com steam-shower.beeplog.com wet-saw-blades.beeplog.com

Posted by: Magdu | Saturday, 08 July 2006

crohns
hooka
greenies
[url=http://crohns.coz.in/]crohns[/url]
[url=http://hooka.coz.in/]hooka[/url]
[url=http://greenies.coz.in/]greenies[/url]

Posted by: Tim | Sunday, 09 July 2006

Post a comment