i need to trigger a macro when i clear all selections. in document properties -> triggers - > document event triggers , there is no onClear trigger defined.
i know there is an option that i can create a button that function both for clearing the fields and running my macro respectively. but i do not want to use it this way. i have specifically a need for onclear event?
It is possible by using a separate field (logical island) which is always selected except when you use Clear. The change in this field will be your "onclear event".
I tried that and here is what i found, There are issues using a % or "user defined system field" and there are issues using fields that have spaces. I renamed the field to daterangefix from %Date Range and I created an onchange trigger on a key that noone will select.
