Order of checkbox elections in reporting | Community
Skip to main content
T
ThomasNe2
New Participant
March 14, 2025
Solved

Order of checkbox elections in reporting

  • March 14, 2025
  • 3 replies
  • 582 views

I am pulling reports for some teams who need view of a custom field in a report. 

This custom field shows the names of teams but when pulled into a report they appear in a different order each time. 

Is there a reason for this and is there a way to change it? 

Best answer by Daniel_Clarke

Hey @thomasne2 - 
Kurt's solution can still work for you, you can add a calc field that sources the checkbox and then do the sort against that field and point your reporting to that new calc field. This will also allow you to group by the field - something you cannot do against a checkbox field!

You can place this calc field down in an admin only section as well so it is not interfering with the UI of the form.

 

New text based calculated field:

REPLACE(REPLACE(SORTASCARRAY(ARRAY({DE:FIELDNAMEHERE},' , ')),'["',""),'"]',"")



3 replies

Daniel_Clarke
Daniel_ClarkeAccepted solution
New Participant
March 14, 2025

Hey @thomasne2 - 
Kurt's solution can still work for you, you can add a calc field that sources the checkbox and then do the sort against that field and point your reporting to that new calc field. This will also allow you to group by the field - something you cannot do against a checkbox field!

You can place this calc field down in an admin only section as well so it is not interfering with the UI of the form.

 

New text based calculated field:

REPLACE(REPLACE(SORTASCARRAY(ARRAY({DE:FIELDNAMEHERE},' , ')),'["',""),'"]',"")



    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStore
    New Participant
    March 14, 2025

     

    Very nice @daniel_clarke,

     

    That's a new one for me, but I like it! Thanks for sharing!

     

    Regards,

    Doug

      MoniqueEvans
      MoniqueEvans
      New Participant
      March 14, 2025

      Unfortunately, I haven't found a way in the system to sort these and often have to export the results to Excel. @doug_den_hoed__atappstore do you have any clever tricks up your magical sleeves?

      Kurt_Jones
      Kurt_Jones
      New Participant
      March 14, 2025

      Thomas, this looks like a calculated field.  There are some expressions in the calculated editor you can use such as SORTASCSTRING or SORTDESCSTRING to help this list be in a sorted order.

        T
        ThomasNe2Author
        New Participant
        March 14, 2025

        Hi Kurt - not calculated - just a checkbox custom field. 

        Terms & ConditionsAccessibility statement

        Loading footer...