I have the following code, which basically goes through rows in a view, 20 at a time, until there are no more rows, then it starts at the beginning. What this does is go through items being fixed, and their status.
Well now they want to expand it. And start going through other items. With different column headers. So I have to launch a different view at the end. I am comfortable with lotusscript, but not very comfortable with @functions. And some of you helped me write this first one. I was wondering if anyone could verify or help me change this, that instead of reopening the same view, that it opens up the new view. At the end of that view, it will reload this first one.
start:=@If(@IsError(@TextToNumber(@UrlQueryString(“Start”))) ; -19 ; @TextToNumber(@UrlQueryString(“Start”)));
count:=@If(@IsError(@TextToNumber(@UrlQueryString(“Count”))) ; 20 ; @TextToNumber(@UrlQueryString(“Count”)));
rowcount:=@Elements(@DbColumn( “”:“ReCache” ; “” ; “Ticker” ; 8 ));
@Set(“start”;@If(start >(rowcount - 19) ; -19;start));
“"
There at the end, if it is @isError(@Text(start+count));“1”. I am assuming that is where it is changing the start row. It seems to be building the URL as it goes along. How and where would I move this code, to know if I am at the end or not, and change the url to www.abc.com/ticker.nsf/newview instead of starting at the beginning?
Thanks for your help in advance.