Method Community

Hey Nelson, To clarify, I guess I'm not really searching for a NULL value per se... but a BLANK value. I've had a great deal of difficulty in determining how to construct table queries where I am searching for either BLANK or NON-BLANK values. Your suggested approach does not work. In fact, is backwards. In order to query a table where ...

Checking for null values appears to be easy, if not counterintuitive (X not equal to ... type in... blank value). There does not appear to be any way to check for non-null values, though. What am I missing?

Thanks Adam! Will do...

Thanks Jason. Will do some testing to determine where the variables are being lost. Appreciate the help.

Dave, Thank you for your answer. Will consider setting up the portal at some point down the line. For now, we'll just continue sending invoices by email.

Two questions: 1) When will Method support the new Advanced Pricing add-on for Quickbooks Enterprise? 2) When will Method support the (once-supported) old Advanced Inventory add-on for Quickbooks Enterprise? Eager to start leveraging these add-ons with Method. Thanks!

Hey Jason, That's what I had assumed, but does not always seem to be the case. For example, I have an action set that loops through the invoice table. Pulls a few values by associating RecordID with the action result for the RecordID of the current row for table updates. Various character functions are in place to convert the ...

I would like to know more about the lifecycle of an action result. Been running into problems with action results being wiped out before we're able to use them in a conditional statement, calculation, etc... seems as though this is happening sporadically, surviving one time in an action set but not surviving in the next. When exactly does an ...

We're working on setting up a customer account login area on our website where copies of final invoices may be downloaded directly. I've created a REST API on the website side that allows us to update order status from (example) Processing to Complete, once an invoice is generated from a sales order... or "Partially Shipped" ...

Yes, I saw that but added a new action--first tried as the first in the action set, and as the last one as well. It just doesn't seem to be running for one reason or another.