So let me begin by painting my setup.
I am tracking book sales, I have an “Inventory” table, a “Sold Books” table and a “Sale Data” table.
I have an action to “Mark Book as Sold” . This does two things:
- Copy the row from “Inventory” to “Sold books”
- Calls “LINKTOFORM(“Sheet1_Form”,“Books Sold”,[Key])” to copy the key of the sold book to the sales data row.
I would also like a third thing to happen which is to remove the original row from “Inventory”. I have tried to make an action to do this however step 2 seems to interrupt it. I cannot call the deletion before the LINKTOFORM() action as that means I can never copy the key.
Is there any other way to achieve this?
I considered the possibility of copying from “Inventory” to “Sold Books” after a new row is added in “Sales Data” but I cannot figure this out. They all have the same BookID key so it should be possible to reference it but I cannot figure out how.