My variable: $(FirmaAnzahl) = getselectedcount(Firma_FIBU_NrBez)+1
If user changes his selection on Firma_FIBU_NrBez from lets say 3 to 4 it should fire based on "trigger on variable". From 4 to 0, from 0 to2 it always should fire. BUT it don't. I knew somewhere in past it did fire.For now the trigger on variable thing only works, if user is realy changeing something on that variable manualy (e.g. Inputbox). Changes on variable made through a formula - like mine - do not trigger anything. [:S]
To workaround I set trigger on select my field "Firma_FIBU_NrBez". But problem is, that this do not work all the time. If user selects something in other field which deselects "Firma_FIBU_NrBez" trigger wont fire. If the user uses a bookmark, trigger wont fire. It just fires on really selecting the triggered field.
The solution on variable-change always fired - the time it worked 😞 ! Now it do not work any longer. I think the manual and the help give examples on that this a formula for variable. So I think, that this is a bug for sure.
Anyone have a similar Problem and another solution?
The trigger what you are expecting never will be fired, if you see, the literal variable value never changes, I mean, always is gonna be =getselectedcount(F1), so, the change really doesn't happen.
What are you trying really? would always it depends of a selection?
you are absolutly right in idea but I have to tell you, that thisone worked previous version 9.0 SR3. I used it some day before update. Trigger on Variable with formula (first literal = "=") should not fire on literal change but on formula result. It's how I said - this worked some day in past.
QV-Help also tells you it should work the way I want it workin. I'm just waiting for fix.
Jonas Gros wrote:To workaround I set trigger on select my field "Firma_FIBU_NrBez". But problem is, that this do not work all the time. If user selects something in other field which deselects "Firma_FIBU_NrBez" trigger wont fire. If the user uses a bookmark, trigger wont fire. It just fires on really selecting the triggered field.
You also need to trigger the macro OnChange. The OnSelect trigger only works for direct selections, as you've noticed. The OnChange trigger works for indirect selections like you are describing. See attached. F2 = F1. If you modify F1 directly, it triggers the macro with the OnSelect trigger. If you modify F1 indirectly by changing F2, it triggers the macro via the OnChange trigger. I have not verified that it works with bookmarks, but I would guess so.
