Sort Multiple Fields

  • This form has 67 entries in it, one per county. Each field is the name of one of the counties. People assign ‘routes’ through these counties by entering a number in each county field. Everything works with the under Master/Detail but I need to sort the list on the contents of the fields (numeric) rather than on the field name. Is that possible with so many fields?

    In the results page:
    [cfdb-html form=”FORM NAME HERE” filter=”submit_time=$_GET(st)” trans=”Call=strtoupper(Call)”]
    Works but needs to sort on the numbers so that people will see the numerical sequence of the counties traveled through.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    Try the NaturalSortByField tranform
    https://cfdbplugin.com/?page_id=1135

    Thread Starter larckco

    (@larckco)

    Thanks for the reply, I tried NaturalSortByField but it doesn’t seem to work with cfdb-html. I need the data in vertical format to avoid the scroll bars with so many entries. I even tried chaining sorts together but no go.

    Thanks again great plugin but I guess they will just have to sort the county sequence using Excel.

    Plugin Author Michael Simpson

    (@msimpson)

    NaturalSortByField, or any transform, works the same with all shortcodes. It does not change how the data is displayed, it orders the entries prior to being displayed by the shortcode.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Sort Multiple Fields’ is closed to new replies.