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
Related ideas
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?
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.
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!
these lists are most useful as excel exports when the address fields are separate
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...