B1UP Validation - Conditionaly Change the Cell Color

Vaughn Bradley

• January 26, 2022 21:21

I will simplify this for clarity. A customer has a Stock field on the Sales Order lines. It has a formatted search that calculates the current stock value/count. Depending on that value, they want to change the color of that cell. So if row/item one has stock of 10 or less, make that cell red, but if row/item two has stock of 100 or more, make it green, otherwise make it yellow. So far everything I do makes the whole column red, yellow or green. I need that column different (potentially) for every line.

Vote

1

• 

  Vaughn Bradley

  • January 26, 2022 21:24

  So I guess the real question is can I set the backcolor at the row level or just the field level.
• 

  Dave Gutman

  • January 26, 2022 21:43

  Hi Vaughn,  The online help for the Macro command: BackColor has a chart that shows which SAP UI elements are impacted by the command.  This command doesn't impact Matrix Rows and Matrix Cells, but it does impact Matrix Columns.
• 

  Nadav Caridi

  • January 26, 2022 22:59

  I did something similar in a row level. But it wouldn't reset when I would bring up a new order. I ended up just doing a validation before the order is being submitted that shows up missing inventory lines. It also works better in my scenario since most of my orders are submitted via xml interfaces.
  Cheers

Please sign in to leave a comment.