Method Community

[quote user="crosewood"]I haven't been able to find a way to do this. Is it even possible to control the formatting conditionally?[/quote] Yes.  A SQL override would be able to help you to change the formatting on a grid.  On Step 2 when editing a grid you'll notice an advanced button, click that and you'll see the ...

Worked like a charm. But can you explain the correct way to do this? "Back in Method just after the Generate Report action make sure clear the fields again"

Thanks Chad..  I think I understand what you mean.  I will try it out and see if I am on the same page. We are under the assumption that the end-user will not be able to "update the custom field created above in the company table" each time they want to run teh report. But I will see if I can get it to work that way

Here's a decent work around as you cannot pass parameters from the Generate Report action.  Open a Method report and you'll notice one common table regardless of your report... the Company table.  Add a custom field to the Company table to hold the parameters you want to pass to the report. Just prior to generating the ...

I'm working on customizing our Items List screen, to make it look and behave more like QuickBooks. I'd like to have a distinction between parent items, and sub items (the same concept *could* follow through to customers/jobs as well). Ideally, I'd like to indent sub-items, like QuickBooks does. Alternatively, making the parent items ...

[quote user="Method_Chad"]2 full syncs.[/quote] My mistake here, it's not 2 full sync's that need to happen, you need to close and open QuickBooks twice (and sometimes restart the computer).  If that doesn't work then it's a permission issue. ~C

I have a report that is using filtering within method.  However, the customer wants these filters to be printed on the reports.  So my only solution was to create 2 parameters within the report and have method assign values to these parameters based on some drop-down menus within method.  The parameters are PARAM_StartDate and ...

Thx. Using show message isn't allowed since this is all being done in a loop. What I have done is write these values into a variable and then dump it to a field on the screen (like trace or debug info). This trace info shows an empty value prior to insert. But the insert statement goes the Min Date route, for some reason. I may have to ...

I would add a couple of show message popups with your action results before and after your Date Add function.  I'm not sure the Insert action would do something like add a min date - the insert action just inserts a new row with the information you give it.  As a test, try changing to a different, blank AR to eliminate any ...

[quote user="walterh"]Why can't I just enter a new contact without identifying a existing customer?[/quote] You can actually, when you press the Add to Method button, just below the Search for box there's a button for New Contact / Lead / Customer / Vendor ... - clicking this will bring up the new contact entry screen and will ...