Can't insert coded field into collection

Ask the community
, ,
6

So far I have narrowed my issue down to be something with the way I add the input fields together.
Eg. if I put $w(’ #inputRevenueItemTotalAmount ').value = 2*2, it works fine. It shows in the collection as expected when I save the dataset.
However, if I add the fields together, like this:

var total = 0
let number1 = Number($w(‘#inputRevenueItem1Amount’).value)
let number2 = Number($w(‘#inputRevenueItem2Amount’).value)
total = number1+number2
$w(’ #inputRevenueItemTotalAmount ‘).value = total
or even
$w(’ #inputRevenueItemTotalAmount ‘).value = Number($w(’#inputRevenueItem1Amount’).value)+Number($w(‘#inputRevenueItem2Amount’).value)

Nothing shows up in the collection after I save!
It is all shown on the page just fine, but it never shows up in the database.

I’m mystified