Ticket: 54589

Customer: Cobell Scholarship Fund (Indigenous Education, Inc.)

Business Problem: Need to capture information from high school staff (HSS) of students (counselors) and have this information associated with student records (high school gpa, earned credits, etc.; ex: https://goo.gl/forms/8MtuS9i5UqbAikzp1).  This information could be captured via the Reference Collection Feature; however, using this information to make initial qualifying or awarding decisions is a time consuming challenge since it would have to be viewed by individual applicants rather than in a grid with a bigger picture view and tools like sorting/filtering

Workaround: Cobell is currently taking the information captured in the google form that's backed into a spreadsheet and matching it, by hand (not formulaically), to an export of their students in AW, and then importing that information into AW.  Very time consuming for them, but still quicker and more efficient than having the information in 2 different areas.