I do understand that when I change the order of the database (appsheet database) table columns, the filter order changes but I have a lot of virtual columns that are NOT in the database.
So how to change the order of the schema please!
There is no built-in way to reorder columns of a table within AppSheet itself, but there may be other approaches. We might be able to offer better suggestions if you can explain what you’re hoping to accomplish and why.
The filter (that appears in the right side of the table view when I click the filter icon) is totally not arranged. I have a lot of virtual columns and they appear at the bottom in the filter. But I want them at the top so that I don’t have to scroll or search.
Ah. There is no way to affect the order of anything included in the filer feature.
Thank you, Steve!
If the built-in filter panel is following the table/schema order, the most workable approach is usually to create a slice just for that view.
In the slice, include only the columns you want users to filter on and put them in the order you want as much as AppSheet allows. Then point the table view at that slice instead of the base table.
For virtual columns, also check where they sit in Data > Columns for the table and whether the view/slice column list is overriding the default order. You may not get total control over the filter drawer, but a dedicated slice is usually cleaner than trying to make the base table order serve every view.