How do I create number range based on start & end number?

HCL Domino Domino Forum
1

I have a beginning number and an end number, using @Formula how do I write out the in-between numbers in a string so that I can use @subset with them?

For example: I have a “2” returned from one field and a “9” from another. I have a third hidden field that I need to programatically write out “2”:“3”:“4”:“5”:“6”:“7”:“8”:“9”

The beginning and end number will change thats whay I need to programatically fill it in. THANKS!!!

2

Subject: How do I create number range based on start & end number?

For R6 and later use this as the value of your computed field. You may want to add logic to catch exceptions (null values, etc)

start := @TextToNumber(i);

end := @TextToNumber(j);

@For(n:=start;n<=end;n:=n+1;res := res : @Text(n));

@Trim(res);

3

Subject: RE: How do I create number range based on start & end number?

Man I was so close, many many thanks!!!