Method Community

In our database Title is field name for Mr/Mrs etc and Suffix is what goes after the name, ie PHD, MD etc. I renamed Title to Salutation. Can you tell me why I can no longer import anymore, I choose not to import suffix but when i click import it now tries to import the suffix field as Fullname giving me the error you see in 3rd picture I linked ...

Hi Ben B, I'm assuming you're importing records into the Customer table correct? If you store Mr./Mrs/Miss/etc in your suffix column then you should import this data into the Salutation field. The Suffix field isn't utilized on any screens in Method and I believe it exists in the table as a temporary placeholder when syncing records ...

Hi matlow99, What exactly are you trying to accomplish here? Are you just looking to have a 'View' link on your Existing Estimates grid that brings up the PDF template for that particular estimate? If that's the case then why not just utilize the Print Preview button on the screen as it already does this. - Ashur

So am importing our database into method. Have some fields in our database that are the same field name as methods, one of them being suffix. When I go to import our table and choose to map my suffix field to existing field, suffix is not in the drop down menu to choose from field names. Am I missing something here? I checked to make sure suffix ...

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 ...