
UCanTrade

5 - Automation Enthusiast
Comment Post Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
‎Jul 21, 2022
02:35 PM
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});
See more ideas labeled with:
1 Comment