As we have seen in Chapter 6, recipe Creating a slide show we can show
.swf
files inside a dashboard. If you load a Dashboard Design .swf
file into another Dashboard Design dashboard, a big drawback is that it seems impossible to let them have some kind of interaction. Both dashboards of course have their own separated spreadsheet logic.
In this recipe, we will show you how to workaround this problem and pass values from one dashboard to another using Flash Variables.
Drag an Input Text component and a SWF Loader component to the canvas.
Go to the spreadsheet and enter in cell A1: Company A. This is the default value that will be passed to the second dashboard.
Type the following in cell A2: child.swf?Variable1=.
Type the following in cell A3: =CONCATENATE(A2,A1).
Link the Input Text component to cell A1. Also, make sure you select the Insert Data On Load option...