Delete older row and keep latest row

[desmond_lee]

Hi Guys

I have create an automation to send all the latest stoctake to another table. But I don't how to create and action to delete the older row by Standard Tool ID grouping every time a stocktake form is save (submitted). Example tool ID HT278-1-STRIPER-ST in row 24,27 & 30. I want to delete row 24 & 27 then keep latest timestamp 8/15/2023 17:09:21 at row 30.

This is the bot without delete row.

[blackboomber]

Hey @desmond_lee , i also working with Data that contain date to indicate newer Data

In my case, im using GSheets rather than AppSheet function to get the latest Data that indicates which is the newest within the ID 

Try to use SORT feature in GSheets to get it like i did

[Marc_Dillon]

Use a reference action to run delete on all rows with the same tool id and with timestamp < thisrow timestamp.

[desmond_lee]

Hi Marc

Any sample of such case or discusiion somewhere? No idea how to write this expression

[desmond_lee]

Hi

I mange to get this but something still wrong somewhere. Intend to delete the row what bots delete only the content and leaves a blank row. Any idea how to resolve this? The action and bot is in below

Delection ACTION. I use the Appshhet builtin DELETE feature it dosen't work too

Execute or trigger at form sumbit

Expression at execute 

[Marc_Dillon · Accepted solution]

---

@desmond_lee wrote:

bots delete only the content and leaves a blank row

---

That's just how delete works. Don't worry about it.

[desmond_lee]

Oh really. Kinda surpirse to me. Its ok I will use script to delete the blank row

[desmond_lee]

Resolved with external script