2 Replies Latest reply on Sep 19, 2014 9:41 AM by SteveKeiser

    Formula for conditional format

    SteveKeiser

      Title

      Formula for conditional format

      Post

      On my master menu, I want some text to appear when there are incomplete shipping orders. I can conceive of using a trigger script that runs whenever the menu layout is entered, but I would imagine that would result in slowing the process of going to the master menu. So, I thought there might be a way of doing the check by using a table occurrence which matches Completed to a global field with a calculation of 1, and then use conditional formatting to hide or display the text. However I have been unable to do this. What is the best way to accomplish what I am trying to do with the least processing overhead?