You need to sign in to do that
Don't have an account?
_alex23
Vf page combining values from multiple related objects
Hi there,
I need to create a custom Visualforce page which would display school’s transcript in the following way:
Name: John Smith (field on Contact object)
Student ID: 1234 (field on Contact object)
Program Enrollment: High School / Middle School / Elementary School (picklist based on what program the contact is enrolled in) (Program enrollment object, lookup with Contact)
Cumulative GPA: (3.90) (Program enrollment object)
followed by a set of tables (that should be rendered based on the Program Enrollment selection):
H1: Term: Q3 2020 (Term registration object., lookup with Contact)
H2: Semester GPA: 3.5 (Term registration object)
Course | Grade | Earned Credits
ENG10 | A. | 2
Math10 | B. | 3
(course grades and info comes from Course enrollment object, lookup with Term registration)
Please let me know what direction to go with it. I’m pretty new to Visualforce and this is a bit overwhelming. Thank you.
I need to create a custom Visualforce page which would display school’s transcript in the following way:
Name: John Smith (field on Contact object)
Student ID: 1234 (field on Contact object)
Program Enrollment: High School / Middle School / Elementary School (picklist based on what program the contact is enrolled in) (Program enrollment object, lookup with Contact)
Cumulative GPA: (3.90) (Program enrollment object)
followed by a set of tables (that should be rendered based on the Program Enrollment selection):
H1: Term: Q3 2020 (Term registration object., lookup with Contact)
H2: Semester GPA: 3.5 (Term registration object)
Course | Grade | Earned Credits
ENG10 | A. | 2
Math10 | B. | 3
(course grades and info comes from Course enrollment object, lookup with Term registration)
Please let me know what direction to go with it. I’m pretty new to Visualforce and this is a bit overwhelming. Thank you.
You can take help from the below link and get started with VF page. Once you have something ready we can suggest you the changes as per the issues that you are facing:
https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_quick_start.htm
Let me know if you need more help on this.
Thanks,
Abhishek Bansal.
Gmail: abhibansal2790@gmail.com
Skype: abhishek.bansal2790
Phone: +917357512102
Hi Abhishek,
Here is the way I'm going with it. I figured I need to create a custom controller and a wrapper class.
Here is the Visualforce page (just the basic table for now, to see if it works):
I get an error:
System.LimitException: Too many SOQL queries: 101
Class.transcriptPage.<init>: line 6, column 1
which I assume can be solved (I'm very new so I might be wrong by passing the current record ID from URL to controller and somehow quering results only for one record (this is the goal).
I couldn't yet figure out how to do that.
I would really appreciate any help with that as well as feedback regarding the general direction of what I am trying to do.
Thank you.
Update.
Controller:
Syntax seems to be correct, but no data is returned.
I would really appreciate any recommendations as I am not sure where the problem is. I suspect that somehow my controller doesn't store the data, debugging gave me the following error: "Inner types are not allowed to have inner types". I don't know how to interpret it at all.