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,
I am assuming that you have an architecture that looks like this:
How many Courses are going to be in the DB?
If you are dealing with a small number that can be easily managed by a single person, you can build Formula Check Box fields in the Students table that will determine if the requirements for a specific course have been met. This is a manual process and requires data base maintenance in the Students table every time a Course has its Prerequisites changed.
Further assume in the Course Table that
Record ID# 5 is Course Number 300 and that it has two prerequisites of the Courses with Record ID #1 and Record ID#2
In the Students Table create Summary Fields from the Registrations Table using the [Related Course]
# of Courses RID 1 your filter is Related Course =1
# of Courses RID 2 your filter is Related Course =2
In the Students Table create the field [Course Req 300 FC}
if ( [# of Courses RID 1] >0 and [# of Courses RID 2] >0, true, false)
Create a Formula User field in the Course table called Related Student User and set the value to User()
Add another relationship to your app between the Course and Students table. Use the Related Student User field you just created as the reference.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
I am assuming that you have an architecture that looks like this:
How many Courses are going to be in the DB?
If you are dealing with a small number that can be easily managed by a single person, you can build Formula Check Box fields in the Students table that will determine if the requirements for a specific course have been met. This is a manual process and requires data base maintenance in the Students table every time a Course has its Prerequisites changed.
Further assume in the Course Table that
Record ID# 5 is Course Number 300 and that it has two prerequisites of the Courses with Record ID #1 and Record ID#2
In the Students Table create Summary Fields from the Registrations Table using the [Related Course]
# of Courses RID 1 your filter is Related Course =1
# of Courses RID 2 your filter is Related Course =2
In the Students Table create the field [Course Req 300 FC}
if ( [# of Courses RID 1] >0 and [# of Courses RID 2] >0, true, false)
Create a Formula User field in the Course table called Related Student User and set the value to User()
Add another relationship to your app between the Course and Students table. Use the Related Student User field you just created as the reference.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Thanks Don.
But the issue is there is no separate student user table. This application is open to "Everyone on the internet" and any user can register with the link.
------------------------------
Divya (OSSE-Contractor) Pogaku
------------------------------
But the issue is there is no separate student user table. This application is open to "Everyone on the internet" and any user can register with the link.
------------------------------
Divya (OSSE-Contractor) Pogaku
------------------------------
- MarkShnier__You
Qrew Legend
Divya,
You will need to have a table of Student emails. There is not a way to determine if an email address has registered for the Pre Reqs unless you have a table of student email addresses and a relationships where 1 Student email has many Registrations.
If necessary, the student email address records can be Auto created using an Automation.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Divya,
Reinforcing what Mark said. Regardless of the database, you have to have a Student record where the past registrations and course work exists.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
