Skip to main content

When querying records in the scripting extension, it is required that the fields are explicitly defined as a list of strings or added via something like {fields:table.fields} as a parameter to selectRecordsAsync.

While both methods work fine, the user is left to either type out a list of the field names/ids that will be used within the script/automation or select all the fields wtihin the table, there is no inbetween (that I’m aware of).

If there were a way to specify fields based on what is hidden/shown in a view, the querying process would be much improved.

Ex.

const table = base.getTable("Table");
const view = table.getView("View");
const query = await view.selectRecordsAsync({fields: view.fields});

you can do this with the Extensions API, it would be nice to do it in scripting as well.


Reply