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

AppSheet AppSheet Q&A
1

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):

3X_9_a_9a0925f08e0842cd28d7d5d53f57c1d8736c53db.png
3X_9_a_9a0925f08e0842cd28d7d5d53f57c1d8736c53db.png420Ă—469 13 KB

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:

3X_b_2_b208ef6aff89c48e968c25ab53d2bb1862878acf.png
3X_b_2_b208ef6aff89c48e968c25ab53d2bb1862878acf.png1028Ă—594 32.4 KB

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

record created yesterday:

3X_a_e_ae3014d369d19747523b82ae3b4994925bf109aa.png
3X_a_e_ae3014d369d19747523b82ae3b4994925bf109aa.png430Ă—354 8.68 KB

not add button. Seems working fine.

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

3X_1_6_1657b91e8b227e8ac4ae596c46472c37dbe64912.png
3X_1_6_1657b91e8b227e8ac4ae596c46472c37dbe64912.png415Ă—425 9.5 KB

2

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](https://community.appsheet.com/t/removal-of-add-item-column-after-order-status-changes/20694) 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]

3

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.

4

thanks @Suvrutt_Gurjar!!

5

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