Method Community

Great Stuff! It's pretty amazing how powerful the Action library is for making custom applications.  The balance of functionality and ease of use ir really elegant, and I think some further explanation of usage would be a good investment. I can't think of a more powerful toolkit for small business than QB plus Method. ...

Thanks Chad, that clears things up. I think we are writing an SQL statement though, you've just hidden the ugly bits from the user, made a nice gui to allow the user to build a statement by selecting a few key properties, fields, etc. and then written some code to parse that into whatever SQL language, object oriented, ASP whatever. Do you ...

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. ...

Both Loop Through Table and Loop Through Grid have a property that allows selection of a field for "Only show distinct values for field" in the case of Loop Through Grid, or "Only distinct values (optional):" in the case of Loop Through Table. What's a "distinct value"?  There's no explanation in the ...

Ok.  I was just curious if there was an architectural advantage between the two options when looking at the situation of potentially 1,000's of files attached to something like the Item records.  I would think that the Method file store would be very appropriate, but I think the current performance cache based on filename is more ...

We're using the File Attachment data type, the Picture Object, and the Method Store to hold images, pdf files, and CAD drawings of our foundry tooling using the Item name as a key field.  For all of the Items we make we need to associate images of the parts, tooling, and pdf files of CAD drawings, and other image and file data.  We ...

Thanks.  Understood.

I'm seeking clarification on the usage of "Row" references when performing various actions.  For example when using the Assign Value to Action Result action there is an option "Value from Row". I had thought this might refer to the row in a Grid when looping through the Grid, or that this referred to the active row in ...

Paul, That all makes sense to me.  I have a lot of questions about the use of some of the Actions, many of which are somewhat theoretical in nature as I can usually get everything to work, but I'm not sure I'm really taking proper advantage of the intent AND functionality of an Action.  For example there are still several ...

Paul, you're most welcome.  Is there a place I can submit some suggestions for updates to the guide?  There are some usage details of the actions that I've learned either in experimentation or with help from Michael and Valbon, and some questions I have still on some actions even though I'm using them successfully, that ...