I hope someone can figure this out because, after almost 4 hours, I can’t seem to find a solution…
I have a series of other fields that I add together, and then have the result stored in another input field.
It is all numbers.
When I submit, all of the other input fields are added to the database without problem, but the field that I populate with the result of the other fields added together just shows up empty.
I have tried adding the field as text, but that doesn’t help.
I have tried adding a simple number or string to the field (with code) but it still shows up empty in the collection.
If I add text or a number manually into the input field, it shows up in the collection just fine.
I’ve tried using parseFloat, parseInt, .toString, Number, etc… nothing works.
Here’s the code I use: function sumRevenueAmount (){ var total
Oh and the collection field, I have tried having the type as a number and as text, it doesn’t make difference. For the other fields, they are set as numbers.
It’s a function that’s called every time there’s a change to a text field.
I’m looking at your code, I guess you are successful in adding the price to a collection?
@anders
The first example doesn’t use a dataset, it takes all it’s needed values from the text boxes and user inputs on the page.
The second example has a dataset which contains the item names and unit prices for each of them, along with the quantity ordered and the total price for each.
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.
Whereas you have most likely put your dataset fields that will contain your prices or whatever number values you have chosen, as the field type of number.
So there is one issue straight away, the user inputs are working in the text string whilst the dataset fields are working in the number value.
That is why, if you look at the first example, you will see that the user inputs are designated with .text and not .value and String is added to the actual calculation.
I got it to work, but I’m still not sure what is actually happening!
I created a hook on BeforeInsert to do the totaling of the input fields and set the total into a field in the collection.
Backend code:
export function GrantApplications_beforeInsert(item, context) {
//TODO: write your code here...
var rev1 = Number(item.revenueItem1Amount);
var rev2 = Number(item.revenueItem2Amount);
var rev3 = Number(item.revenueItem3Amount);
var rev4 = Number(item.revenueItem4Amount);
var rev5 = Number(item.revenueItem5Amount);
var revA = Number(item.revenueItemAAmount);
var revB = Number(item.revenueItemBAmount);
var revC = Number(item.revenueItemCAmount);
var revD = Number(item.revenueItemDAmount);
var revE = Number(item.revenueItemEAmount);
var revF = Number(item.revenueItemFAmount);
var revG = Number(item.revenueItemGAmount);
var revH = Number(item.revenueItemHAmount);
var revI = Number(item.revenueItemIAmount);
var revTotal = parseFloat(rev1+rev2+rev3+rev4+rev5+revA+revB+revC+revD+revE+revF+revG+revH+revI);
item.revenueItemTotal = revTotal;
return item;
}
Even addning the above to the front end didn’t solve the issue.
When the total is writting with code into $w(‘#inputRevenueItemTotalAmount’).value, it just didn’t get added to the collection field.
Then this line of code probably would have worked as you are inputting a number value using toString which will convert it to a text type string, of which your text box on the page uses and not number value.
