Auto remove cell data after reference key is removed

AppSheet AppSheet Q&A
,
1

Let make my question easy, i have table A employee list that content 2 columns that is staff name and staff ID(key value), table B is asset list that content 4 columns that is asset ID(key value), asset type, staff name and staff ID, i set a reference at table B for staff ID column that point to table A staff ID column, i have configure the dereference for both table and everything is working fine. My question is after i remove the specific row at table A, i want the cell data from staff ID cell and staff name cell at table B is auto remove without remove related entire row. Im still new for appsheet, hope someone can help me with this

2

@ckng6218

Welcome to the Community

One way to do this isā€¦

  1. TABLE A: Create an action to call an action on TABLE B.
    • Execute an action on a set of other rows (Reference Action)
    • Referenced Rows = [Related TABLE Bs]
    • You can pass [who to transfer to] ā† EDITTED: you do not need thisā€¦
  2. TABLD B: Create an action to clear [staff ID] and [name]
    • Data: set the value of some columns in this row
  3. TABLE A: A Composite action to call 1, 2 and the generic DELETE action
    • Execute a sequence of such actions on one row (Composite Action)

See if this works for you.

You should also read the below if you havenā€™t already

https://help.appsheet.com/en/articles/953637-actions-the-essentials

Try to work it out and you can ask additional questions if you need further clarification.

1 Like
3

Thanks! im not deep enough explore for the behavior feature, appreciate for your tip

1 Like