Is it possible to disable sorting in Dynamic View?

User251 · 05/04/22

I want to disable sorting in Dynamic View to prevent users from messing with the data order. How can I do that ?

Genevieve P. · 05/05/22

The Sort order of rows in Dynamic View will be based on the Sort in the underlying source sheet. If you update the Sort in the sheet, the View will show the new sort order.

However at any point your users in Dynamic View can click on a column name to organize their own specific view. This will not affect the order for any other users looking at the view, and if they refresh the page or when they come back to it again later, the sort order will revert to the original order and be based on the underlying sheet.

There currently isn't a way to remove this Dynamic View personalized sort functionality, but hopefully that helps clarify that it won't mess with the data order permanently.

Cheers,

Genevieve

Genevieve P. · 05/05/22

Hi @User251

The Sort order of rows in Dynamic View will be based on the Sort in the underlying source sheet. If you update the Sort in the sheet, the View will show the new sort order.

However at any point your users in Dynamic View can click on a column name to organize their own specific view. This will not affect the order for any other users looking at the view, and if they refresh the page or when they come back to it again later, the sort order will revert to the original order and be based on the underlying sheet.

There currently isn't a way to remove this Dynamic View personalized sort functionality, but hopefully that helps clarify that it won't mess with the data order permanently.

Cheers,

Genevieve

User251 · 05/06/22

Thank you @Genevieve P. That was helpful.

Stephanie Reedy · 05/25/22

Mine's the opposite problem. Every time I have to do maintenance behind the scenes I manage to upset someone because I forget and sort anyway.

Is it possible to disable sorting in Dynamic View?

Best Answer

Answers

Categories