Method Community

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

We here in South Africa canot use any of the Gateways in Method. Why not add a South african Payment gateway so that we can use this service? Please let me know how to add a non Method gateway for the time being.  Thank you 

Update: I have added a show message to the screen load actions to confirm that the shared results are being retrieved. They are apart from the document record ID, that is still blank. However, none of the values are being entered onto the screen. All of the conditional statements on the load action are being met.

Update: I must have had something wrong in the HTML first time round as this is now working.