Remove unused select field options easily!
This extension will help you find unused select dropdown data (from either single select or multiple select fields) and delete them!Base with extension installedTo use it, install the "Script Extension" and paste the code below into it, and a video of how to do that is below Code:let settings = input.config({
title: `Identify and remove select field options that are not in use`,
items: [
input.config.table("table", { label: `Table` }),
input.config.field("field", { parentTable: `table`, label: `Field` }),
],
});
let { table, field } = settings;
let fieldData = table.getField(field.id)
let fieldType = fieldData.type
if(fieldType != "singleSelect" && fieldType != "multipleSelects" ) throw("Only works with single select or multiple select fields")
let query = await table.selectRecordsAsync({fields: [field]})
let inUse = new Object;
for (let r of query.records){
let selectedOptions = r.getCellValue(field)
if(selectedOptions){
if(f
