FormView Calculated Field Values

[CharlesParker]

I 've got a list control (with detail view enabled) using a formview control
, editor sets, and editors...

When I am using an editor for a field value (Item price or qty as both use the same number pad editor) I want to update the value for TOTAL.
This is what I came up with when I click the "Done" button in the editor for the quantity.

var _fields = ['total'];
var _vals = ['item_price'*'item_qty'];
{dialog.object}.formViewUpdate('FORMVIEW_1',_fields,_vals);​

I am getting NaN at this point so I know I am doing something, lol just not getting the result I want which would be Quantity * Price

anyone got any advice here for this?
Effectually this is like a calculated field value but for a formview control.


I have already tried so many variations I am mentally numb...lol

[CharlesParker]

Note: Using the display template for the field I can get the correct total (calculation), however on sync it reverts back as though I did not actually alter the formview value for the control, as in it did not get set to dirty

[madtowng]

Hi Charles, I could be off target (sometimes my ignorance shows), but I'm guessing 'item_price' and 'item_qty' are being considered
strings instead of numbers.

[CharlesParker]

Well, I am getting further along. Since the value for total is set in the template as qty * price it always displays correctly, however if I open the editor for total the value there is the original value so if I then enter the correct total in the editor - it saves as expected. So the editor gets the value from the list control rather than the formview control which would be the orginal value even though the formview control shows the calculated correct number. I got beyond the NaN value to correctly display the value as a formatted number.

My guess is that since the value I see displayed isn't really the value of the control - I need to somehow do that after the field template calculates it and displays it. Sort of like a regular textbox control that has a calculated value but it doesn't set the field to dirty since its html being displayed there rather than setting the actual value of the control.

[madtowng]

I haven't used a formview yet, but I would guess if all else fails, you should be able to assign the price and qty values to state variables and do your magic with the state variables.

[dfricke10]

I'm running around in this same circle right now. The template calculated values aren't saving back to the list. Charles, the problem with your original code is the way you did the calculation. You need to do the calculation before you put the field value in the _vals variable._vals is an array.

My issue is, how do I pull the values from the viewbox to DO the calculation. I've got it writing back to the form view, but still working on pulling the values.

[dfricke10]

Got it!!
I'm calculating register totals for my POS app.
Call the formview, grab the values, do the calculations, add the array back. I've got more to add to this, like coins, etc., but this works perfectly. Hope it helps. And yes, it makes the VB dirty and saves it, unlike the template calculation.

var vbObj = {dialog.object}.formViewGetViewBox('FORMVIEW_1');

var one = vbObj.data.ONESTOTAL_O;
var five = vbObj.data.FIVETOTAL_O;
var ten = vbObj.data.TENTOTAL_O;
var twenty = vbObj.data.TWENTYTOTAL_O;
var fifty = vbObj.data.FIFTYTOTAL_O;
var hundred = vbObj.data.HUNDREDTOTAL_O;
var two = vbObj.data.TWOSTOTAL_O;

var calc1 = Number(one) + Number(five) + Number(ten) + Number(twenty) + Number(fifty) + Number(hundred) + Number(two)

var _fields = ['OPENINGBILLSTOTAL'];
var _vals = [calc1];
{dialog.object}.formViewUpdate('FORMVIEW_1',_fields,_vals);​

[CharlesParker]

any chance we can see the form in action? I would like to know more about whats going on in your app to help me understand what your doing...

[dfricke10]

Sure. Here's the code so far.

It's getting the formview object,
getting the formview field values,
calculating the bills and coins,
adding them together,
and putting them into the 3 respective fields.
Both for Opening and Closing.

Test page is at https://www.fostersrestore.com/testregistercount.a5w
You can play with that list entry that shows up. You can't hurt anything. There's 3 ways to enter the values. Eventually this will be a tablet app, so it's optimized for touch screen.

var vbObj = {dialog.object}.formViewGetViewBox('FORMVIEW_1');

var oneO = vbObj.data.ONESTOTAL_O;
var fiveO = vbObj.data.FIVETOTAL_O;
var tenO = vbObj.data.TENTOTAL_O;
var twentyO = vbObj.data.TWENTYTOTAL_O;
var fiftyO = vbObj.data.FIFTYTOTAL_O;
var hundredO = vbObj.data.HUNDREDTOTAL_O;
var twoO = vbObj.data.TWOSTOTAL_O;

var quarterO = vbObj.data.QUARTERSTOTAL_O;
var dimeO = vbObj.data.DIMESTOTAL_O;
var nickelO = vbObj.data.NICKELSTOTAL_O;
var pennyO = vbObj.data.PENNIESTOTAL_O;
var dollarcoinO = vbObj.data.DOLLARCOINSTOTAL_O;

var calc1open = Number(oneO) + Number(fiveO) + Number(tenO) + Number(twentyO) + Number(fiftyO) + Number(hundredO) + Number(twoO)
var calc2open = Number(quarterO) + Number(dimeO) + Number(nickelO) + Number(pennyO) + Number(dollarcoinO)
var calcTotalopen = calc1open + calc2open

var _fields = ['OPENINGBILLSTOTAL','OPENINGCHANGETOTAL','OPENINGREGISTERTOTAL'];
var _vals = [calc1open, calc2open, calcTotalopen];
{dialog.object}.formViewUpdate('FORMVIEW_1',_fields,_vals);


var oneC = vbObj.data.ONESTOTAL_C;
var fiveC = vbObj.data.FIVETOTAL_C;
var tenC = vbObj.data.TENTOTAL_C;
var twentyC = vbObj.data.TWENTYTOTAL_C;
var fiftyC = vbObj.data.FIFTYTOTAL_C;
var hundredC = vbObj.data.HUNDREDTOTAL_C;
var twoC = vbObj.data.TWOSTOTAL_C;

var quarterC = vbObj.data.QUARTERSTOTAL_C;
var dimeC = vbObj.data.DIMESTOTAL_C;
var nickelC = vbObj.data.NICKELSTOTAL_C;
var pennyC = vbObj.data.PENNIESTOTAL_C;
var dollarcoinC = vbObj.data.DOLLARCOINSTOTAL_C;

var calc1close = Number(oneC) + Number(fiveC) + Number(tenC) + Number(twentyC) + Number(fiftyC) + Number(hundredC) + Number(twoC)
var calc2close = Number(quarterC) + Number(dimeC) + Number(nickelC) + Number(pennyC) + Number(dollarcoinC)
var calcTotalclose = calc1close + calc2close

var _fields = ['CLOSINGBILLSTOTAL','CLOSINGCHANGETOTAL','CLOSINGREGISTERTOTAL'];
var _vals = [calc1close, calc2close, calcTotalclose];
{dialog.object}.formViewUpdate('FORMVIEW_1',_fields,_vals);​

[dfricke10]

And the calculations are on the 'Hide editor' of the editor that edits the number fields. It can also work on the Editor Set on the 'Hide Javascript'.