Method Community

Getting this error message. Any suggestions?    Your client had encountered an error with web form CustomWebForm. This may be due to incorrect setup of the web form. The error encountered was: The array of insertion fields you have provided contains a field name more than once. Please make sure each MethodAPIInsert call contains ...

Thanks for the suggestion - I'll put it to the team here but I have no ETA on when or if this will be implemented. ~C

HI Greg, I read your original post and it got me thinking about how I might solve this problem, thought I'd share. Much of this overlaps with Chad's comments:   - What you're describing is a many-to-many relationship, not a one-to-many. As you said, one FSR can have many calls, but one call can also have many FSRs.  - The ...

@Greg From the information given I have the following recommendations : Initially set a Result action to the lowest Call#. Loop through the Grid/Table and compare the Result against the Value of the Row If the value from row > Result then change the Result to that value  (I would record the Record ID in another Result just in ...

You're not wrong to expect that but the fact that you're seeing behaviour different from the stock screens suggests to me that you've broken a link on the stock set of screens.  Without seeing your screen it's impossible for us to provide a solution to fixing the link on your stock screen.   At this point we've ...

Wylie, A few things about the Credit Card field here... Inside QuickBooks, under Edit > Preferences > Integrated Applications > Company Preferences  Select the Method Integration Engine (MIE) for use with QuickBooks and click properties Under the Access Rights tab, the last checkbox is to Allow this application access to SSN, ...

 Hi Chad, I don't know that I really answered your question ... there is nothing in the credit card # field, it is blank.  Everything else is still there, however ... name, expiration, billing & payment type. Thanks, wylie

I can't seem to figure out how to tell it to retrieve the "LAST" record.  I've tried it several ways but there is nothing to point at to match the criteria. In the "From table ____ where ____ is equal to _____"  I'm not sure how to tell it to look at the last record ID and retrieve the CALL# from that ...

I was also wondering if there is a way to use SQL outside of the Grid - either at the screen level or directly in Method Report Designer. Thanks!!

 Hi Chad, I was not aware that Method did not store the info. and have seen the data passed back to method in the format above.  That is not the issue in this situation, however, as the # was stored in QB.  I did just recently update it in QB though and actually saved and went back into QB to make sure it updated before I threw the ...