Question

Dynamic sorting table values in modern designer

Forms Version 11

Updated February 27

asked on February 27

I currently have a table that populates via look up rules:

I would like to be able to sort by any of the available columns in this table. For instance I may want to sort by the status of the client in one case, by the order date in another.

Instead of having to go into the look up rules and update the sorting there, I was hoping to find a more dynamic method using javascript and wanted to see if anyone has successfully implemented something similar in the modern designer.

0 0

Replies

replied on February 27

My work around on this is to create multiple tables that show the data in different ways and use custom html buttons or a radio button field to allow the user to choose how they want to see the data. Doing that with dates would be hard, but you could at least do years and then use SPs to sort SQL.

3 0

replied on February 27

Right now there isn't an option to sort a table yet either manually or through code outside of the lookup rule itself. We are definitely interested in adding that.

For now you could try some of the table filters? That should work well for status at least, probably more difficult with dates

1 0

You are not allowed to follow up in this post.

Question

Question

Dynamic sorting table values in modern designer

Replies

Sign in to reply to this post.