Create PDF Rating Fields with Letter Labels and Numeric Values
Question details
Create PDF rating fields that display letters while storing numeric values for an automatic total.

- Product
- PDF form editor
- Device & OS
- not provided
- Scenario
- A form needs a letter-based rating for each criterion and a summary field that adds the corresponding numeric scores.
- Observed behavior
- Each selected letter should contribute its numeric export value to a calculated, read-only total.
Open the PDF in a form editor that supports drop-down export values and JavaScript calculations, such as Adobe Acrobat Pro. Decide which number corresponds to each letter and how many rating fields the form needs.
Use PDF drop-down export values and a calculated total
Use this method to display letter ratings while summing their numeric values in the PDF form.
In Adobe Acrobat Pro, open the PDF and select All tools > Prepare a form. Add a drop-down field for each criterion, naming them Criterion1, Criterion2, and Criterion3.
Open each drop-down's Properties and select Options. Add each letter as an item and its corresponding number as the export value, such as A with export value 3, B with 2, and C with 1.
In Prepare a form, add a text field named Total. Open its Properties and select Read Only on the General tab so users cannot overwrite the calculated result.
In the Total field's Properties, open Calculate, select Custom calculation script, and choose Edit. Enter: var names = ['Criterion1', 'Criterion2', 'Criterion3']; var total = 0; for (var i = 0; i < names.length; i++) { var n = Number(this.getField(names[i]).valueAsString); if (!isNaN(n)) total += n; } event.value = total;
Select Preview in Prepare a form, choose ratings, and confirm that Total matches their numeric export values. Save the PDF, then test it in the PDF viewer your recipients will use.

Calculate letter ratings in WPS Spreadsheets
WPS Spreadsheets can provide a free, easy-to-use alternative for selecting letter ratings and calculating numeric totals. Exported PDFs are static and do not retain the spreadsheet's interactive calculations.
- 1. Create a rating table: Open WPS Spreadsheets and enter criteria in a column. Reserve cells A2:A4 for the letter ratings and B2:B4 for their numeric scores.
- 2. Enter the score mapping: Enter letters A, B, and C in E2:E4 and their corresponding scores, such as 3, 2, and 1, in F2:F4.
- 3. Add rating lists: Select A2:A4, open Data > Data Validation, choose a list, and use E2:E4 as the source.
- 4. Calculate scores and total: In B2, enter =IFERROR(VLOOKUP(A2,$E$2:$F$4,2,FALSE),0) and fill it down through B4. In B5, enter =SUM(B2:B4).
- 5. Save or export: Use File > Save As to keep an editable spreadsheet, or use the PDF export option to create a static copy of the completed ratings.

Frequently Asked Questions
What is an export value in a PDF drop-down?
It is the value associated with a displayed option. In the drop-down's Properties > Options, you can display a letter such as A while assigning it a numeric export value such as 3.
Why is the PDF total not updating?
Check that the field names in the Total field's Calculate script match the actual drop-down names and that each option has a numeric export value. Also test the form in a viewer that supports PDF form JavaScript.
Can users change the calculated total manually?
To prevent manual changes, open the total field's Properties and select Read Only on the General tab. The calculation can still update the field.
Will a PDF exported from WPS Spreadsheets keep the rating calculations interactive?
No. Exporting the sheet to PDF creates a static copy. Keep the spreadsheet if users need to select ratings and recalculate totals.




