StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>The solutions I can think of are:</p> <ol> <li>Auto-complete </li> <li>Recent associations</li> <li>Smart associations</li> </ol> <p>There may be more depending on exactly what you're doing, so feel free to add more details or screenshots and I'll think on it more.</p> <hr> <p><strong>Auto-complete</strong></p> <p>Using an auto-complete field would speed up the process for your users since they wouldn't have to hunt through the table for the association. Rather they could just start typing and have a suggest box appear below the field that allowed them to select what they're looking for.</p> <p>If you matched your auto-complete on several key fields (i.e. manufacturer and product name), there's a pretty good chance that the user would be able to find the association quickly.</p> <p>You could also code the suggestion box in such a way that it showed multiple pieces of key data. That way if the user wasn't quite sure what they were looking for, typing a few characters in the field would give them an idea of what they could search with.</p> <hr> <p><strong>Recent Associations</strong></p> <p>Below your auto-complete field, you could add the 5 to 10 most recent associations that had been made. That would allow your users to quickly add many products to the same association without having to use the auto-complete each time.</p> <hr> <p><strong>Smart Associations</strong></p> <p>Separate from the above two mechanisms, a smart association is something I first saw when theming a <a href="http://www.shopify.com/" rel="nofollow noreferrer">Shopify</a> store. They allow you to automatically create associations based on the products key fields by defining conditions to include or exclude products:</p> <pre><code>Create Association 'Pants' Where product title contains string 'pants' or Where product title contains string 'capri' </code></pre> <p>The above is controlled by a set of dropdowns and textfields and got around the pain of manually creating associations.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload