This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
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});