Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Does anyone know a way to toggle actions by MultiBox selection changes, in the same way you can toggle actions by switching tabs (in the "sheet properties")?
Thanks!
The event is the change of the selection - so its based on the field and not on the object. Maybe think about duplicating your field to specify a certain action on Field2 (which has in fact the same data filter effect like Field1 - but could be handled separately).
You could use the triggers in Document properties (Field event triggers).
Or use variables for more possibilities like e.g. SET vTestSelect = 'if(GetFieldSelections(Test1)='test value', 1, 0)'; then use this flag for further actions.
Thanks! However, I'd like an event to be triggered every time a box's selection is changed. Is there a way to refer to changes caused by a specific sheet object?
The event is the change of the selection - so its based on the field and not on the object. Maybe think about duplicating your field to specify a certain action on Field2 (which has in fact the same data filter effect like Field1 - but could be handled separately).
Thanks! I wish there were a more straightforward solution, but adding a duplicate column and attaching a document trigger to it seems to work!