Disable add button of child/related table from Parent table based on criteria

[gioKelly]

Hi team,

I am creating/Viewing the Parent table (Inspections), and I would like to to disable the Add button of the Child table (Inspections_defects):

based on a criteria that if the record you are viewing was created today.

The criteria I have in the Add action of the child table is this:

I have tried other formulas, but always I just get to disable the Add button regardless the formula criteria:

record created yesterday:

not add button. Seems working fine.

record created today. Should be visible the Add action. Not workin:

[Suvrutt_Gurjar]

I believe your requirement is similar to the one in the post below. “Add” action is not row level, so I believe row level conditions will not apply. Please explore the below approach.

Removal of add item column after order status changes Questions

Hi i created a copy of the order capture app, and have also enabled Completed orders in the view. I want to remove the add item below the virtual order details column after the status is changed to complete , so that no one can manipulate completed order. Please help me in this regard [image]

[gioKelly]

thanks @Suvrutt_Gurjar!!

[Jervz · Accepted solution]

I had the same problem before but i ended up creating two slices of child records.
The first slice is the TODAY’s Date which is ADD, EDIT, DELETE are enabled.
Set [Parent].[Date] = TODAY()

The 2nd slice is NOT TODAY’s Date which is Read-Only or you can disable ADD only.
Set [Parent].[Date] <> TODAY()

Next step is creating two REF_ROWS(“Child Records”, “Parent ID”) in Parent’s Table.
Change both the Referenced table name with those two slices created.

Last step is change the SHOW_IF of both child refs
Today’s child records can be [Date] = TODAY()
Not Today’s child records can be [Date] <> TODAY()

There should be a better way but this one works for me at the moment.

[gioKelly]

Thanks @Jervz very very detailed, I will definitely try thi. Thanks a lot!