Compare values based on Pre-Requisites
Hi, I need help in figuring out how to validate if the user currently registering for the training has attended the corresponding pre-requisite training. To elaborate, Trainings - Registrati...
Forum Discussion
Divya,
as Don's diagram suggests, you will need to have a table for the Students, with the key field of email. I guess, in theory you can have an Automation create that Student field if. Registration is entered and the student email record did not exists, but unless this is a very small school, you will have other information about the students aside from their basic email address. Although, I suppose that the student name can be added later.
Is this an EOTI app (Open to everyone on the Internet) or do these users each have a userid?
For the next step in your question, if you make a relationship where one student email has Many registrations, then you can make a combined text summary field of the course codes of the registrations where the student successfully completed the course.
U will also need a similar field where the course has a combined text summary field of the pre req courses.
once you get that far, post back and we can move on to the next step.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
as Don's diagram suggests, you will need to have a table for the Students, with the key field of email. I guess, in theory you can have an Automation create that Student field if. Registration is entered and the student email record did not exists, but unless this is a very small school, you will have other information about the students aside from their basic email address. Although, I suppose that the student name can be added later.
Is this an EOTI app (Open to everyone on the Internet) or do these users each have a userid?
For the next step in your question, if you make a relationship where one student email has Many registrations, then you can make a combined text summary field of the course codes of the registrations where the student successfully completed the course.
U will also need a similar field where the course has a combined text summary field of the pre req courses.
once you get that far, post back and we can move on to the next step.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Yes Mark, this is an EOTI app and anyone can register with the link.
------------------------------
Divya (OSSE-Contractor) Pogaku
------------------------------
------------------------------
Divya (OSSE-Contractor) Pogaku
------------------------------
