# Delete Tables and Plots - Delete If Broken

Deletes any tables that are broken.

This QScript deletes any tables in your Report that are broken. Broken tables include:

• Tables with a hidden question in the blue or brown drop-down menus.
• Tables with no data.

## How to apply this QScript

• Start typing the name of the QScript into the Search features and data box in the top right of the Q window.
• Click on the QScript when it appears in the QScripts and Rules section of the search results.

OR

• Select Automate > Browse Online Library.
• Select this QScript from the list.

## Customizing the QScript

This QScript is written in JavaScript and can be customized by copying and modifying the JavaScript.

• Start typing the name of the QScript into the Search features and data box in the top right of the Q window.
• Hover your mouse over the QScript when it appears in the QScripts and Rules section of the search results.
• Press Edit a Copy (bottom-left corner of the preview).
• Modify the JavaScript (see QScripts for more detail on this).
• Either:
• Run the QScript, by pressing the blue triangle button.
• Save the QScript and run it at a later time, using Automate > Run QScript (Macro) from File.

### Customizing QScripts in older versions

• Create a new text file, giving it a file extension of .QScript. See here for more information about how to do this.
• Modify the JavaScript (see QScripts for more detail on this).
• Run the file using Automate > Run QScript (Macro) from File.

## JavaScript

includeWeb('QScript Selection Functions');  // for recursiveGetAllTablesInGroup

var tables = [];
var deleted_table_names = [];
recursiveGetAllTablesInGroup(project.report, tables);

for (i = 0; i < tables.length; i++) {
table = tables[i];
try {
table.calculateOutput();
}
catch (e) {
deleted_table_names.push(table.name);
table.deleteItem();
}
}

if (deleted_table_names.length > 0) {
log('The following tables have been deleted:');
for (i = 0; i < deleted_table_names.length; i++) {
log(deleted_table_names[i]);
}
}
else log('No tables have been deleted.');