Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table box with an input field.
How to capture the value of the latest change in any cell of the inputfield?
How to trigger a macro when a value in a row of the input field is modified. I do not want to use a button. The macro will use dynamic update to set a corresponding value in a resident table.
Appreciate if anyone can help me with an example? I am using QV9.0.
Thanks.
Hi,
there is no explicit trigger (action) for the event "Change of an inputfield" (not that the "OnChange" - event on field level is another thing!!). You could possibly achieve this only via OnChange of a variable, but you'd have to associate the variable to the changed inputfield; I've not yet thought about it more deeply (besides, I've already experienced a lot of troubles with inputfields as well as macros generally and dynamic data update with QV 9 - that thing seems to be VERY buggy still!! - I have open support cases on all three matters), but I'd really recommend you think of an alternative - at least for the time being until QV9 is less buggy. But perhaps others here do have different experiences. This is only my personal view.
Rgds,
Joachim
You can detect whether an input field has changed and trigger a macro by defining a variable containing an expression. For example, if you define a variable named Check_Forecast containing this expression:
=Sum(Market_Forecast)
Then, you can set up a trigger that will execute a macro whenever the value of variable Check_Forecast changes.