I’m creating a dropdown that fetches options from an external spreadsheet via an API. I need it to retrieve elements based on both a filter and a group. In the filter part, I can apply a “sort by” criteria, but when I add the grouping, it disregards the filter and arranges the options in alphabetical order.
If I add a “sorted” after the “grouped by,” the field becomes empty. Does anyone know which order I can use to make the “sort by” work?