Method Community

Hello, and welcome to this week’s Method blog! My name is Errol and today I want to tell you about my next video series: Customers! Look! I'm pensive! You know what was difficult? Explaining Contacts. Jason tells me that this is a common question: what is the difference between Customers and Contacts? I explained this in the ...

Jason, Thanks. I have searched on your site....and don't understand....do i need to do something within my account to get the latest and greatest versions of method if i have quickbooks online, or does it just get uploaded and is seamless to me?

Jason, when setting up the Discount item, which "account" would I use?   Accounts Receivable?  I plan on using this discount item on invoices and estimates.   Thanks

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 ...

Hi Karen,  There is an option to use an advanced script right in the Retrieve Value from Table action. You might also be able to do this with a regular script by using the Where Field. See my screenshot below.  Also, here is an article with some simple SQL scripts from our Help Center. Included is some options for date ...

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 ...

Hi Chris, This has been fixed in the August version of Method.  Jason

Hi Nick, This has been fixed in the August version of Method. Thanks for bringing this issue to our attention.  Jason

Hi Karen, Sorry for the delay.  I actually ran into the same issue you had with the date range. There is however an easy fix for this.  Instead of using a "value from screen", I would first assign the date values to Action Results and then use those action results in the Where clause.  I will create a ticket for ...

Hi Mike, You are correct, when using the "Loop through Table" action, you do not have access to any other SQL commands other than the "Where" clause, you do not have access to the Advanced Script features that "Retreive value From Table" can offer. -Ben