I have a parent table that has a reference to a child table containing just pictures. When I delete the parent record, I expect for the child record associated with the parent record to be deleted as well. any thoughts?
Things to know:
The child table is the only is part of reference child table.
There are 2 more ref to tables that are not is part of.
The parent table is call “Real Estate” and the child table is call “Fotos”.
The child table has multiple physical columns for pictures. 5 in total.
The parent table has many virtual columns.
The child table only has one virtual column which is the automatic reference row list to the parent table.
How are you performing the delete action? By manually selecting a button for the system-generated action on the parent row you want to delete? If that action is being invoked via other means–e.g., the AppSheet API–I wonder whether that may not trigger deletion of ‘is part of’ child records.
When using the folder as a table it does work, however, it only allows you to have one single file per record. Is there a way to add multiple files at a time?
I’m talking about deleting the files from the child record does work when using folder as a table. haven’t tried deleting the child record from parent.
It sounds like this actually is working–i.e., you delete a parent record and all child records associated via an Is part of Ref type column are also deleted.
Yes, that’s my understanding–i.e., when you delete a record any files referenced in that record’s columns are not deleted.
I’m not sure what you mean. Maybe create a table view where you can simultaneously select multiple rows.
Also, consider whether you could use Apps Script to accomplish what you need. For example, maybe you could create an automation triggered by record deletion that Calls a script to trash relevant files.