Control when Showing the System Generated add Button when displaying the reference table

[Mufaddal_Suleim]

I have 2 tables Called Order Items, and Orders. The Order Items references the table Order Item and therefore have the references table created and show in the Order inline Form.

I was wondering if I could control when to show the add button depending on the order status as what ever expression I try affects all other entries and is not specific to the Order

Expression Used in the Order Item add function
LOOKUP([_THISROW].[Order ID], “Order”, “Order ID”, “Status”) = Pending
[Order ID].[Status] = Pending

[Steve · Accepted solution]

I just yesterday addressed a similar question. Click through for my response:

Enable or disable the Add button in a master-detail form Questions

Wait, wait, wait… The Add action is not presented in a row context, so you cannot reference columns of the current row. To do what you want to do, you aren’t going to reconfigure the Add action at all. Instead, you need to do the following: Create a slice of the INVOICE_DETAIL table with no Row filter condition expression, and with Update mode set to Read-Only. Add a virtual column to the INVOICES table called Viewable INVOICE_DETAILs and an App formula expression of: [Related INVOICE_D…