all my apps have a number of sheets with one KPI each.
They are m.o.l. equivalent to a process in the company - receiving, operations, shipping etc.
Some of them are now further split into 3 or 4 subprocesses, the KPIs in the app can be associated with those.
=> I have 3 or 4 "overview_sheets" which are like the thumbnail_slides you get when developing fotos in a store - they
have (a varying number of) smaller versions of the diagrams one can view on other sheets of the app.
=> Overlaying these "thumbnail_charts" (overlapping 80% or so) are transparent buttons that simply activate the "detail_sheet" where one can see a bigger version of that specific KPI.
=> My question is: On every sheet - also on those "thumbnail_sheets" there is a multi_selection_box for the year and week. Sometimes one is interested not in the current week, but a period in the past.
=> Can I set those transparent buttons to transfer those selections to the "detail_sheet" that is activated by the button?
(that would save one the trouble to repeat those selections)
If I understood your question correctly, the current selections are being cleared when you switch sheets? The selections should transfer over to the other sheets and its possible that you have an Action to clear the selection on the button or possibly a trigger on the sheet’s OnActivateSheet or OnLeaveSheet.
no - that is the strange thing - actually I don't.
I do have a trigger to clear all selections - but that is on the normal navigation_buttons, not on sheet_level - we made the experience early on that the sheet_level_triggers are somewhat buggy, so we decided to put all necessary selections on the buttons instead - that works fine.
That particular button, though, does not have that trigger - it only activates the specific sheet, so selections should actually not be cleared.
That is strange.
Oops - that trigger was there all right. Didn't remember. Obviously I had just copied the normal buttons with all selections - so there was a trigger to clear all selections beforehand.
I remóved that now. I will only keep any specific selections which might be needed - with several charts on one sheet, not all might work with the same set of selections ...
