Method Community

Aloha Everyone, I have had a problem using report writer when trying to access data.  let me give you an example.  I have a Lesson Plan that has mutliple activities.  I want to run a report that shows all the activies for a lesson plan.   This I can do without much problem.   The difficulty comes when I then want to also ...

Adam Thanks.   I was hoping this was the casae.   Only one small problem.   If instead of appending the item onto an action ressult like you did if you try to use the record to retrieved information from the record and create a new record in a new table you will fine that only the distinct field is able to be found ...

This is a screen shot of the Start Loop thru a Table action.   There is an optional value of "Only Distinct Values".   I think I know what this might do, but don't seem to be able to get it to work for me.   Can you provide a couple of examples I can look at and maybe an explanation of how this can be used.  

Hello Everyone, I have a number of highly customized screens which have worked exceptionally well for us.  The biggest problem we have is with the limitations of the report writer.  Let me provide an example.  We have a Class Curriculum system that has three tables.   A list of activities, a list of materials used in ...

Aloha, I am trying to add a filter to a Generate a Report command. I have completed the Generate a Report command including a filter.  Report = Refferal Detail Report   Tables of Report = RefferalsLinked   Fields in Table = ServedDate Condition Statement = Greater than or Equal to From =  Value From Screen   ...

Ben, Yes we are syncing with QuickBooks Desktop. No I have not been able to recreate the problem.  We created the invoice originally in Method.   We modify invoices only in Quickbooks.   This invoice was created and then the discount line was added at a later time. The quantity is not input for the discount ...

Ben, Thanks for the great example.  It will help as I work with it further.  Understand about making sure the names and parameters are exact. Stuart

No problem.   I have not found any patern to the problem.  At first I thought it might be when a line was added to an invoice in Quickbooks, but I have since found that seems to work okay.   It is possible the line was added while the sync was not on, but I would think that is suppose to update when the sync comes on ...

I am trying to use the Web Service Action and am hoping someone can point me to a place in the system where it is used so I can look at it.   The documentation is limited in understanding the formating and use of parameters and how they are ultimately sent to the URL provided.  A couple of samples will go a long way to understanding ...

Have an invoice that shows up in Method as zero balance which is correct but only shows two of the three line items.  The third line item is missing which is a discount line that zero's out the invoices other two lines. Everything is correct on the Quickbooks side.  The invoice balance is zero and the three line items show up. Any ...