Method Community

Hello, I'm experimenting with the API and wanted to just browse some of the data in some of tables. To put it more simply, I'd like to run the equivalent of this SQL query over the API. Select Name from Customers limit 5; It looks like I should be using the MethodAPISelect_XML to accomplish this. In the documentation I see some ...

Paul. Thanks for the response. I think I see what youre saying, but I dont know if it applies here. PHP arrays natively assign indexing without construction arguments (i.e. default sizing), so when I say $fieldArray = array('Name'); I've just created an arrray with one element indexed at position 0. So echo $fieldArray[0]; would ...

Hey Joe, If you open the table "customer" and add a field named "Fullname" to the table, that field's name is set as Fullname. If you change the caption of that field to "Name in Full" the field name is still "Fullname". On the other hand, if you drag the text box onto the screen from the objects list, ...

 Hi Jim, 1. The “flickering” is something that you would typically see if there are many transactions that haven’t been synched yet, or more likely when there is a Full Sync going.  The Full Sync should only happen once a day, in the middle of the night, so it shouldn’t be doing this.  However, if there ...

Paul - before I get the dev team to look into this, can you just verify one thing for me? I've seen this message before, and I think every time I've seen it, the reason was that the last index in the array was not used. For example, the array was a 0-based index, and was defined as myarray(10)  when there are 10 values you want to ...

Paul, Thanks for your quick response. So far, I'm finding the API pretty nice to work with, but I haven't quite gotten my customer insert test to work yet. Here's a block of my code in PHP. Please note that I noticed all of your code samples were in VB and ASP.NET, so once my project is complete, I'd be glad to post my code so ...

Hi Joe, Thanks for pointing this out, when I tried the hide/show action the caption stayed on screen but the text box went away.  I'll look into this and get back to you.

Hey Phillip, I've looked into this and I found out that this is a QuickBooks report. Method cannot edit this date format. I would check to see if you can set date preferences in QuickBooks, this may allow you to change the date format. If the report was made from the Method Report Designer, we could format that text. Sorry I ...

Hi. It seems when customizing a page with new fields/objects, these new f/o's are identified in properties and in dropdowns by only their captions. This makes it very difficult to tell the difference between: 1) an object and field both named "myName" 2) multiple objects named "myName" example: Company's Bill To ...

 Hey Phillip, Currently in Method, a pay bills screen does not exist. A screen could be built to do this, but it would be a decent sized customization. The tables you should use to create this screen are; BillPaymentCheck, BillPaymentCheckAppliedToTxn Writing Checks is not the same thing as paying bills in QuickBooks.  In QuickBooks ...