0

Sort Choice (dynamic) entries

Is there a way to sort the entries in a choice (dynamic) field? I've tried wrapping sort() around my Dynamic values selection — sort(select Category) — but that appears to have no effect. Currently, these values are showing up in the reverse order they were entered into the Category table.

8 replies

null
    • Sviluppatore Ninox
    • Fabio
    • 3 yrs ago
    • Reported - view

    Hi Kevin. Try this:

    --

    select Category order by *

    --

    * Amount or Name or any field in the table you want to sort by

       Fabio

    • Kevin
    • 3 yrs ago
    • Reported - view

    That works! Thanks!

    • activelifejss
    • 8 mths ago
    • Reported - view

    This works great but what about sorting the actual data in the grid view? For example, once the choice is selected and the record is saved, it seems that only the ID is actually saved so that if I try to sort the results, I cannot get it to sort this column alphabetically, even if I set the Dynamic value name as text('FieldName').

    In summary, how do I force a column that is populated with Dynamic Choice data to sort alphabetically?

    • Fred
    • 8 mths ago
    • Reported - view
     said:
    but what about sorting the actual data in the grid view?

     What "grid view" are you talking about?

      • activelifejss
      • 8 mths ago
      • Reported - view

       I mean "table" view. Grid is a term from another ERP system.

      • Fred
      • 8 mths ago
      • Reported - view

      This post is about dynamic fields.

      Are you asking how to sort a view element or a table form?

      Are you using a dynamic field to modify a view element?

      Are you trying to sort a table form with a column that shows data in a dynamic field?

      May I suggest that if this is not about sorting the choices in a dynamic fields, please start a new post.

      • activelifejss
      • 8 mths ago
      • Reported - view

       I guess I will look for another thread that is related to sorting the Dynamic Choice data in views...

      • Fred
      • 8 mths ago
      • Reported - view

      Or you can start a new post. That way we can focus on your question specifically. If you don't feel like writing out the fields and links, you can add a sample DB.

Login to reply

Content aside

  • 8 mths agoLast active
  • 8Replies
  • 506Views
  • 2 Following