Idea

Enrique Elizaga avatar image
3 Likes"
Enrique Elizaga suggested Sam Stubbs commented

Enable Excel-style filters on tables

Sometimes when browsing a table, it is difficult to spot specific rows or entries. It would be great to be able to filter tables to show/hide rows maybe with the typical tools filter, order A>Z / Z>A.

global tablesfilter
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Comment

Sam Stubbs avatar image
1 Like"
Sam Stubbs commented

The tables in FlexSim are designed to be a bit simpler than what a full fledged spreadsheet program has. Having said that, the Table class of objects in FlexSim does allow you to sort via command script.

Using the Table.sort command in a script or On Reset trigger could give you what you're looking for.

Table.sort

Tablesort(Variantcolumns ,VariantsortDirections = 0 )

Parameters

columns The column or columns to sort.
sortDirections The directions each column should be sorted. 0 is Descending and 1 is Ascending.

Returns

Table The table.

Description

Sorts table columns.

table.sort(1);
table.sort([1, 2, 3], [1, 0, 1]);

This basic sort command will sort numbers numerically, and strings alphabetically.

However adding a more "in depth" Sort filter seems like a good idea too! Thanks for the suggestion!
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Your Opinion Counts

Share your great idea, or help out by voting for other people's ideas.