Hey - Looking for input as to how I can impro...

[Jayne_Hawkins]

Hey - Looking for input as to how I can improve the current layout of my training registration app. I’m going to try to explain it the best I can.

I have a spreadsheet with two tabs: Courses, and Registrations. Courses contains all of the course details (time, location, cost, etc.). Registrations contains the details for each participant as they’re added to a class (name, phone number, email, etc.).

Because I don’t have much experience using multiple tabs, I set the app up with two different views (one for each tab): Courses, and Class List. Courses is just a straight list of the available courses, grouped by location - it comes directly from the Courses tab. Users aren’t able to make changes to this info. When you click on a specific course, there’s a “Registration” button at the top, which takes you to a form that gathers all of the participant details. Those details feed into the Registrations tab. The Class List view was intended for someone to check how many people (and who) have been registered in a particular course.

The problem I’m having is that no one wants to use the app because they find it too hard (ie. annoying) to navigate between the two views. For example, if someone calls to be registered for First Aid, I would click on the Courses view, click on the province, click on the city, find the next available First Aid course, hit the Registration button, and fill out the form. That part is fine. However, if I want to check to see if the information saved, or see who else is in the class, I then have to go to the Class List view and navigate to the course all over again. Even worse, if no one has been registered for a class yet, that specific course doesn’t appear in the Class List view at all (because technically, there IS no class list yet). There’s a lot of back-and-forthing.

Everyone wants to see everything in one place. So I’d need them to be able to see the list of courses, click on a specific course, and be taken to the class list. Ideally, the Register button would appear on the class list. How can I make this happen?? The one thing I do need is to maintain a count of how many seats are available, and how many seats are left. Currently, the ‘total seats available’ comes from the Courses tab. I then have it set to count the number of registrations for that particular class and deduct it, to give me “seats left.”

Any help or suggestions would be greatly appreciated. I’ve been trying to figure it out for weeks now.