I have a question regarding the deactivation of actions. I created a simple app:
Table “Request”
Table “RequestDetails”
Column “Order ID” is a Ref from Request Details to Request
After the Request was created with some detail lines I create an email, everything is fine. When email is sent, the column “LastUpdated” is updated with the current DateTime.
After the email is sent it should not be possible to add any positions, so I’ve put this expression to the “Add” action in RequestDetails table:
Add action is not a row level action. As such one cannot have a specific row level expressions to its condition such as ISBLANK([Order ID].[LastUpdated] in you case
There are several posts in the community on this topic of disallowing any adds to children records based on certain condition in the parent.
You could search them.
In general,
Please create a read only or update only slice ( as per your requirement) called say “RO_Request_details” on the child table.
In the parent table add a reverse reference column related to this read only or update only slice created in step 1 above. The general expression for this reverse reference column would be REF_ROWS(“RO_Request_details”, “Order ID”). Let us say the name of this column in [Related RO_RequestDetails]
You will already have a system created reverse reference column in the parent table called something like [Related RequestDetails]
On the show_if of the column [Related RO_RequestDetails] , please have an expression of ISNOTBLANK([LastUpdated])
On the show_if of the column [Related RequestDetails] , please have an expression of ISBLANK([LastUpdated])
Yes, and that’s the expected behavior. For new entries everything works.
But for existing entries I want to avoid adding lines. But when using the solution provided by @Suvrutt_Gurjar I still have both tables, even if I deactivate “Is a part of”:
