PDF Editing Issues

Create PDF Rating Fields with Letter Labels and Numeric Values

Muhammad TalhaMuhammad Talha Nov 19, 2026 868 views

Question details

Create PDF rating fields that display letters while storing numeric values for an automatic total.

Create PDF Rating Fields with Letter Labels and Numeric Values
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.
Before you start

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.

Solution 1Recommended

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.

1
Add rating drop-downs

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.

2
Assign letter and number pairs

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.

3
Create the total field

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.

4
Add the calculation

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;

5
Test and save

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.

Use PDF drop-down export values and a calculated total
Viewer compatibility: The calculation requires a PDF viewer that supports and permits form JavaScript. Update the field names in the script if your form uses different names or more criteria.
Spreadsheet alternative

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. 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. 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. 3. Add rating lists: Select A2:A4, open Data > Data Validation, choose a list, and use E2:E4 as the source.
  4. 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. 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.
Select letter ratings from drop-down lists and calculate a totalOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceExport a completed rating sheet as a PDF
microsoft office alternative - wps office

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.