How can I limit values?

[abirtanjinadnan]

Here in this photo, by clicking on the add button, I can add as many data as possible.
I want to make it limited. I want to limit it 7. (1st photo)

In system-generated add button, I have given a query (2nd photo)
COUNT(Product[Related Photos]) <= 7

What’s wrong?

[JuneCorpuz]

You have to include the key in your formula. It should look like this.

abirtanjinadnan:

COUNT(SELECT(Product[Related Photos], [key] = [_THISROW].[key]) <= 7

[abirtanjinadnan]

Sorry, this is not working. (screenshot -1)
I have tested in several ways.(screenshot -2,3)

Anyway, my Product table has no “Key” column, “Item code” is working as the primary key.

[JuneCorpuz]

COUNT(
      SELECT(
        Product[Related Photos], 
        [Item code] = [_THISROW].[Item code]
      )
    ) <= 7

[abirtanjinadnan]

Sorry, it’s also not working. It’s still adding elements.

Actually, I have added this condition on Behavior -> Actions-> Product -> Add (Sys. generated) -> behavior -> Only if this condition is true

[Koichi_Tsuji]

Your expression wont work to achieve what you want.
Refer to my old post here.

Limit the number of child entries Questions

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…

[abirtanjinadnan]

Hi,

I have applied all the suggestions that you wrote on your post.
In screenshot 1, I set parent table update/ delete only
in screenshot 2, a virtual column to the parent table
in 3, made an action attached to the parent table
in 4, made action button visible for condition N <= 7

But I got some output like (screenshot-5, 6)
The action is not visible here (not showing).
And No of Child row is inside the page.

Are my actions wrong? Please see.

[Koichi_Tsuji]

Not sure your exact data schema, but it appears to me you are adding new row to own parent rather than child table.
See my post I shared with you to construct the process.