Skip to main content
hockward
hockward
Participant
April 9, 2019
Answered

Convert letters into numeric values for multiple fields

  • April 9, 2019
  • 1 reply
  • 668 views

I am making a form where letter grades will be entered. I need the form to convert the letter grade into a number value. The corresponding number values will be added together to calculate a total in another field.

For this scenario, A = 4, B = 3, C = 2, D = 1, F = 0. For reference, some of the field names are "ELA1", "ELA2", "ELA3", and "ELA4".

I am new to this and can't quite find a similar solution. Thank you for any help!

This topic has been closed for replies.
Correct answer try67

I would use a drop-down with the letters as the items and the numbers as their export values. You would then be able to add them up using the built-in Sum command. It's the easiest way of doing it.

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
April 9, 2019

I would use a drop-down with the letters as the items and the numbers as their export values. You would then be able to add them up using the built-in Sum command. It's the easiest way of doing it.

    hockward
    hockwardAuthor
    Participant
    April 9, 2019

    Oh, wow. That is so much easier than what I was trying to do initially and it accomplishes what I want.

    Thank you so much!

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices