Script required

Hi Everyone,

I'm new to scripting so I would like some assistance please.

I have 3 dropdown boxes that has the following codes listed 3G20, 3G21, 3G22 and depending on the code chosen, I would like to use these variables to calculate the form as per below.

Currently,

Dropdown box 1 populates TextField A with one of the codes
Dropdown box 2 populates TextField B with one of the codes
Dropdown box 3 populates TextField C with one of the codes

Please note that also NumericField 1, NumericField 2 and NumericField 3 will be values entered manually by user to be calculated.

Can anyone help me with a script to do the following?

Dropdown box 1

If TextField A = “3G20”, then enter NumericField 1 into NumericField 20
If TextField A = “3G21”, then enter NumericField 1 into NumericField 21
If TextField A = “3G22”, then enter NumericField 1 into NumericField 22

Dropdown box 2

If TextField B = “3G20”, then enter NumericField 2 into NumericField 20
If TextField B = “3G21”, then enter NumericField 2 into NumericField 21
If TextField B = “3G22”, then enter NumericField 2 into NumericField 22

Dropdown box 3

If TextField C = “3G20”, then enter NumericField 3 into NumericField 20
If TextField C = “3G21”, then enter NumericField 3 into NumericField 21
If TextField C = “3G22”, then enter NumericField 3 into NumericField 22

Then

Total all NumericField 20 amounts and enter total into TotalField 5
Total all NumericField 21 amounts and enter total into TotalField 6
Total all NumericField 22 amounts and enter total into TotalField 7

Thank you in advance,

Arti