Dec 02, 2021 08:06 PM
I have a view that is being grouped by two fields. When I do
Dec 03, 2021 12:42 AM
Hi @Michael_Henry1 - yes, the records returned from a script query are “flat” and don’t take account of any groups you’ve made in the UI. But the results will take acount of the filters you have applied (if any).
Dec 03, 2021 07:01 AM
In my experience, not only is the query result “flat”, it is not in the order displayed in the user interface. The results are sorted according to any specified sort, but not sorted according to grouping. Records from different groups may be interleaved with each other.
Dec 04, 2021 10:12 PM
I just ran a test, and the returned records from querying a specific view with grouped records did maintain the group order, including the record order inside each group. Granted it was a small sampling, but I’d like to think that this behavior would extend to larger datasets as well.
Dec 05, 2021 07:25 AM
Awesome. Airtable must have quietly fixed.