Method Community

This is what I did between my post and your response. My problem now is that I need to use an advanced SQL script. I've watched the webinar and I think I get how to assign the script to an action result and then use the script in the WHERE part of the Retrieve Value action. My problem now is doing the script (I'm not experienced ...

Hi Brett - that would be the right approach to this. Thanks for updating the post.

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