Auto Move Rows

brhea110891

I would like to auto move all completed requests that come to a sheet to the bottom of the sheet. I don't want to archive them yet, just move to the bottom. Is this possible?

Thanks

prime_nathaniel

brhea110891

This is possible through a number of ways

via sorting, just numeral prefix your statuses so that complete is like 99. Complete, now everytime the sheet is sorted complete goes to the bottom.

via bridge and sorting, you would create a webhook on column change for the status field. When status column changes run workflow. Your workflow would then need to examine the row data to determine if status field is complete (because it checks all events not just complete ones). Now that you are only dealing with complete rows being processed. You can call the sort API to resort your sheet everytime the a row is marked as complete. Using the 99. prefix complete is always at the bottom.

via bridge and parent rows, you would create a webhook on column change for the status field. When status column changes run workflow. Your workflow would then need to examine the row data to determine if status field is complete (because it checks all events not just complete ones). Now that you are only dealing with complete rows being processed. You would get the id of the complete row, and update that row so it is placed in a parent row at the bottom of your sheet.

Round about way via core and automations,
Off load / move the row to a holding sheet. Move the row back to the original sheet using automations. This does have the side effect of changing row ids so it can break more advanced integrations utilizing your row data.