Delete a row after calling LINKTOFORM()

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:

  1. Copy the row from “Inventory” to “Sold books”
  2. 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.

If a grouped action contains a navigation action (e.g., that uses LINKTOFORM()), no actions after the navigation action will be performed.

Why are you navigating to Sheet1_Form? Does the user need to interact with the form at all?

Yeah so the sales data is added (price, marketplace etc) to the Sales Data sheet. The sales data sheet refers to the key of the item in Sold Books for info about said sold book.

This is a little different to most sales trackings because this is always one item is one entry as these are antiques so even the same title will have differences - mainly the condition of it.

Is there a way to call certain actions after a specific form is saved?

Maybe I can make another action bundle to copy from “Inventory” to “Sold Books” and delete the original row in “Inventory” after Form1 is saved in “Sales Data”

2 Likes

Ah coolio, the same thing that I am doing but piggybacking off the save function on a chosen form.

Good stuff Steve, appreciate it!

1 Like