Enable/Disable Add action of child-table from Parent-table View

[Geovany_Kelly]

Hi team,

I have been trying to disable the Add option of a child table from the Parent’s view based on a condition if the record is being seen by the same user that created the Parent record…

My tables are

• Incident

  • incident_id
  • description
  • created_by

• Incident_images

  • incident_id
  • image_id
  • image

Formula: [incident_id].[created_by]=USEREMAIL()

I have tried a lot of things but not success.

[Steve (Steve Coile)]

See my response here:

Removing Add Button from Inline View based on contents of another Cell

The system-generated Add action is not aware of the current row, so you cannot reference _THISROW within its Only if this condition is true expression. To accomplish what you want, I suggest creating a read-only slice on the History table. In the Maps table, you’ll need two columns that contain the same list of History table references. One will have a Source table of the History table itself, the other will have a Source table of the read-only slice. [image] Add a Show? expression for each o…

[Geovany_Kelly]

Hi @Steve

thanks for that! it seems to be the best approach, I will test later and let you know!

[tsuji_koichi]

This is another (different) approach, but to get the same effect.

Limit the number of child entries

Im taking different approach when i want to limit the number of child row to be added to one parent. [2020-06-04_15-41-20] First, to make the inline child view set to parent table out of slice which is update, delete only (not able to add.) Make a virtual column to parent table to dynamically calculate the number of child rows. Make action attahced to parent table, which will open the form to add to it child table. The action button is made visible only when this Virtula column value is le…

Just present add child row actoin button on the ground that your preference conditions does meet, otherwise hide action button.

[Geovany_Kelly]

hey nice tip! thanks @tsuji_koichi