Orderby or Sort

I'm working on a merch app where users can log the merch they sell.

Table 1: Merch Prices. It contains all of the unique items. One row for each size, color, etc.

Table 2: Merch Log. this is the table that the form is linked to and as the user selects the catergory, item, size, etc. they save it and it creates an line for each item sold.

 

Both tables include the column "size" (xs, s, m, l, etc.). Not all items have all the same size options (have some toddler sizes as well for some items). 

I created a "sort size" column in the merch details that uses numbers to easily sort from small to large.

How do I sort the order of the sizes in the app viewer? 

 

Screenshot 2023-07-30 190252.pngScreenshot 2023-07-30 190342.png

0 1 87
1 REPLY 1

In Suggested Values :

LIST("S", "M", "L", "XL", "XXL")

Top Labels in this Space