Kirstin Lyon wrote:
I can include an action in a calculated field - but not really sure how to test if anything has been selected.
We can? I am not aware of any way to include an Action in a calculation.
You could create a separate worksheet to display when actions are selected. I setup a quick dashboard with 4 actions. Three filter normally on select. The 4th action only displays the notification when selected and excludes when cleared.
The trick is create a fake field that will be the same across every record.
Actions are Selected
"Actions are Selected"
Put this field on all the sheets. And setup the exclude action like this:
When Nothing is selected:
When Chairs is selected:
9.2 workbook attached.
ActionsNotification.twbx 605.2 KB
I was in "I'll try anything mode".. I set the worksheet as "use as filter", then when I went to worksheet 2, there was an action in the filter (this is auto-generated when you select anything in the worksheet that has been marked as use filter, as long as it's set to filter everything (or at least worksheet 2)). For fun I tried dragging the action in to a calculated field, and it worked! But so far I'm not able to do anything useful with it.