Separate data in new SKY lists

The new sky lists are a nice improvement but multiple data fields are grouped together.  A recent request was for a list of incoming students and the town/city where they lived.  The list was easy to create in the new sky lists, but the address data was all in one fields (address line1, address line 2, city, state, zip, country).  It would be better if all data fields remained separate, this would allow for better filtering and sorting options without exporting to a spreadsheet and manually manipulating data.

  • Gregg
  • Mar 20 2017
  • Implemented
  • Attach files
  • john ronan commented
    February 26, 2020 17:20

    This is marked as 'implemented', but I disagree.   In a list I created in Enrollment management, there is  ONLY a column for a combined address.

    Why, when putting this into one kind of list [as described by J. Wittenberg, below, it doesn't automatically go into *ALL* kinds of lists?

  • Oona McKnight commented
    January 16, 2018 22:04

    This is helpful, but there is a similar issue in other lists (such as Report Card Grades) where the student's full name is there but you can't include first and last name separately, for alphabetizing etc after export. All fields in all list types (not just the 4 Janet listed) should be able to be pulled separately. Similar issue with Parents/Guardians going into one column. Until we can choose any field to include or filter on (as it was in EE with Queries/Exports) the SKY lists are not a good replacement for the Advanced Lists.

  • Janet Wittenberg commented
    January 12, 2018 21:47

    Hi all! With this month's release (Jan 10, 2018) we added the ability to separate the Primary address fields in the User, Student, Candidate and Faculty lists! Let us know if it meets your needs!

  • Guest commented
    December 06, 2017 21:15

    these lists are most useful as excel exports when the address fields are separate

  • Austin Ewachiw commented
    July 26, 2017 13:08

    I couldn't agree more.  A lot of data analytics can be drawn from Zip Code, or State.  This makes it nearly impossible extract that data easily.  I now need to consult my Excel Expert on how to break out City State Zip.  I think i will probably be going over to the dreaded Advanced Lists for this...