Rename All Query Exports
Ever needed to quickly rename a large number of query exports? For example, you're querying on a Configurable Joins - Form Response base and want to get rid of the form title prefix on each input.
To do so quickly, click Rename Exports so that all the export names become editable:
Next, drop something like this into your browser's console. This example will replace '2021 Data Survey ' with nothing:
$('.query_part_rename').each(function () { $(this).val($(this).val().replace('2021 Data Survey ', '')); $(this).change(); });
Another example that replaces underscores with spaces:
$('.query_part_rename').each(function () { $(this).val($(this).val().replace(' ', '_')); $(this).change(); });
How does this work? This script selects all input elements and executes a function on each. That function sets the value of the input to the existing value after running it through the replace()
function.
No Comments