Introduction
Q can automatically export charts, tables, and text to PowerPoint and update the PowerPoint presentation to reflect updates of data in Q. Every object that can be updated from Q has a GUID (Globally Unique Identifier code) assigned to it.
When linking outputs to PowerPoint, you need to copy the GUID from Q to PPT for each object. If you have multiple GUIDs, this can be time-consuming. It's possible to export multiple GUIDs all at once with a script.
Requirements
Charts, tables, and images that you want to export from Q to a PowerPoint document.
Method
You can use a script to export multiple GUIDs all at once with the following script. This script may be useful for anyone who needs an output of the table name and GUID.
Automate > Open QScript (Macro) Editor and enter the following code:
// Returns selected table names and guids with quotation marks and a comma appended.
//Select the root of the report tree to return all tables in the tree.
project.report.selectedItems().forEach(function (item) {
if(item.hiddenFromExportedViews == false) log('"' + item.name + '"');
});
log("");
project.report.selectedItems().forEach(function (item) {
if(item.hiddenFromExportedViews == false) log('"' + item.guid + '"');
});
Press the blue play button and a new window will pop up with the GUIDs.
Next
How to Create a Custom QScript