Method Community

I can't seem to figure out how to tell it to retrieve the "LAST" record.  I've tried it several ways but there is nothing to point at to match the criteria. In the "From table ____ where ____ is equal to _____"  I'm not sure how to tell it to look at the last record ID and retrieve the CALL# from that ...

I was also wondering if there is a way to use SQL outside of the Grid - either at the screen level or directly in Method Report Designer. Thanks!!

 Hi Chad, I was not aware that Method did not store the info. and have seen the data passed back to method in the format above.  That is not the issue in this situation, however, as the # was stored in QB.  I did just recently update it in QB though and actually saved and went back into QB to make sure it updated before I threw the ...

[quote user="wmousseau"]lost their credit card numbers[/quote] When you say lost is there no information in the field?  By default only QuickBooks can store this information - if you enter this field into Method, QuickBooks with store it and send us back xxxxxxx000 instead of the actual number for secuirty.  There should be no ...

Can you please tell me what type of SQL code Method is based on (i.e. Sybase, MS, Oracle, etc.)?

Using Customer Jobs in QuickBooks it is a nice way to track multiple jobs for one customer.  QuickBooks also provides various reports to help analyze the statistics and profitability of a particular job.  We notice that if we use Customer Jobs in QB, for instance a planting job for Customer Smith and a paving job for Customer ...

  @jnairn We do not recommend that you keep Credit Cards information in Method. Yes we make all possible measures available for you (https - secure website access, encryption and etc) but it will be ultimately your responsibly if you do decide to keep this type of information in your Method account. There are a variety of options for ...

One of the Show Message Action options is "Provide Yes/No option to user?  'Ok' assigns True.  'Cancel' assigns False.".  When the message window appears, the two buttons are 'Ok' and 'Cancel'. Would it be difficult for the Method team to add the ability to change the captions of those two ...

Thanks, Ted. Is this something that you can do? If so, what is your charge?  

To change the stock timing on either the Activity Calendar or your Field Service Calendar follow these steps: Click Customize > Screens Find your Calendar (CRM_ActivityCalendar or FieldService_Calendar) and click copy On step 1 select copy from This Account click next On step 2 rename your screen and click next On step 3 select Replace ...