Method Community

Hi All, I've been out of the loop for awhile with Method, but really anxious to learn the new version.  Is there online training available yet?   I don't want to wait until Scaling New Heights to learn it. Thanks! Karen Dellaripa

Jason, I think I was able to do this correctly, after the initial add, I can't get the screen to show both criteria at the same time like you have above, but I think the second part is still there as I have the "remove Where" option, but no "And Where" option.  However, when I run the actions, it is returning the same ...

Hey Jason, Thanks so much for showing me how and where to do the scripts!  I have one little wrinkle to this and I don't know how to write that part - I really need a two part script - The button that I am trying to write actions for does the following: 1 Start Loop through Customer Table 2 Retrieve "Amount" from Charge ...

Hey Jason, The first suggestion won't work #1 because I'm trying to filter on transaction date, not created date, and two, because there is no way to tell it to find transactions BETWEEN two dates in the regular script.  That's been my problem from the start. As far as the second suggestion, as I said originally, I have looked ...

I am trying to retrieve values from a table for a specific date range.  I don't see any way to do this without using an Advanced Script, but I have no idea how to write one or WHERE I go to write it.  I've looked at help articles and googled SQL WHERE, and I kind of see what I need to do, but where in Method do I do it, and what ...

What I am trying to do is sum the amounts from invoices within a date range and enter them in a new field in the customer table called "aaSumofInvoices".  This is what I have done so far and the errors associated with them.   I added a field in the customer table called “aaSumofInvoices”.  On one of my ...

Hi all, When using a Date Picker object, once you choose the date on the screen, does Method consider that date the value in that field?  For example,  If I have a "From" date picker and a "To" date picker, and I choose July 1st 2013 for the From date and July 31, 2013 for the To date.  Then I have a button ...

Thanks Adam, but as I already said, they are REPORT fields, not Method fields, so they do not show up in the fields list as fields that I can calculate with.  If there is a way to calculate on REPORT fields I would love to hear it! To clarify,  what I have done in my report is used 3 label fields to add together three different amount ...

Adam, No, actually I was hoping there was a way to add values in fields on the report together - but it seems like this is not possible.  They are not fields in a Method table/screen.  They are label fields on the report that are summing the amount field from Method.  I want to add 3 "sums" together. Karen

Is there a way to have a calculated field that looks at 3 other fields on the report to calculate the total of those three fields?  For example, I have an Opening balance field, a total Charges field and a total received field.  I want to calculate the ending balance by taking the opening balance, subtracting the amount in the charges ...