Method Community

That worked. You are fantastic- thank you!

Hey, The Record_ID constraint uniquely identifies each record in a table. Record_ID must contain UNIQUE values, which Method handles for you. - Mortaza

Thanks. When I created the table for the dropdown list, why did it automatically create an integer field called Record_ID?

we are currently using an Exchange 2010 server

Hey Ted, You will just need to change Invoice to SalesReceipt. For the TxnDate example: select Max(viewaccSalesReceipt.TxnDate) FROM viewaccSalesReceipt WHERE viewaccSalesReceipt.Customer = viewContacts.Entity - Mortaza

Hey, Depending on how your mail server is setup, we do have new IPs we use. If before the move you had to whitelist a list of IPs you will need to edit those IPs with the new ones we have. Which mail server are you currently using? That will help me narrow the error down. - Mortaza

Hey Mahlon, It seems to happen when you resize the window when you are in 'Fullscreen Mode' I have created a ticket for our developers to take a look, I'll follow up here. - Mortaza

Hi, My problem now is that it is searching for the invoives with SQL, so how do I get it to look for Sales Reciepts instead. (complete SQL novice here!) Ted

Hello Method! We received an email with this error this morning. " Email Send Failure Alert The following email failed to send. Method has tried to send this email via your specified mail server a total of 5 times, approximately 5 minutes apart, before giving up." " Response from Mail Server Failure sending ...

Hey Ted, Thanks for the follow up, I'm glad we found the root issue :). - Mortaza