Method Community

Thanks Russell, When you say the custom looping HTML for the email body goes into an Action Result, where would that actually be in Method?  On a button or a screen or the HTML code of an email template?  Or somewhere else?  I am not asking you about the custom code itself, but WHERE IN METHOD the custom code would go to ...

Hi Robert, The Report Desinger can only use information stored in tables attached to the report being generated. In order to acheive what you are asking, you would need to write the "where script" into a field in one of the associated tables (Update Field in Table action). You would have to build the text for ...

AND IsManuallyClosed = 0  does it.   

Hi Kurt, Glad you figured it out. I'll reply to your post in case there are other users who want to accomplish this as well. Like many things in Method there are many ways to acheive this, here's what I did. To start, I strongly recommend making a copy of the CRM_CaseList_withActivities report, so you can revert to the ...

How do I print the "where script" on the report?  I need to know the "filter" criteria used to generate a report.  Thanks. 

Hi M Mehr, Greetings from Toronto! Method has the Mail Merge feature (http://www.methodintegration.com/method/kb.aspx?folder=methodcrm&article=Mail-merge&id=302), however this only replaces placeholders with a single field, rather than adding multiple items which you are trying to achieve. Generating an email with a variable number of ...

Hi Robert, You should use the syntax [IsManuallyClosed] == False. The Condition Editor can help you with the syntax, for example in this case I clicked Fields > [IsManuallyClosed], then the Equals symbol (which added ==), and then Constants > False. Also, I believe you want to filter on the line items rather than the sales order? The ...

I did what you said.  I get this error message when i do the case table. No error message when i did the activity table: The table was regenerated, but the following field(s) were invalid and were skipped. You may consider deleting the field(s), or regenerating the table related to the field(s): ContactsSalesRep  John M

Nevermind - I figured it out...

In report designer, using the "CRM_CaseList_withActivities" report. I was wondering if there was a way to filter the activites so that it only shows the last activity instead of all the activities. Kurt