Help with getting the range values of the Input boxes

[#1]

Hi All,

I need some help with the solution for following Scenario.

I have a huge list of account numbers.

I want the users the flexibility of entering the beginning range and ending range in the input boxes and when they click on 'GetAccounts' button they should be able to see all the account numbers within the range.

Here is the visual explanation of what i am trying to achieve..

Beginning Range
1001

Ending Range
1050

Get Accounts
Get Accounts ----> BUTTON

when the user clicks on 'Get Accounts' button we should display values from 1001-1050 only...

Please  give your suggestion and process as to how to achieve this step by step.

Thanks for looking into this.

[Anonymous]

Well, no matter how you do it, with input boxes or without, using my suggestion or the one from maxgro‌ (more or less the same) - export to excel will be working the same way.  As for the "more than one filed in layout" - it can be used in a table box and in a table if option "Drop-down select" is allowed.  Of course you cannot use the above method if you don't show this field on the front end, which is often the case, typically with dates.

So, if possible - keep it simple.  Complications will find their way to you when you don't look for them

[maxgro]

yes, the same and it works

[#4]

Hi Massimo,

Here is the snip what i get when i cclick on the button'Geta/c'.

I don't see the list of correct values, instead it displays everything in 'Green'.

I must be doing something wrong.

Please let me know your inputs.

Thanks

[maxgro]

button

variable

script

a:

load rowno() + 1000 as account

autogenerate 100;

[#6]

Hi Massimo,

Here is the snap i forgot to attach en the earlier post..

Sorry for that..

Appreciate all the help..

Thanks

[maxgro]

what's your VarSearch?

it should be

='>=$(VarStartAccount....)<=$(VarEndingAccont....)'

[#8]

Hi Massimo,

Here is the varible as per variable overview..

='>=$(varStartAccountNumberRange)<=$(varEndingAccountNumber)' .

I am Aattaching the snip here for the clarity.

Thanks

[maxgro]

your vars are in different case,

sometimes

varP

sometimes

VarP