Auto deleting child with "Is a part of" not working

[Paul_Janson]

I have several child tables that need to have related data deleted when a parent row is deleted. All tables are deleting data properly with the “Is a part of” REF link except for one. The only thing I can think of is that something about the way this table is populated (by an “add a new row to another table using values from this row” action) obscures the child relationship.

“Is a part of” is selected only in the User column.

Any thoughts?

[Bellave_Jayaram]

Is the behavior identical if you reverse, I.e., make Category is part of?

[Paul_Janson]

I just changed the is part of from User to Category, created a new category and deleted it, and still no delete on the Category_Dash table…

[Bellave_Jayaram]

Then, I would say it is a bug (or missing feature) to be sent to support@appsheet.com

[Marc_Dillon]

The auto-deletion works for me as of just a couple days ago. And that was also in a case where I’d used the same action type as you described to originally create the child records. Are you making sure that you’re letting the app completely sync?

[Paul_Janson]

Yes, it’s had plenty of time to sync. The other child tables are working properly, for some reason this is the only one that’s not. Very strange, I’ll send a request to the support team.

[Phil]

Is it possible that your client has not yet downloaded the most recent version of the application that includes all of your changes?

If a client device has any queued changes, those changes will be processed using the version of the application that was current when the client last synced. When the client submits its changes, it includes the version of the application that was active at the time the changes were queued. The server processes those changes using the version of the application the client included in the request. If that is an old version, then the server applies the change in conformance with that old version.

You can check the version being used by looking at the Audit History. The version number will be displayed with the incoming Add, Update, or Delete request submitted by the client. Compare that with the latest version of your application to see if the latest version is being used.

[Paul_Janson]

In this case I am the client. I’ve recently deleted and reinstalled the app on my phone, and obviously every time I load it up on the browser it’s loading up the most recent version.

[Marc_Dillon]

Paul_Janson:

and obviously every time I load it up on the browser it’s loading up the most recent version.

Why is this obvious?

Actually, the browser version tends to be very “sticky” in regards to caching older versions of the app and NOT using the most recent version. I recommend forcing your browser to refresh with Ctrl-F5, then follow it up by a manual sync. Do that EVERY time that you open the browser app while the app is in heavy development.

[Paul_Janson]

Great suggestion, didn’t realize that.

[OptimiX_XcrY · Accepted solution]

Is “user” table reffed to another table too ?

I would also check in User column for suspicios stuff, like spreadsheet formula remainings etc.

The name of the Gsheet and table, perhaps it doesn’t like the underline.

Maybe even delete and recreate the category dash table, in worksheet and in appsheet, without VCs, without underline. Then test the delete. Then add one vc,retest, second VC,restest…

[Paul_Janson]

Deleting and recreating CategoryDash solved the problem. It was a pain, but well worth the effort. Thanks for the help!

[Phil]

Hi Paul,

If neither my suggestion nor Marc’s resolve the problem, I suggest you submit a bug report.

If you do that please include:

1. Your numeric account id
2. The app name
3. The exact steps to reproduce the problem.

[Bellave_Jayaram]

@Phil, could you please add this to the documentation so other users may benefit?
Thanks.

[Paul_Janson]

Not sure exactly what I did to fix it other than delete the table and recreate it. Could you be more specific about what you’d like me to add?

[Bellave_Jayaram]

Maybe you encountered a “one of” case but I was asking Phil from the AppSheet team to add a note to the documentation (not sure which page) that for others who may see this same behavior that you did, the steps that they should try to fix it.