April 6, 200520 yr So I have a system of tracking the progression of orders. After so many steps it is considered completed. I currently have a portal showing that progression of all the different orders. The question: Is there a way so that when the final step is marked off as completed, that order will no longer show up in the portal?
April 6, 200520 yr The trick here is to use a calculation in the relationship the portal utilizes something like case ( steps = "Yes" ; OrderID ; "" ). As long as the text field steps has "Yes", the calculation will contain the OrderID, or whatever you use for the relationship. When an order is completed, set steps to something other than "Yes" and the calculation will return a blank, and that order will disappear from the portal.
Create an account or sign in to comment