Method Community

 very sorry to keep bugging, but my deadline approaches :)

SQL  So for a customer: Name like '%Dave%' Will give you anyone with "Dave" in their name. FirstName = 'Dave' Will give you all the Dave's, but not the Davea's.   Or for an Activity: DueDateStart > '2012-05-31' Would give you all activities after midnight (UTC time) of May ...

I see I have an option of 'filtering with script' when exporting tables to a file. What sort of script can I use? Is this SQL? Any particular syntax or ANSI version?   Thanks, Blake C

Thank you.. Please let me know if I can be of further assistance

I was able to work through this with MisterBill.  The email addresses that they were trying to register were found elsewhere in the database.

I am having a bit of trouble with the outlook integration. I would like to have the action, "Save and E-mail", provide an option to use outlook e-mail with a PDF attached, instead of using the customer portal. Has anyone completed this? It was my understanding form a tech call that an e-mail can be sent within outlook from Method with ...

yes this is the first and only portal... so example is we have taken 4 different customers that are already in quickbooks with their email address etc. they go to that link, and click register they enter their email address same as the one in quickbooks and then they pick a user name and they get that error.....

@MisterBill Is this the first time you are trying to create a portal for these customers? Can you provide the steps that produce this error? I was not able to reproduce the issue on my side and I need a bit more information of the problem so we can troubleshhot it.  

API'ers. In rare situations where you are pulling a large number of records, please know that we had to put in a 10,000 record limit in place. If you have to pull more than 10k records, please do it in iterations, so: 1. Grab desired records. 2. If record count is less than 10,000, then great, you're done. 3. If record count is ...

@Rolf I was able to reproduce the tab function and it is working as described. If you want it to work differently then may I suggest a workaround. If you add actions to 'lose focus' on the field date, to go to the next field / object, then this will help with the way you like it to function. I will inquire with our developers if this ...