topic Re: Filter doesn't change immediately after changing value in input box in App Development

Filter doesn't change immediately after changing value in input box

HilitDrori — Wed, 05 Jan 2022 13:24:32 GMT

Hello,

I'll be happy to find a solution to my problem.

On the screen:

Two variable input type "Input box" for the variable vMinBatchProd and variable vMaxBatchProd

and an action button "V" with the action "select values matching search criteria"

that updates the field to be filtered with:

='>=$(vMinBatchProd)<=$(vMaxBatchProd)'

When I change manually the value in the input box and press the button "V", the focus stays on the input box

and nothing happens:

After I press the button "V" again, the focus is no longer on the input box and the filter changes accordingly:

It doesn't matter what actions I define in the button, nothing happens at the first push.

Re: Filter doesn't change immediately after changing value in input box

rwunderlich — Thu, 06 Jan 2022 04:37:28 GMT

Does it work if you do it in this sequence.

1. Change the value in input box.

2. Click somewhere else on the sheet.

3. Click the button.

If that works, then it appears to be a problem of the input value not being changed until it loses focus. So at the time you click the button the change has not been registered?

-Rob

Re: Filter doesn't change immediately after changing value in input box

HilitDrori — Thu, 06 Jan 2022 07:46:18 GMT

Yes, when I click somewhere else, it loses focus and then clicking on the button changes the filter