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.
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.