Here’s my original post (which may have been too high-level to describe the problem fully). [image] Kinetic Application Studio Best Practices: Am I doing this right? Kinetic ERP I’m still a noob when it comes to Kinetic Application Studio. My request here is to review my …

That’s easy enough. Make your event look like this: DataTable - ColumnChanged: JobHead.Character01 KineticFunction: ValidateLineChange Condition: {actionResult.LineChangeIsValid} Condition is false: 4a. Throw Info Message that they can’t pick that line 4b. After info message: row-update JobHead.…

[image] devguy: So, modified fields in the buffer had not yet been written to the database, and the JobOper and JobOpDtl records had been updated (behind-the-scenes), but aren’t reflected in the UI. This is easy enough to work around. In the UI, I would call an event when they change the line…

[image] kve: Then after the function runs (on success), just call a refresh UI. That should get the UI to update the changes. I tried that. But doing a Refresh refreshes not only JobOper and JobOpDtl (which is what I want), but it also refreshes JobHead from the database. But JobHead had chan…

First, thank you (again) for taking the time to share with me. I will see if I can do what you described. It seems right to me. I’ll reply here when I have given it a go. Thank you!

I have something similar on CustShipEntry. It’s not as involved. Basically a button that makes an API Call out to a carrier service to get the costs. It calls Update (saves any dirty values), make API call, returns the values > If there is a customer cost, call another function to add a ShipMisc lin…

[image] klincecum: Kevins are best You’re right on the Mark there.

I’ve also faced buffer vs database sync issues in Kinetic—updating the UI buffer first, then committing changes, made my logic much more reliable. Modular validation routines (based on job or PartNum) help keep things manageable during multi-record updates. Anyone else found good ways to batch these…

[image] kve: DataTable - ColumnChanged: JobHead.Character01 KineticFunction: ValidateLineChange Condition: {actionResult.LineChangeIsValid} Condition is false: 4a. Throw Info Message that they can’t pick that line 4b. After info message: row-update JobHead.Character01 to original value Condit…

[image] devguy: And if I use ColumnChanged, how do I access the value that it changed from? Do I read it from the DB (which I can do)? You could set a separate event on ColumnChanging, and do a row-update to set TransView.OldLine or something to the original value, and then use ColumnChanged …

Just to follow-up here. I’ve not had the time to work through the issues until recently, but now it’s all working! So again, I want to thank everyone (especially the Kevin’s) for the help! This is what I ended up with: [image] I used ColumnChanging trigger instead of ColumnChanged, for a number…

Kinetic Application Studio Best Practices for conditional complex logic

Kinetic ERP

jbooker (Josh Booker) November 3, 2025, 9:58pm 13

Thanks for sharing.

FWIW, In case you do want to compare old and new values in your events client-side, use these expressions which eval in actions within the column change event context.