Method:Classic General Q&A

Re: Conditional Formatting in Items Grid

Anonymous — Wed, 20 Jun 2012 15:16:53 GMT

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

Re: Conditional Formatting in Items Grid

crosewood — Wed, 20 Jun 2012 14:49:41 GMT

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?

Re: Conditional Formatting in Items Grid

Anonymous — Tue, 19 Jun 2012 18:21:38 GMT

crosewood:
I haven't been able to find a way to do this. Is it even possible to control the formatting conditionally?

Yes. A SQL override would be able to help you to change the formatting on a grid. On Step 2 when editing a grid you'll notice an advanced button, click that and you'll see the options for SQL Override. This setting is definitely an advanced feature and requires some SQL knowledge (or technical background).

Conditional Formatting in Items Grid

crosewood — Tue, 19 Jun 2012 17:21:29 GMT

I'm working on customizing our Items List screen, to make it look and behave more like QuickBooks.

I'd like to have a distinction between parent items, and sub items (the same concept *could* follow through to customers/jobs as well). Ideally, I'd like to indent sub-items, like QuickBooks does. Alternatively, making the parent items appear in bold would suffice.

I haven't been able to find a way to do this. Is it even possible to control the formatting conditionally?

Thanks!