Method Community

I figured it out.  To use a YesNo (binary) column in the Advanced SQL Override, you can use:            (CASE WHEN IsClosedBySelfService = 1 THEN 'true text, ' ELSE 'false text' END)  Issue resolved....  Thanks.

Hello Robert.Cowart, I understand that by adding the column is not serving your purpose. Can you please provide me more detail on what are you trying to achieve here, that will help me to guide you in the right direction. -Inder

Hello Ivana, I am glad your issue is resolved.  Have a great day! -Inder

In the Advanced SQL Override of AssignedTo field of the grid in CaseList, I need to add a line that indicates a message if IsClosedBySelfService = 'Yes'.  I tried adding + CASE WHEN viewCases.IsClosedBySelfService = 'Yes' THEN '<br /><b>Self Closed</b>' ELSE '' END but that causes ...

Figured it out, its vbLf

Does someone know of a way to trigger a "New Line" in the Notes field inside QuickBooks. I tried back tracing this by entering a string with New Line in QuickBooks and syncing it back to method. It seems that the API returns it as one long string without any chars signifying the newline.  For instance, if I enter this in the Notes ...

Please disregard my question... I found out that there is a Print button (instead of Print Privew) that allows viewing and saving the Invoice WITH the Service Date! Thanks, I.

I wasn't sure where to post this but I think this must be a data issue. We've created an event system using Method and have a table dedicated to creating timelines for events that are driven by a date/time field. We are having an odd problem where reports and the API return the correct value for some records and others return a time 1 hour ...

Hello, I turned several Work Orders in to Invoices. When I click on the Print Preview button of the Invoice, I get a preview of the invoice in pdf format; however, the Service Date is not included on the Invoice... I need to get it included. Could you please share with me what needs to be done to get the Service Date added? Thank you! ...

Hello, Sorry for the delay in geting back to you. I will have to investigate further to provide you with a definitive solution. Noel