How To Export Multiple GUIDs to PowerPoint Using a QScript

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 Use QScripts in Q

How to Create a Custom QScript