Method Community

[quote user="viret56"]Can a grid field be filtered on containing one of several values (using a selection list or some other technique)?[/quote] Definitely!  On step 3 of 9 while editing a Grid, insert a filter and you'll get the option to filter by: Build selection list.  You can either type the list in directly or ...

Can a grid field be filtered on containing one of several values (using a selection list or some other technique)? 

After looking at what i was trying to do im looking at using one grid.  I added a new field to the lineitem table called Divisions and added that to the Grid. That way a divison can be sprinklers, lawns, lights, decks, etc. The other field i added was itemtype to the grid. That way i can filter all my labor for the whole job or just a ...

I'd like to have a look at this issue on your account, could you email me at c.ridgway@methodintegration.com and provide me with more details on which user this is happening to, which browser and if it's just the invoices tab.  I reviewed my field service pages and there's no issue that I can see.  This sounds like an problem ...

I'm not that experienced with SQL overrides for formatting but I do believe inserting <b> tags would bold those items for you. ~C

 This is happening again with the same user. I've instructed him to flush cache and also to try a different browser.   But is anyone else having sim issues?   Richard Martyniak

Thanks. I'm fairly experienced with SQL, so I can probably retrieve the data. However, I don't know how to change formatting using SQL. Should I insert HTML (<b>) tags to do the formatting?

I wanted to follow up my previous post with a caution on performance issues with using 8 grids at the same time.  The Item table can contain quite a few records so loading and filtering 8 different grids off the same table may not be the best solution for this.   You can acheive what you need with just one grid using multiple filters. ...

John - one thing I'll add. For performance reasons, you might want to consider putting each grid in its own tab. That way it only loads if the tab is visible. 

[quote user="John M"]How many grids can i have in screen?[/quote] You can definitely put 8 (or more) grids (of the same table) on a screen and use a custom filter for each one.  You can even mix in detached grids from other tables if you need.  There's a good set of actions available for working with Grids so you should be ...