Method Community

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

MikeB, Glad to hear its working.  What you changed it to makes much more sense, since you're then comparing the recordID to the current row in the loop.   - Adam

One question on that: When linking to the document, will the URL be for the document itself or for the record in the Documents table. Would I be able to launch the document and print it from the Activity detail page, or would I need to go into the Document record detail page for that document and launch it and print it from there?

It works now, but I'm not sure why. It tried it with single customers, and with accounts that had the same parent name, and those worked. I noticed that the "Where" option allowed me to say: Where RecordID (in the customer table) = Value From Screen RecordID (in the Customer table). Strange how entering the same field on both ...