Method Community

Dave, I have tried a data range which does return data.  When I use "<tem:strWhereClause>(TxnDate >= '2013-09-23')</tem:strWhereClause>", many record are retrieved. However, when I try to limit the search to one week with "<tem:strWhereClause>(TxnDate >= '2013-09-23') AND (TxnDate <= ...

Thanks for your response Dave. I am hoping to use Google App Engine with Python. I am using the urllib.urlencode() function. In my dictionary I have {arrInsertFieldArray : ['name', 'assignedTo']}. I pass the dictionary to urlencode() and send the resulting string to Method, but I am not ...

Hi nsmith_piano, It can be done....but without know what language you are using, I'm not sure where to point you. I'm gonna advise in this case you google 'HTTP Post an array?'. That should help you find the solution pretty quick.   Dave    

Hi viret56, 2 things come to mind off the top of my head. 1. Does your data actually have records in the date range? 2. Try changing your dates to be YYYY-Mon-DD format,...namely TxnDate >= '2013-Sep-30' AND TxnDate <= '2013-oct-06' to avoid an ambiguity error and your enddate being read as jun 10, 2013 Dave

Hi VLocke, Starting with a fresh FieldService_AddEditWorkOrder Screen, first add the field "Contact Phone Number" to your screen.  Then, edit the Customer field, and add a new "Retrieve Value from Table " action.  Here you will be adding the Phone Number stored in the Customer table, to the Contact Phone ...

I tried this and I couldn't get it to work. Can you give me a bit of detail on the step by step?

Hi Adam,     Here is what I'm trying to do: County subscription for phone leads is our main product. I already have list of counties imported on a custom screen. Those counties could be used in 3 places: 1. Lead could be interested in counties (more then one) 2. Customers can own counties 3. We also have backorder list ...

Hi JWS, There are a few actions needed to do this but it isn't very difficult.  You want to instert a record into the SalesReceiptLine table for your default.   First need to get the values from the item you want as the default using a Retrieve Value from Table action.  The Item and Rate fields are required for the ...

I have written a successful MethodAPISelect_XMLV2 query using  "<tem:strWhereClause>(TxnDate >= '2013-09-30')</tem:strWhereClause>". But when I use "<tem:strWhereClause>(TxnDate >= '2013-09-30' AND TxnDate <= '2013-10-06')</tem:strWhereClause>" instead, the cURL ...

Andrew, Glad to hear you got it working! Let me know if you have any more trouble, I would be happy to help!  Jason