I'm pretty new to JavaScript so I have very little idea how to achieve this. But I'm learning. 🙂
I have three (3) dropdown boxes on a PDF form where the user can select a series of courses. All dropdown boxes contain the same list of courses, for example...
Course A - Design widgets
Course B - Assemble widgets
Course C - Test widgets
Course D - Paint widgets
Course E - Pack widgets
When a selection is made in one of the dropdowns (Course1) an adjacent textbox (NominalHours_Course1) needs to display the number of hours that the course typically runs for (e.g. 5, 8, 12, 15, etc.). This is a predetermined value for each course and needs to be retrieved from a table... (I assume stored somewhere in the document?).
I'm after the same sort of functionality as the MS Excel VLOOKUP function.
Reading some of the posts on this forum, it looks like the relationship between course and hours should be in a document level script, allowing the "Nominal Hours" values to be referenced by any of the dropdown boxes and textboxes. This would also make it easier to change values if required since the changes would only need to be made in the one location.
I have no idea where to start with this. I have tried working through the JavaScript Tutorials on w3schools.com but I think I might be trying to bite off more then I can chew (being such a beginner at JavaScript). 
Hoping someone can help.
1 Correct answer
Sure. OK, so you can place this code as your doc-level script:
var courseData = {
"Course A - Design widgets" : 5,
"Course B - Assemble widgets" : 8,
"Course C - Test widgets" : 12,
"Course D - Paint widgets" : 15,
"Course E - Pack widgets" : 21
};
function calcCourseHours(dropdownFieldName) {
var v = courseData[this.getField(dropdownFieldName).value];
if (v) event.value = v;
else event.value = "";
}
And then as the custom calculation of your text field enter this code:
...calcCourseHours("Course1");
55
Replies
AdChoices