Workflow: move row from sheet1 to sheet 2

Ask for Help
1

I am new to Glide and have a question about the following function. I have a sheet where we collect items for our NGO. What I want is when someone delete a row in sheet A this row has to be moved to sheet B.
I dont see how I can do this in Glide.

Could someone help me?

Thanks in advance.

2

How do you identify the corresponding row in the second table?

Let’s assume you have a common value in both tables, such as a UserID or ItemID.

bah! I completely misread. Will update my answer in a little while…

  • Create a relation from the first table to the second that links the two rows
  • Set your workflow up as follows:
    – If relation is empty
    — Delete Row → This row
    – Else
    — Delete row → Relation
    — Wait for condition → Relation is empty
    — Delete row → This row
3

Ignore my earlier response, I misread.

All you need to do is create a custom workflow that first adds the row to the second table (using the values from the row to be deleted), and then delete the row from the first table.

4

Thanks for your answers.
Which trigger should I use for this?
What my intension is that when I use the Delete option in a row in Sheet-A the row has to be moved to Sheet-B.
Problem with this solution is that I dont know (on forehand) which row a user will take to delete.

Or is there another soltion where Deleted rows can be saved in a second sheet?

5

You don’t need a trigger, just a normal User initiated workflow.
You also don’t need to know in advance which row will be deleted.
Configure the action as an item click action on a collection.

6

As i am new to glide could you maybe give me some more info about i could do this.

7

Here you go…

https://www.loom.com/share/3fd5b8a84d8b4b87a50495975f988b1b

8

This is realy great. I will try it tomorrow.
Thanks a lot for you help and you viedeo.
Realy appreciate this.

9

It worked !!!

thank you very much