Method Community

Hey Jason, I have not tried the ListBuilder route, but if the final outcome is that you are trying to retrieve the list of Emails of the Customers that have payments against an invoice, this is the solution I put together: ~ quick little gif of the screen in action: https://streamable.com/nln8 (1) It looks like you already ...

Well that cleared the error, and populated the TxnDate field in the grid. New Problem - every date is the same - 10/26/2015 12:00:00pm. Also, when you say have the 'Customer' Field on the grid, there is no field called 'customer' in the listbuilder table? Am I missing something here? Ted

Hey, You can try, setting the Grouping Interval to Month and changing the Value Format to "d" -  You can read more about formatting HERE. -- Mortaza

Hey Ted, I modified the code and this should load for you, give it a try and let me know if it does. SELECT Max(viewaccInvoice.TxnDate) FROM viewaccInvoice WHERE viewaccInvoice.Customer = Customer *note make sure you have 'Customer' field on your Grid listed. -- Mortaza

Hey Jake, Troubleshooting this issue over the Forums will be tough especially since it has to do with a lot of sensitive data; I have created a Support case for you and a member from Support should be in tough ASAP.  They will be able to connect over a remote screen share and work with you together to find a solution. For ...

Hi Savanna, Since the User is related to records in the Audit you are unable to delete them. Making them Inactive will decrease the license count and also restrict the User accessing the account.  You can do that by:  - Uncheck both options on Step 1 of their User settings under 'Customize > Users' -- Mortaza

Hi Mortaza, Any thoughts on the above? I got rid of the error by removing a Get Sum commmand from the advanced screen properties. I still don't get any results in my grid, so I replaced it for now. I put the SQL in the advanced section for the TxnDate field. Ted

I have a project where I'm developing a quote request form for a website. I'm trying to pull a description from a field in another table and display it in a text box. I'm having difficulty getting the HTML to render correctly. When I put the data in a Text object, I get these results.  When I put the data in a Text Input ...

Hello- We are having trouble getting the "Receive Payments" screen to work properly When we try to accept a payment through Method, rather than the credit card fields that were shown for the first day after set up, we get a single box for "Card Verificiation Code" and no other fields (see below) We have Method setup ...

I have had an employee leave and I no longer wish to have them or their account showing up. I have changed the settings to maek it show the account couldnt sign in, but it is still active. When I try to delete it i recieve a pop up with this message "Cannot delete the user as records are logged in the audit trail. Please set this user to ...