Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
HilitDrori
Contributor II
Contributor II

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

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:

HilitDrori_1-1641383463448.png

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

HilitDrori_0-1641383449704.png

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

 

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

HilitDrori
Contributor II
Contributor II
Author

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