Well, I used to be able to write @formula functions like this in my sleep.
But once Lotusscript came out I stopped writing "complex" @formulas like this so forgot how to do it. Then one day when I needed a list like this it took me over an hour searching the old Notes 4/5 forums to find it. So I thought I'd put it here in case I ever need it again.
To create a long list of numbers (say sequential from 0-99) use this formula:
digitList := 0 : 1 : 2 : 3 : 4 : 5 : 6 : 7 : 8 : 9;
LongList := @TextToNumber(@Text(digitList) *+ @Text(digitList));
If you only need say from 0-48 then do:
@Subset(LongList; 48)
If you want 48 but starting at 1 rather than 0 then:
@Subset(@Subset(LongList; 49); -48);
Recent Posts
Categories
Popular Posts
-
Well, I used to be able to write @formula functions like this in my sleep. But once Lotusscript came out I stopped writing "complex...
-
My thoughts on using TABS for indentation: This was taken directly from StackExchange and written by @ FishToaster . Now I make no claim...
-
Well, my friend Erik and I (along w/ about 10,000 other of our closest TAOSRI friends) have survived yet another Lotusphere. Our presentati...
-
By csoto on Jul 19, 2011 A couple of weeks ago I saw a forum thread which I found very interesting. A guy was asking if it's possib...
-
I have had the honour of speaking at TCF for over 20 years now. To be quite honest, I'm not sure just WHEN I started speaking here, but ...
-
Let's say you have a view you need to create for a Backbone project. For that view you need a collection of data to display. BUT, let...