Method Community

Hi Method, I'm having trouble getting the "view" button in the estimate grid to populate data into the PDF template. is there a bottun I can copy that will get the record ID, filter for an individual and generate the report into the template. I am pretty sure I am using all the right fields , but non of the data wants to appear.

Hi Method, I am having a few issues with the save buttons on Edit Profile screens. I need to add several fields that are not on the default "ContactsPortal_EditProfile screen. I have most of it working properly. However, (1) the screen creates a new contact, syncs it into QB but doesn't update the original. (2) it does not sync/update ...

I deleted the screen and started over. That fixed the problem. thanks.

Thanks, David, but actually I did understand what you are saying. I know that every database I have used has some way of limiting queries for the purposes of paging through the results. Pagination is logically separate from a set of filtering criteria in that it is an additional criteria on top of the filtering. MySQL does that with the LIMIT ...

Hi gbisaga, I think you misunderstood my response....using a date field was just an example. You can filter by any combination of fields in the table. If it is there you can add it to the where clause with a conditon. So if you had a string field, a numeric field, and a datefield you can build something like. myField1 = ...

Hi Dave, thanks for your response. It's not that I specifically want to use the LIMIT clause, but rather that I want to limit the number of rows that comes back. The result could return tens of thousands of rows, which is a lot of data to process at once. I can't really use a date clause like you suggest because I am syncing with past ...

Thanks!  Will do. April

Hi gbisaga, We don't run MySQL we run SqlServer...so in a word no....since limit is not a part of standard sql. However what you can do to limit data is use the where clause to filter data. For example I might have a table with a date field and only want orders from today onwards. So I might pass in to the where clause something iike ...

Hi, I am trying to call MethodAPISelect_XMLV2 but I don't want all the records because that would be quite a lot. Is there any way I can limit the results I get, similar to a MySQL "limit" clause?

Hi tom, The function behaves the same for both leads and customers so I'm not sure why the user didn't receive an email notification. Does anyone from your organization receive Method emails? If not then I would recommend you check your email server settings/contact your hosting provider. I just created a test opportunity and selected ...