Hi there. I’m really new with Glide and Zapier, but I was a programmer a long time ago and therefore I think I understand quickly and I hope to make you waste little of your precious time! For me Glide was a great rediscovery and is giving me great enthusiasm and desire to start programming again. …

Hey! Welcome to the community! You can always add conditions to a ZAP where you can test the condition under which you want to copy the row to a different sheet. If you can share a few more details, with screenshots, the community may surprise you with a better solution within Glide. Have fun.

Thanks Sardamit for your reply. I need to move (i.e. copy from one source sheet to another and then delete from the source sheet) a subset of rows that meet a certain condition (the condition is that of belonging to the same email as the authenticated user). As you can see from the screenshot deta…

Is this only for extra work later in the Sheet or do you want something in the app?

In the App. After this, more actions will be carried out in the “Prenotati” sheet.

Probably you can try QUERY. [image] Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1) Ask for Help This topic was inspired by our last community meetup, in which we talked about some formulas in Google Sheets and some people want to know more about …

I agree. But I should only trigger the query at the moment the “MOVE TO” key is pressed. Do you think it is possible through Zapier?

Query will always refresh instantly so that would not be possible. Would the move to button move only 1 row at a time or multiple rows?

Multiple rows. Thanks for your support

[image] sardamit: You can always add conditions to a ZAP where you can test the condition under which you want to copy the row to a different sheet. So this is the way to go, probably the flow I imagine is: Button triggers the Zap to write a new row to Google Sheets, in a “Move Logs” sheet…

Thanks ThinDinh, but (in your second step) are you sure it’s possible to “check all rows that satisfy your condition” ? That’s exactly what I can’t do in Zapier, there’s probably something I don’t know yet. It seems to me that it is not possible to select more than one row at a time. I will study be…

How to move rows to another sheet

Ask for Help

ThinhDinh September 1, 2020, 5:21am 6

Probably you can try QUERY.

Topic		Replies	Views
Copy information from one sheet to another Ask for Help	8	2370	September 27, 2022
Using Boolean selections to copy multiple rows into new table Ask for Help	3	45	September 24, 2024
Copy Row Script Ask for Help	25	574	August 23, 2021
Alternatives to zapier Ask for Help	13	1397	November 3, 2020
Deleting multiple rows in a certain table with Zapier Ask for Help	3	557	February 3, 2023

How to move rows to another sheet

Related topics