Jump to content

Conditional Formatting on a table row


jonep
 Share

This topic is 4387 days old. Please don't post here. Open a new topic instead.

Recommended Posts

We are creating a layout to display in table view the status of an order. We are giving it the ability to show either open orders or all orders. When viewing all orders we would like to use conditional formatting to change the background colour of the completed order rows to a different colour (say red). How would I go about this (if its even possible)?

Link to comment
Share on other sites

You cannot format a row (as you can in list view), but you could use cf to format each cell's background. Completed orders red? Red, to me, calls attention to the item. I'd actually want to fade the completed order away, and so I'd fill or change the OrderID text to a gray. Open Orders could be filled yellow.

Link to comment
Share on other sites

Agreed about red, was an example colour (first to come to mind). How do I conditionally format the fields with a formula outside of its own field (ie set field name to colour=grey WHERE field id=12). I only seem to be able to set it for the field in question.

Link to comment
Share on other sites

I can't link to FM Help anymore, apparently, but follow this path using FM Help: Home > Designing and creating databases > Editing objects on layouts > Selecting and working with objects on a layout > Defining conditional formatting for layout objects

Link to comment
Share on other sites

This topic is 4387 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.