Use case : “I want to automatically add options in single select. These options need to get updated automatically when a new ‘unique’ value appears in a column of different table. The value of option added automatically in single select, should be the new unique value that appears in the column of different table.”
Problem : I haven’t been able to get a solution for this. I have tried to solve this through airtable scripting. I have repeatedly got a issue in the following code for simple testing ( I may add values of different column in the script later) :
// query for all the records in a table
let table_uploader = base.getTable("Data Uploader");
const selectField = table_uploader.getField("Location-select-script");
await selectField.updateOptionsAsync({ choices: [
...selectField.options.choices,
{name: 'London'},
],})
I could print through console.log and see that “Location-select-script” is a single select option, but when I was typing code to update ‘single select options’ and use “await selectField.updateOptionsAsync” , a red line is appear under updateOptionsAsync . And it’s not recognizing it as a inbuilt method for selectField.
Please confirm, is there issue in code to be resolved. Or are there any other solutions I can see into, to get this functionality working.
