Home › Forum › Working with Tables › Sorting Table
Tagged: sort tables columns
This topic contains 5 replies, has 0 voices, and was last updated by samldiop 8 years, 7 months ago.
- AuthorPosts
- July 11, 2012 at 7:44 pm #1097
I have a table that is in a form and pulls information from another form. Is there a way to sort data in the table (one of the column is date, and that is the one I want to sort by)?
July 11, 2012 at 10:44 pm #6180Data lists in reports can be sorted by columns, tables in forms cannot.
July 11, 2012 at 11:43 pm #6181That’s what I was thinking, but wasn’t sure.
Thanks for the quick response!
July 12, 2012 at 5:24 pm #6182Here’s a quick-and-dirty test form I came up with that will sort number or date columns in a table:
//www.dropbox.com/s/uus4rw7odyv7tp0/Sort%20Test.pf
Just click the + button on the table on the left to add rows with random numbers and dates, then click either of the Sort buttons to sort them in the table on the right. I haven’t figured out a way to sort strings yet.
July 19, 2012 at 3:03 pm #6186pmeidinger, I like that your tables add random values upon adding a row, that’ll help me do future testing : ). The sorts are very nice as well, I did a sort in the past but it’s extremely ugly compared to yours. Thanks for sharing this!
It would be great to have this as a feature in the future though, so we don’t have create individual behaviors for each table.
July 19, 2012 at 3:17 pm #6187As an additional note, taking your numbers sort, the second “Last Behavior was Successful” branch can direct towards a few more statements that Copy the Sorted table to the Original table, in case you want the original to be sorted as well.
Thanks again for sharing this, it’s very elegant!
- AuthorPosts
You must be logged in to reply to this topic.