Hi everyone, I apologize if I’m missing something obvious here! I’m pulling data into a repeating group from an external API using a front end workflow. The API data has columns called date (date type), customer (text) and truck number (text). I’d like to populate the repeating group with the API results and sort the repeating group first by date, then by customer, then by truck number. So, for example, the RG would show all of the rows for Jan 1 first, then all of the rows for customer AAA at the top, and for customer AAA their trucks sorted in alphabetical order.
Here’s what I have in my Display List in a Repeating group action:
The problem is, it only seems to be sorting by date, and isn’t sorting by Customer or Truck number at all. I’ve tried a million things and can’t seem to get it to work. Any ideas for what I’m missing?
Thanks in advance!