"Is a part of?" deep copy is not working on a correctly configured app

AppSheet AppSheet Q&A
1

Hello,

I have a problem with the deep copy (cascade add) feature that I cannot solve. My configuration seems perfect, but it doesn’t work.

My Setup:

  • A Parent table: Ricette acqua (with its own unique Key id).
  • A Child table: Ricette Comp acqua (with its own unique Key id).
  • In the Child table, I have one Ref column named id ricetta that correctly points to the Parent table.
  • In the settings for this Ref column (id ricetta), the “Is a part of?” option is CHECKED ON.
  • I have confirmed there are no other conflicting Ref columns from the Child to the Parent table.

The Problem:
When I use a simple “add a new row” action to copy a record in the Parent table, the action succeeds and the Parent record is copied correctly. However, the corresponding Child records are not copied.

Troubleshooting I have already done:

  1. I have checked all keys, references, and permissions. Everything is correct.
  2. I have checked the Audit Log. It shows the Add on the Parent table succeeds, but no Add operations or errors are logged for the Child table.
  3. I performed a “clean room test”: I created a brand new Parent record, manually added new Child records to it, and then tried to copy this new Parent. The problem persists even with clean data.

Since the configuration is correct and the feature fails even with clean data, I believe this is a platform bug affecting my app.

Can you please help me investigate? Thank you.

2

Is a part of doesn’t give you deep copy functionality. It gives you “deep delete”.

There’s plenty of q&a related to parent child copy implementation.

1 Like