New to FileMaker Pro today
I apologize upfront at my ignorance. I have used Bento and Excel quite a bit, but am new to using FileMaker Pro. I think my project is fairly simple, but I'm not sure where to start. Here is what I am trying to do:
I work in a school setting. Three times during the year we assess all of our students with various assessments. I am able to export excel or .csv spreadsheets with test scores from each individual test sites. I then have several spreadsheets with individual test scores for the students. I would like to merge the different test scores from these separate spreadsheets into one single, sortable spreadsheet or database. Each test spreadsheet has the common field of "student name." My goal is to have a final spreadsheet/database with the student names and each column being a different test score. I could then access all of the test scores for an individual student from one database rather than searching individual spreadsheets. Does this make sense? As it is now, I spend hours sorting each spreadsheet by name, copying and pasting the names in alpha order side by side in a spreadsheet. I then visually go down the spreadsheet making sure the names line up. If a student didn't take a particular test, their name is not on one of the lists. I then need to add cells to bump the name up or down to proper alignment. Once I am sure they all line up, I delete the names from one list so the test scores for the tests are side by side. I then repeat the process with the next test scores from it's spreadsheet. It is terribly inefficient and prone to error. If I could have the different spreadsheets match themselves by name and import together into one database/spreadsheet, I would save a ton of time and effort. Make sense? Can this be done in Filemaker Pro? How would I set up the spreadsheets to make this happen in terms of relationships, etc. I'm pretty techy, but with this I feel like I'm learning a new language.