Has anybody figured out to do this? I have gotten as far as adding a field to the OrderDtl dataview in Order Entry, and adding the field to lines grid, but I am trying to figure out the step where it gets populated with the result of a calculation. The kinetic user guide says it can be done but th…

Change your row update to this: {matches.PartUnitWeight_c} * {matches.SellingQuantity}

Seems fine to me. [OrderCol] Tested on 2022.2.13–are you still on 2021.2? Although, if support is testing it, they should be on the latest… :thinking: I guess it’s not an apples-to-apples test as my calculated field is using SellingQuantity * DspUnitPrice since I don’t have the UD field you’re u…

I’m clicking the lines link in the left nav that brings up the the lines page, not scrolling down to the liens grid. Don’t know if that makes a difference. 2022.2.14.

Huh. Well there ya go! lol… [image]

Well, let’s not get carried away. :stuck_out_tongue:

[image] aosemwengie1: s that the dataset_hasChanges event that fires when you click into the grid is now evaluating to true instead of false. I wonder if there is a way around this? So, setting %dataset.SalesOrder.hasChanges% = false is, uh… NOT a good idea. Hahaha It just totally breaks the…

Whelp. My layer is fuuuucked. [Idris Elba Table Flip GIF]

Lol, not a big deal. This was just a fluff layer for testing.

Adding a calculated field to a kinetic dataview?

Kinetic ERP

hmwillett (Hannah Willett) March 31, 2023, 4:21pm 28

Got it!!

Season 3 Summer GIF by Rick and Morty

How To: Adding Columns to Existing Kinetic Grid

Topic		Replies	Views
Kinetic Add Column to dataview Kinetic ERP	19	5597	May 3, 2023
How To: Adding Columns to Existing Kinetic Grid Experts' Corner kinetic , application-studio	144	52011	February 12, 2025
Kinetic and calculated UltraGrids Kinetic ERP customization	10	2791	February 22, 2023
Problem with Updating the data in a dataview with events in Kinetic Kinetic ERP	5	2917	October 5, 2023
Application Studio Get Selected Value from Grid Kinetic ERP	5	8419	December 20, 2021

Adding a calculated field to a kinetic dataview?

Related topics