Method Community

I found SQL Override examples on the forum which allow me to change color/font of cells of a grid based on a condition.  It works great.  However, in the example below, the condition is against GETUTCDATE().  I would like the condition to be against a date field on the screen called 8DaysAway.  How do I reference screen fields ...

Hello Method! We are still having sync issues with our accounts table. Also we are having problems with our Received Payments not syncing with QB. Any reason why this is happening? Thanks

Hi Rick, Glad to hear you've figured this out! Adam

Hi Sixtel, Understand your points and pain. Names is prob. the most difficult part and most important part to get. It really helps to understand how QB uses and then its easier to translate to Method. It is an art at times.  As partners, we all have struggled a bit with this area, so don't feel bad. But I know, it would be ...

Is there an issue with chart objects?I  tried adding another chart to a screen that already had some existing charts. Could not get it to work. So I copied an existing chart and even switched the table it was pulling from and it worked fine.

Lynda, How do I get the new UI? Thanks, Chris

I can publish a solution to this: tables in custom SQL quieries must be appended with view or viewacc. view is for tables that exist only in method and viewacc is for tables that came from QB. See: https://www.method.me/cs/forums/p/5538/21043.aspx The query i ran was: SELECT TagList FROM viewContacts WHERE viewContacts.EntityRecordID = ...

Hi! I understand that there are probably reasons why this is not made available, but, it would be GREATLY beneficial to me if there was a stock database diagram I could look at that detailed the Method database.  While customizing I notice that I spend half of my time wading through tables and exporting data to try to figure out how ...

I'm getting an error with previewing a report that states that "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index." Is this something you can help me with? Thanks!

Thank you, Audisho! I really appreciate your help!