I'm buiding a SP2010 site template for Hiring Managers to evaluate candidates. One part of this template will be a Candidate Interview Scale which I want to use InfoPath 2010 to build. It's a very simple form with the following fields:
- Candidate's Name
- Performance Category
- Weight of that category
- A field for the interviewer to enter a score for the category
- A calculated field to multiply the score against the weighting.
As I said, pretty simple. The tricky part is that because this will be included in a site template that will be used for all hiring positions, the Performance Categories and the Weighting will change from position to position. I need the hiring manager to be able to input the categories and their respective weighting into a data source (probably a SP list) and have that data populate the InfoPath form fields. If it was a single SP site, easy to do, but because this is a site template and there is no way of knowing what site name will be given when a new hiring site is created, I'm struggling to figure out how to dynamically create the data connections to the list that contains the category and weighting data.
Can anyone point me in the right direction or tell me I'm all screwed up in my logic?
Thanks, Bill