How to sort a list in a text field & Suggested values ​​section

Hey guys could someone help?

in my table I have these fields
[tipo_tarifa] Enum "Matricula","Mensualidad"
[nombre] type text
In the Suggested values ​​section I have this formula
IF(
[tipo_tarifa] = "Mensualidad",
SELECT(meses[mes], [mes_laborable] = "Si"),
LIST("")
)
It returns the list without any problems, but I would like it to be returned in order by the [orden] field of the meses table

"meses" table records

LeviP_0-1748544314129.png


With the formula it returns the result in this way, I want it to return the months as they are ordered in the original table

LeviP_1-1748544819093.png

 

 

0 4 231
4 REPLIES 4
Top Labels in this Space