Method Community

Hi Mike, If I understand correctly I'm going to offer a much better, more efficient and simple approach to this. Rather than having nested loops (loops within loops) you can use another approach. 1. Loop through the customer table OR loop through grid for only checked rows 2. Retrieve Value From table Retrieve from Activity ...

How can I add the PO field to the "Edit Work Order" and have it transfer to the correct Invoice field when converted to an invoice.?

I know, I was just trying to provide a correction to Michael's post so that no one else gets confused. I don't know of anybody that would want to enter their time in total minutes, so I just have my own text fields for hours and mintutes and have actions to process this into the DurationMinutes field.

Hi Brett, Even though you can add the DurationHours Field to your screen, however this is a system Read-only field, so you will not be able to change it.  You will have to use the DurationMinutes field instead. - Ben

I want to have a button (stand-alone, not on any screen) that when I press it, it does the following: For every Record ID in the customer table Loop through the activity table and add up the duration hours for each Record ID in the customer table for a predefined time period Populate that duration number into the customer table ...

thank you ben. details have been sent.

FYI, I added the DurationHours field to the screen, but it won't let you input anything, even though read-only is NOT checked.

For anyone following this, we took this issue off the forums and resolved it for CHSMA. - Adam

Hi James, Would you be able to email me privately with the CompanyAccount name you enter in your Method Login.  I would have to take a look in your account to see what is happening, from you described above you should be able to see the "Create" button, so there might be something else wrong here.  If you do want us to take a ...

Hi David, One way you can do this is to add a Subtotal line item before the Discount line item. The Discount item will then discount the subtotal. See my screenshot below.  Let me know if this works for you! Jason