topic Re: Input Box variable extension-how to display default data without entering min and max in input b in App Development

Input Box variable extension-how to display default data without entering min and max in input box.

LP27 — Sat, 16 Nov 2024 01:14:09 GMT

Hi Everyone,

Could someone guide me how to use input box Variable Extension for the below scenario-

Firstly I have created 2 variables

vMin_Invoice_Amt= Min(Invoice Amount)
vMax_Invoice_Amt=Max(Invoice Amount)

I am using two Input Box -

Input Box 1 to enter starting value = Min(Invoice Amount)
Input Box 1 to enter Ending value =Max(invoice Amount)

Now I have written If condition for Invoice Amount column -

if(Sum([Invoice Amount])>= $(vMin_Invoice_Amt) and sum([Invoice Amount]) <= $(vMax_Invoice_Amt),sum([Invoice Amount]))

This filters accordingly the value entered in Input Boxs, But I want to display everything if there are no values entered in Input Box. Like show everything initially when users enters there input in the boxes it should filter accordingly.

Let me know if the is clear!

Thanks in advance

Re: Input Box variable extension-how to display default data without entering min and max in input b

dplr-rn — Tue, 27 Oct 2020 19:38:49 GMT

Not completely clear.. wont you have a default value for the input boxes. vMin_Invoice_Amt?

i am assuming you are asking about scenarios where one or both of the values are empty.

if so just add an empty condition to your if statement e.g. if(len(variable)=0....

let me know if i am missing something

Re: Input Box variable extension-how to display default data without entering min and max in input b

LP27 — Tue, 27 Oct 2020 19:46:40 GMT

Yes your right!

I wanted a logic where one or two values are empty.

Do i use it like this-

if(len(vMin_Invoice_Amt)=0 or Sum([Invoice Amount])>= $(vMin_Invoice_Amt) and sum([Invoice Amount]) <= $(vMax_Invoice_Amt),sum([Invoice Amount]))

Correct me if i am wrong!

Re: Input Box variable extension-how to display default data without entering min and max in input b

dplr-rn — Tue, 27 Oct 2020 19:56:34 GMT

you will need nested if loops

roughly

if (len($(vMin_Invoice_Amt))>0 and len($(vMax_Invoice_Amt))>0
, if(Sum([Invoice Amount])>= $(vMin_Invoice_Amt) and sum([Invoice Amount]) <= $(vMax_Invoice_Amt),sum([Invoice Amount]))
, if (len($(vMin_Invoice_Amt))=0 and len($(vMax_Invoice_Amt))>0,if(sum([Invoice Amount]) <= $(vMax_Invoice_Amt),sum([Invoice Amount]))
,....
)
)
)