Sean, what are you not sure about? Creating the interface?
Sean, what are you not sure about? Creating the interface?
A couple things. In order for the interface to be designed properly, I need to know how to setup the table or tables.
The end result is an interface that whomever signs in, or at least that'd be more ideal, their name would be added to the linked field...and then the same process would be the same...If this isn't possible, then
I want to be able to have each instructor leave their ratings(example has the three separate fields) and that's it. I'd then have a total of the scores in the table.
I was thinking I'd be able to use dynamic tables, fields to generate something.
so for example.
- 1) Bob Smith-
- Instructor Tim = Rating 1, Rating 2, Rating 3
- Instructor Sean = Rating 1, Rating 2, Rating 3
- Instructor Mary = Rating 1, Rating 2, Rating 3
- 2) Kim Yu-
- Instructor Tim = Rating 1, Rating 2, Rating 3
- Instructor Tim = Rating 1, Rating 2, Rating 3
- Instructor Tim = Rating 1, Rating 2, Rating 3
Something like that. As shown above, there is one record per applicant, but instead of having to have a field for each instructor's rating(which would be 9 total fields in this scenario), I find it'd be nice to have a separate table that is fed the approved applicants for this stage, to then have multiple instructors with their own rating but for just that applicant's record. Does that make sense?
SO in order for the interface to work, I guess setting up the base/tables would be first.
However, it would be nice, based on the "Current User" feature, to have the instructor give their own rating without overwriting the other instructor's ratings, and avoiding having e.g. 9 separate fields.
Here is how we built something similar:
Tables:
- Students: person table with at least student email
- Graders: person table with email
- Scores: Junction table (on record for each grader/student combination -- created through automations)
That should get you started.
Here is how we built something similar:
Tables:
- Students: person table with at least student email
- Graders: person table with email
- Scores: Junction table (on record for each grader/student combination -- created through automations)
That should get you started.
You lost me at Junction table 🙂
Already a bad day LOL.
You lost me at Junction table 🙂
Already a bad day LOL.

Here's what I have, a staff linked table, an applicants(with emails etc), and I believe a junction table. However, I'm not sure I follow about how to do an array of instructors per one record with having ratings from each instructor?
also the rating fields are stars to make it easier to select)
did you consider using 3rd party tools?
Here is what I would do:
Use Softr for the tracking process
Map your data to Softr, there is a List available with a rating system you can use for each applicant
You can invite Instructors to give ratings of their own, comment, etc. You can also assign applicants to individual instructors.
You can check out this great video to start with Softr: https://youtu.be/oKHI2jSPWgo?si=eLVkD1TEh6gc3dOm
did you consider using 3rd party tools?
Here is what I would do:
Use Softr for the tracking process
Map your data to Softr, there is a List available with a rating system you can use for each applicant
You can invite Instructors to give ratings of their own, comment, etc. You can also assign applicants to individual instructors.
You can check out this great video to start with Softr: https://youtu.be/oKHI2jSPWgo?si=eLVkD1TEh6gc3dOm
Outside software isn't an option as my company is very strict about integrating other software, but thanks!