Form: how to convert text grades to numbers
I am working on an assessment form in Acrobat, using the Form tool. 10 learning outcomes will be assessed with Unsatisfactory, Satisfactory, Good and Excellent. I use combo boxes to select the USG or E per learning outcome. Each learning outcome is worth 10% of the overall result. If I could convert satisfactory to 1, good to 2 and excellent to 3, I could calculate/automate the overall end result (being USG or E). E.g. 10 to 14 points is Satisfactory, 15-24 points is Good. How can I do this? I am using some javascript already in the form, to populate text boxes, based on combobox selections, but I am new to it.
