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.
This is the problem I actualy have: I want to move rows from a sheet to another sheet when a “confirm button” is pressed.
I tried to use Zapier by triggering the button, but then I can’t select the row set to move (I need to move only rows that meet a certain condition). I don’t know if this approach is correct or if I have to look for another method to achieve my goal.
Can someone help me?
Thank you very much!
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 details.jpg, here are two components: 1) an “Inline List” which shows the lines that belong to the user authenticated with the email “emporiovapori@gmail.com”; 2) a button called “MOVE TO” to which an action on Zapier can be associated.
In the screenshot “sheet-carrello.jpg” you can see the existence of the three lines that are associated with the user “emporiovapori@gmail.com”; naturally this sheet will be populated with many other lines of many other different users. So, there is a need to select only the lines that belong to emporiovapori@gmail.com.
The sheet Prenotati has the same structure of the Sheet Carrello (as you can see in screenshot “sheet-prenotati.jpg”); here we must copy the rows from Sheet Carrello, and then we must delete from Sheet Carrello.
Thanks again, I hope I’ve been exhaustive.
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.
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
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 for example.
-
Trigger another Zap so that when a new row is written to “Move Logs” sheet, go to the sheet that you want to move rows from, check all rows that satisfy your condition, then copy them to the destination.
-
Go back to the origin sheet and update a column, let’s say “Sent” or anything like that so you won’t copy the same thing againn next time.
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 better.
Probably you need a “Search” step here to return multiple rows.
Yes, I was thinking about this. However, an additional strategy is needed, because there will be multiple matches of rows that satisfy the condition, while the Zap can only work with the first row it encounters that satisfies the condition (If there are multiple matches, the Zap will return the first row it finds from the bottom up).
So I have to find a way to re-launch the same ZAP as long as there are no other lines that meet the condition.
Humm … maybe this is doable somehow.
I see you keep following me … Many thanks for your help. Have a nice day!
@Roldy Hello sir. Do you still need help with this?
No thanks. At that moment I was in my first experiences, now everything is clear to me for that scenario.
Thanks again @Eric_Penn