In my version of Order Capture, I want to remove the add new order detail when order status is complete. Where can I find those settings to edit?
This is controlled by the system generated ADD action fo that child table.
To see system generated Actions. navigate to Actions in the Behaviors tab, scroll to bottom and click link to โShow systems actionsโ. See image.
Then go to the list of actions for your table. My table was for Products. In your case it looks like itโs the Order Details table.
Then adjust the expression for the โOnly if this condition is trueโ property in the Action.
Thank you very much
It works, though Iโm using this formula that is getting rid of the โNewโ even on order status is open.
[Order Id].[Order Status] = โOpenโ
Any formula that would preserve the โNewโ when order status is open?
I apologize!
@Marc_Dillon is correct. I answered a bit hastily and overlooked that this action is not a row-level action (see image below). I knew this at one time but had forgotten it.
The message โnot a row level actionโ means that you do not have access to column information. So, you will not have the ability to hide/show the Action based on the parent info - since you canโt access it.
@Marc_Dillon 's suggestion is a great workaround!
Thank you
Thank you. I have made the slice and new VC. #2. I donโt seem to know how to point the REF_ROWS() expression the new slice. Also can you explain more on how #3. to toggle visibility between two VCs based on [Order Status]?
To point to you newly created Slice, simply replace the datasource name in the REF_ROWS() function. See the image below for the location.
To toggle between the two VCโs, insert an expression into the Show_If property of each VC.
In the VC that shows when the Order is still active use something like: [Order Status] <> "Closed"
or whatever the name of your closed status is. I am suggesting <>
assuming you have several active statusโ
In the VC that is to show when the Order is closed use [Order Status] = "Closed"
Where to insert Slice name in REF_ROWS()
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |