Method Community

 Good morning,   I have  some questions and I was wondering if anyone might be able to help me.   We currently have a web application which is communicating with QB through the Web Connector. We are looking to replace the Web Connector with the MethodAPI.   These are the operations we are currently doing through our web ...

The same is not true for the Quantity and Rate fields (there's no background processing) in the line item grids but you shouldn't remove those fields.  If anything you should hide those columns instead of removing them. Also keep in mind that if you have a user working inside QB, and they change values for those fields, it would only ...

mrjobboy, [quote user="mrjonboy"]I have an Employment table that I originally created with the field 'Age 16'. I have since changed that to 'US Legal'. it is a simple check box for yes or no (actually a radio button on the website that provides the value into Method). [/quote] Can you go to customize>>>tables / ...

Thanks for the response Chad. Is the same true of the Quantity and Rate fields in the line item grids? By default, if an item isn't selected the Quantity is set to 1 and the Rate is set to $0.00. I'm thinking that I could remove those fields from the grid display, add new "Qty2" and "Rate2" fields to the line item ...

 Hi CF_Pro, Good suggestion. I have created an internal ticket (#3396) and will keep you updated on its progress Dave

 Hi CDS_Josh, How are you formatting the dates? Try formatting them as 'yyyy/MMM/dd' or 'yyyy/MMM/dd hh:mm:ss tt' So for example 'April 12, 2012' would be formatted as '2012/Apr/12' And 'April 12, 2012, 10am' would be formatted as '2012/Apr/12 10:00:00 AM' Dave

[quote user="jnoneiliv1"]Do you think it's just a coincidence that you are using terms like "Where clause", "Select", "Distinct", etc.?[/quote] No coincidence and all those terms are all applicable - Distinct is the only one I always try to refer to as unique outside SQL statements.  [quote ...

Thank you for the replies. I have an Employment table that I originally created with the field 'Age 16'. I have since changed that to 'US Legal'. it is a simple check box for yes or no (actually a radio button on the website that provides the value into Method). My web-to-applicant form does not show that field anymore in the form ...

your the man! somehow some crap EVER so small like 5 tables got inserted in the top left hand corner so once you posted your solutions i started shifting stuff inward making sure everything was WELL within margins and i noticed this jumble up there moved stuff around to get to it and then deleted all of them and BAM back to normal.

Thanks Chad, that clears things up. I think we are writing an SQL statement though, you've just hidden the ugly bits from the user, made a nice gui to allow the user to build a statement by selecting a few key properties, fields, etc. and then written some code to parse that into whatever SQL language, object oriented, ASP whatever. Do you ...