Can HubSpot forms pull class records and use associated teachers’ names in evaluation questions?
We store classes in HubSpot’s native Courses object. Each class has 1–4 teachers saved as associated Contacts.
We need:
A class dropdown that updates automatically, filtered by term and status. New eligible classes should appear without manually editing the form. Canceled/closed classes should be excluded from registration; completed classes should remain available for evaluations.
An evaluation that uses each associated teacher’s name in the questions: “How was Molly? Rate 1–10,” “How was Josh? Rate 1–10,” plus strengths/improvement questions for each teacher. It should show only the teachers associated with the selected class and link the submission to the student’s Contact record.
Can native HubSpot forms do this using CRM data or HubDB? If we use a WordPress class picker to pass the class Record ID, can a native form handle the teacher-specific questions, or would the evaluation also need a custom/third-party form?
We can upgrade and are open to third-party tools. What’s the simplest approach?
HubSpot’s native forms cannot perform either of these functions on their own, but it is possible to get close to the desired result without needing complex development:
Class Dropdown Menu
Dropdown menus in forms pull their options from a property—not directly from CRM records—so they do not update automatically. A simple solution is to implement a synchronization process that updates the property’s options whenever a class is created or its status changes. This can be achieved using a workflow with a custom code action.
I suggest using two separate properties:
“Class for Enrollment” (for classes open during the current academic term) and “Class for Evaluation” (for classes that have already concluded).
This way, canceled or closed classes disappear from the enrollment options, while completed classes remain available for evaluations.
Specific Questions for Each Teacher
This is the more complex part. Native forms do not allow you to modify question labels based on the class selected. Here are a few viable options:
Stick with the native solution by using a separate form for each teacher.
Use a page within the HubSpot CMS. This only works if students are logged in. HubL can display associated contacts (your teachers) only on password-protected pages or through a membership system. Additionally, I recommend verifying that the “Courses” object is compatible with HubL before choosing this route.
Things to Consider Before Proceeding
If you save evaluations as properties on the student’s contact record, each new evaluation will overwrite the previous one. If you need to maintain a history of evaluations for each teacher, the best approach is to store each evaluation as an independent record—for example, by using a custom object associated with the class, the student, and the teacher—rather than simply saving them on the contact record.
Clancy, native forms won’t get you all the way. Dropdown options are static and a form can’t read associated records, so teacher names can’t appear in the questions
Workable setup: a workflow on Courses that updates the class dropdown property’s options through the Properties API when a class changes status, so registration stays a native form. For evaluations, a small custom form on a CMS page or an app card that reads the class’s associated teacher contacts and writes each rating back to the student’s record or a custom object
Hi @CJohnstonID adding to Dani and Manhar’s suggestions.. if you go with a WordPress class picker, some custom code on that page could pull the associated teachers, display their evaluation questions, and send the responses into HubSpot through the Forms API.
Would students receive an evaluation link for a specific class, or do they need to select the class themselves? A class-specific link could remove that extra step.