Method Community

Hey Rolf, Unfortunately, Method does not allow for the SQL DISTINCT keyword. Also, the value from row has to be the from the same field as the distinct option. Based on what you've told me, you might be able to get the result you want by embedding a second loop into the first loop. (First loop gets distinct customers, and the ...

Is it possible to apply a credit memo to an invoice through the API? If so, which tables/fields would I use?

Hey andy, Try this in Firefox, but first clear your browser cache/history. It shouldn't be happening but there is an issue with web forms on Google Chrome having their data reset as you mentioned, plus some other strange behaviour. Our dev team is working on getting this resolved so in the meantime using a different browser should help. As ...

Sorry, just seen an earlier post. I'm now using Firefox and it seems to be working.

Hey andy, One work around is to assign those actions to a hidden button on the screen then just call that in your grid and anywhere else you need to call it on the screen. Hope this helps! - Ashur

Hey Ben, Let me know if I'm understanding you correctly. You are trying to limit access to certain tab links for your portal users correct? The way you're doing it now is by limiting the roles that can view the tab links (Customize > Tabs > Edit Tab Links... > Roles That Can View) This will only work for actual Method ...

Is there any way of calling or copying actions from within a grid? They don't appear within the dropdown in call another action set or copy. Just wondering if there's a work around. Thanks.

I have been trying to create a couple of web forms over the last few days. All goes well until step 8. I can't edit and change any default values or set any fields to hidden. Clicking the hidden check box skips the screen to step 9. When hitting finish the final screen only shows the HTML for the header and footer, there is no body. If I save ...

I have a custom grid setup for open purchase order lines, and we've hired someone to maintain up-to-date status on all items that we have on order. The grid displays the standard stuff... item #, purchase order #, qty ordered, qty received, et al. I have added a new field in the PurchaseOrderLine table called ItemStatusNotes, and have added ...

Hi Sam, Thanks for your suggestion on this.  I had hoped you were going to suggest some implementation with  the SQL  'Distinct' keyword with my Action  Result to achieve this. As to your suggested approach, I had already tried something like that.  The problem is that not only do I need to count ...