Bug Found in Pabbly Connect-- Google Sheets.

[Manjusha]

I created a google sheet and I am using Pabbly connect to create a new row whenever there is a new elementor form entry.

Everything works great in the normal scenario.

When I set-up a filter on the google sheet, the pabbly connect is getting the range of the sheet based on the filter and overwriting data.

Eg: let's say I have 100 rows in the sheet. Pabbly should add 101 row.
But if I have a filter on the sheet, and the filter results in 30 rows. Pabbly is overwriting the 31st row.

I have previously also mentioned another bug , where if A1 cell is empty, it was overwriting the first row.


The criteria that pabbly uses to find an empty row for insertion is incorrect.

I did thorough testing before reporting this. I hope it gets fixed soon.

 

[PabblyMember3]

I created a google sheet and I am using Pabbly connect to create a new row whenever there is a new elementor form entry.

Everything works great in the normal scenario.

When I set-up a filter on the google sheet, the pabbly connect is getting the range of the sheet based on the filter and overwriting data.

Eg: let's say I have 100 rows in the sheet. Pabbly should add 101 row.
But if I have a filter on the sheet, and the filter results in 30 rows. Pabbly is overwriting the 31st row.

I have previously also mentioned another bug , where if A1 cell is empty, it was overwriting the first row.


The criteria that pabbly uses to find an empty row for insertion is incorrect.

I did thorough testing before reporting this. I hope it gets fixed soon.

I am not sure about the filter logic that you are using right now, Could you please share a video of the same, explaining the above issue in detail? Also, share the workflow URL so that we can check it.

 

[Manjusha]

Hey Naveen,
Here is the recording of the bug :

Please do let me know once you copy the link and I will delete this public link.

I am not sure about the filter logic that you are using right now, Could you please share a video of the same, explaining the above issue in detail? Also, share the workflow URL so that we can check it.

 

[Pabbly]

Hey Naveen,
Here is the recording of the bug :

Please do let me know once you copy the link and I will delete this public link.

Thanks for the video. We will check and get back to you.