Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 03, 2024 03:03 PM
Hey All.
Curious how I might set this up. Here's what I need.
I have a form that interested parties need to fill out, an application.
We review the potentials, and start the first pass of approvals/denials.
The next stage is taking those that enter the next pass to be reviewed by instructors(who have their own base with info that can be a linked record to draw from)
So we have a list of of records/attendees
What I want to be able to do is have each of the instructors to see the applicant, and make their ratings on each person/attendee/record.
I'd thought of setting up like dynamic tables:
Then I want an interface that makes it easier for the instructor to quickly rate each individual/potential attendee.
I think I'm almost there, but not sure.
Thanks!
Sean
May 03, 2024 04:12 PM
Sean, what are you not sure about? Creating the interface?
May 03, 2024 04:25 PM
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.
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.
May 03, 2024 05:42 PM
Here is how we built something similar:
Tables:
May 06, 2024 09:08 AM
You lost me at Junction table 🙂
Already a bad day LOL.
May 06, 2024 09:12 AM - edited May 06, 2024 09:37 AM
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)
Jun 03, 2024 12:15 PM
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
Jun 03, 2024 01:46 PM
Outside software isn't an option as my company is very strict about integrating other software, but thanks!