Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Yes, when I click somewhere else, it loses focus and then clicking on the button changes the filter