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

[LeviP]

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

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

[TeeSee1]

Try

ORDERBY(SELECT(...),[orden], TRUE/FALSE)

[LeviP]

Thank you, i am trying this

IF( 
  [tipo_tarifa] = "Mensualidad",
  ORDERBY(
    SELECT(meses[mes], [mes_laborable] = "Si"),
    [orden], TRUE),
  LIST("")
)

I getting this error ORDERBY has invalid inputs

[TeeSee1]

ORDERBY() requires key values as its first argument.

Try SORT(SELECT(table[non key col], condition)) instead

[LeviP]

Hello, I have used this formula and the sorting works, but it shows the IDs and not the name of the month, although in the months table the [nombre] field is as label

IF( 
  [tipo_tarifa] = "Mensualidad",
  ORDERBY(
    SELECT(meses[id_mes], [mes_laborable] = "Si"),
    [orden],
    FALSE
  ),
  LIST("")
)

This is a text field with a formula in suggested value, OK.