Is there any formula to convert a number range into a list of numbers? For eg: the range is from 20 to 25 so the result should be 20,21,22,23,24,25.
Thanks in advance.
Subject: Number Range
Start := 20;End := 25
List := Start;
@For(Range := Start + 1; Range <= End; Range := Range + 1; List := List : Range);
Subject: Number Range
I am not sure if there is a inbuilt function to do this. try this
create a mulivalue field (seperate values with ,)
t:=“”;
n1:=11;
n2:=23;
@For(i:=n1;
i <= n2;
i:= i+1;
t:=t+@Text(i)+“~”
);
@Explode(t;“~”)
Subject: RE: Number Range
Thank you for the code. Pertaining to this, how to perform search from a range of number by keying a search number. For eg, user enter 22 as the search key, the search result will show the record which track the start number from 20 to the end number 25. Your assistance is very much appreciated.
Subject: RE: Number Range
well if you want to go to the exact number u’ll have to save the list as separate documents i.e. every number is saved in a separate doc.
there’s one thing… if u’ve a view with show multiple values as separate entries selected, and you’re doing a simple text search on the view (not using the search bar) you’ll get to the desired number.
hope i’m not confusing u
Sharjeel.
Subject: RE: Number Range
Hi Sharjeel,My user want to get the search result with minimal effort thus we agreed not to create separate documents as this will cause performance issue in the long run. I tried the view to show multiple values but would prefer if there is other alternatives.
The requirement is like user will receive materials in bulk and input in the system the start material number and end material number. From there, user will assign some amount of material to another user and multiple assignment is allow to users with the material number in a range of 1 to 500. When user prompt the system on the material number, system will be able to find out who is the last person the material assign to.
Thanks.