I want the user to be able to add only max 4 children to a parent record.
In the child’s Add Action I tried
COUNT([ParentID].[Related Children])<4
but this is not working.
Solved! Go to Solution.
With some sleight modification to this sample app you can achieve what you want; it’s just a matter of changing the criteria for the actions.
Check out this sample app to see how I did it:
https://www.appsheet.com/samples/An-app-that-demonstrates-how-to-control-when-child-records-are-crea...
With some sleight modification to this sample app you can achieve what you want; it’s just a matter of changing the criteria for the actions.
Check out this sample app to see how I did it:
https://www.appsheet.com/samples/An-app-that-demonstrates-how-to-control-when-child-records-are-crea...
Thank you Matt that’s helpful.
When I understand it right, you disable the child’s ADD Action. Instead of that you use a LINKTOFORM() Action in the Parent table.
Maybe I should go this way.
Because what I wanted to do is: control the “ADD” in the Child’s table.
Yup, that’s the ticket!
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |