How to delete related rows in the same table?

AppSheet AppSheet Q&A
,
1

Hello,
is it possible to delete related row when I delete primary in the same table?

TomassoCee_0-1689674416242.png
TomassoCee_0-1689674416242.png1024×101 5.31 KB

When I delete first row (Task “In”) I want second row (Task “Out”) to be deleted. Rows are connected as in the picture above (ID and Related_ID columns).

2

JSO_0-1689676200701.png
JSO_0-1689676200701.png820×803 45.5 KB

I think AppSheet solves it automatically when you mark Is a part of in the related table.
In this case, when deleting the parent record, it eliminates the children that it has related to it.

1 Like
3

I think it does’n work in the same table… :expressionless_face:

4

You can do this with automation.