Item Movement Log

[Pratik_Shah]

@Manan_Mehta

Instead of having a column for possession in the same sheet, create a new sheet for possession logs.
In that sheet, have columns of timestamp, item SKU (Unique ID of item), customer email and possession and then create a multiple relation of this sheet with your items sheet using the item SKU.

Hi @Manan_Mehta, in continuation of this, I have a multiple relations (movements to the main item). However, when I delete the main item (this is necessary in my App for users), the movements log remains there in the Log sheet.

Any idea how can we achieve this @ThinhDinh @Jeff_Hager @Robert_Petitto ? (i.e. when I delete main item in sheet, it deletes all corresponding movements in Log Sheet). Can Compound Action will help here?

Thanks