Method Community

Chad, I think answering this question in terms of typical SQL statement logic might help clear things up. As I was still lost after your explanation I looked up an explanation of the SQL SELECT DISTINCT Statement. The SQL "DISTINCT" keyword will prevent inclusion of records that have duplicate values in the named field or column. ...

I have a textbox which has actions that execute on focus.  They worked fine until I increased the number of input lines beyond 1, after which they don't do anything.  Is this a design limitation or am I doing something wrong? thanks, Rolf

[quote user="jnoneiliv1"]What's a "distinct value"?  There's no explanation in the Actions Guilde/Online User Guide.[/quote] A distinct value is the same as a unique value.  If you wanted to selectively loop through records by a distinct value then you would use this option. [quote ...

Don't be embarrassed.  It's on us - we should have made that more obvious, and saved you the frustration. I would go nuts when customzing if I didn't have the ability to move the 50th action to the 2nd spot without a simple edit and tab!   Paul

 Paul, I did not know that.  I am a little embarrassed but delighted to know I can move actions around that easily.  I will give it try right now.

 Bryan- It is "Process with a Webstore", there is an extra fee to have this enabled on your Intuit Merchant Services account. -Michael

The website field is not part of the screens, so no I do not believe my data contains any website values.  However, I feel that if the website field is part of the table, then xml should output the field and describe the value as null or empty.  I noticed it litteraly ignores that field and the xml will output information about other ...

 Hi CF_Pro Does it return an error message or does it return xml with blank values for the website? If it returns blank values for the website, do any of your contacts have website information entered? If the value is null it may not have been added to the xml, if the value is an empty string, it was added to the xml as <website ...

Did you know you can just type overtop of the number in the list?   Paul

Have you ever been frustrated with the slow progress of moving an action from one end of a list of actions to the other?  I know I have.  I have a simple suggestion to speed up the process of moving actions.  Place a drop-down menu containing all the available list positions next to the 'Move' label. For ...