Application Studio Calculation event widget

[maxtin (Martin)]

Hi, kind of new to Application Studio and would like to use the calculation widget for one of my event. However, seems the Initial Value and all Operands I try to add are treated as Text (ex: 1+2=12). Any way to force them as integer in the syntax? My test here uses hardcode values for testing but seems Im getting the same if im using numerical fields from my view. Using 2022.2.29

thanks,

[J_Lav1 (James Laviano)]

Have you tried wrapping your number in {} e.g. {1} ?

I know early versions of Kinetic can seem to revert this back to just 1 after running, idk why it does that

[J_Lav1 (James Laviano)]

After doing a bit of digging it does seem to be a version issue, seems to be working in 2024.2 but 2024.1 and below have these exact issues where operand is treated as a string instead of a floating point.

Sum Field for Job Receipt to Inventory

OH… did you enter a quantity for the transaction in the form? That could be why you’re not seeing a value in the Costs tab. Let’s walk through debugging and you can compare yours to mine. This could be a nice example of using the debugger for planning events… in this case, it’ll help determine the best TRIGGER to use for our event. Keep in mind the TRIGGER I initially used was After - ColumnChanged_PartTran_ActTranQty Here’s a post from Expert’s Corner that details how the debugger works, b…

Event Calculation Help

Good Morning! I’m looking to do a grand total field that just sums up values from other fields below is what i have… though its not working am i doing this wrong? Below SS of my fields… the Grand Total is what I’m wanting the event to populate. [image] Here is the event set to fire after update… i think this is the one i want to be using? [image] Here is what the Operations look like… one for each of the 5 fields. [image] Any help is appreciated!

If {} does not work I’m afraid there may be no solution to get the event to work, perhaps coding a function as a data directive may be a good workaround?

[maxtin (Martin)]

Thanks for the digging James. Seems that {} wont do it unfortunately.

Any other way of updating a view column with a formula somehow? All the other workarounds I find, seem we need to click Save and then do the calculating. I would like to calculate and set the field before that.

thanks,

[GabeFranco (Gabriel Franco)]

row-update lets you use expressions to do calculations directly, target the view column, for the expression do your math. something like ({view.columna} * {view.columnb}) + 5

[maxtin (Martin)]

Thanks!! I misread the documentation and thought it row-update was committing to DB. I think this the best workaround for now.