JeffreyYu
Member
Hi Pabbly Connect,
I'm trying to add in entries from a form into a Google Spreadsheet in DECREASING order (aka the most recent entries at the top, the older entries at the bottom). However, Pabbly Connect upon adding a new row always adds it at the bottom.
There's two ways I was thinking of getting around this:
(1) Use the =sort function to autosort. The only problem is, sort takes data from a master sheet. So if I put data into Sheet 1, for example, then I would have to create a sorted version in Sheet 2. This would make triggers confusing, as then if I triggered from Sheet 2, I'd need to make sure to update Sheet 1 as well automatically. I'm also concerned that the autosoring on Sheet 2 would accidentally trigger the trigger column, since all the values would be updated and reordered.
(2) (better) Insert into row 2 of the spreadsheet (the top) instead of the bottom of the spreadsheet with Pabbly Connect. The only thing is, I don't know if Pabbly Connect supports this functionality.
If neither version works, is there a more efficient way of doing this? Right now I'm just manually sorting each time I read through it.
Thank you!
I'm trying to add in entries from a form into a Google Spreadsheet in DECREASING order (aka the most recent entries at the top, the older entries at the bottom). However, Pabbly Connect upon adding a new row always adds it at the bottom.
There's two ways I was thinking of getting around this:
(1) Use the =sort function to autosort. The only problem is, sort takes data from a master sheet. So if I put data into Sheet 1, for example, then I would have to create a sorted version in Sheet 2. This would make triggers confusing, as then if I triggered from Sheet 2, I'd need to make sure to update Sheet 1 as well automatically. I'm also concerned that the autosoring on Sheet 2 would accidentally trigger the trigger column, since all the values would be updated and reordered.
(2) (better) Insert into row 2 of the spreadsheet (the top) instead of the bottom of the spreadsheet with Pabbly Connect. The only thing is, I don't know if Pabbly Connect supports this functionality.
If neither version works, is there a more efficient way of doing this? Right now I'm just manually sorting each time I read through it.
Thank you!
