Method:Classic General Q&A

Re: Work Order Calculations based on Total Amount

Method_Morty — Mon, 05 Oct 2015 18:24:45 GMT

Hey Don,

Thanks for the follow-up! Ah that does make sense now, those fields do not populate up until after the SAVE function.

Happy you got it to work.

-- Mortaza

Re: Work Order Calculations based on Total Amount

InstaDRY — Mon, 05 Oct 2015 17:06:42 GMT

That didn't work, but I just tried the following and it did:

From the SAVE function I added "Get Sum" from the grid and then did an action result to enter value into screen. It populates everything once I hit save and works just fine.

Re: Work Order Calculations based on Total Amount

Method_Morty — Mon, 05 Oct 2015 16:20:45 GMT

Hey Don,

If I understand correctly you want to do calculations based off the 'Total Amount' and display that calculation in a separate field on screen?

You can start by adding a TextInput object to the screen and instead of using the TextInput events add the actions to OnScreenLoad events.

It would look like:

OnScreenLoad ~> Retrieve value for Total Amount ~> Use that to complete calculations ~> Update the TextInput object with the final calculations.

Give that a shot and let me know if you need me to elaborate on any of the steps.

-- Mortaza

Re: Work Order Calculations based on Total Amount

InstaDRY — Sun, 04 Oct 2015 23:13:46 GMT

I tried several functions with that, including lose focus/gain focus. It doesn't seem to help.

Re: Work Order Calculations based on Total Amount

Method_Morty — Fri, 25 Sep 2015 14:06:16 GMT

Hey Don,

Instead of adding a Field from the corresponding Table to your screen, add an Object field.

Let me know if that helps, if not we can think of an alternative together.

-- Mortaza

Work Order Calculations based on Total Amount

InstaDRY — Thu, 24 Sep 2015 21:06:11 GMT

I'm trying to do some calculations off of the total amount of a work order within the work order. I added the total amount field, but that screws up my work order list calculations. I don't want to lose that, since it's a great visual aid when looking at the day's workload. However, need to find a way to add a field showing the work order total within the workorder to work out some calculations. What is the best way to add the field without disturbing the other work order screens?