Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Sorting by different columns in Chem Tables
Options
Go to last post Go to first unread
Previous Topic Next Topic
JackP  
#1 Posted : Monday, June 26, 2023 11:56:50 AM(UTC)
JackP
Rank: Newbie

Reputation:

Groups: Registered
Posts: 7
Australia

Thanks: 2 times

Is it possible to sort by different columns in the Chem Tables section prior to excel export (i.e. LocationCode instead of Field ID)?
Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Nick Support  
#2 Posted : Tuesday, June 27, 2023 1:45:35 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 329
Canada

Was thanked: 29 time(s) in 29 post(s)

Hello Jack,

The Chem Table is sorted by the order you have the sample information fields shown.

If you want to sort by Location, simply drag and drop it before Field ID in the Sample Information menu.

More info is available in our knowledge base here: Chemistry Tables

Thanks,

Nick
Back to top
WWW
JackP  
#3 Posted : Thursday, July 6, 2023 2:23:07 PM(UTC)
JackP
Rank: Newbie

Reputation:

Groups: Registered
Posts: 7
Australia

Thanks: 2 times

Thanks Nick.

It would be handy to be able to sort by columns that aren't the first column before exporting to excel, and to have multiple levels of sorting. 

Originally Posted by: Nick Support Go to Quoted Post

Hello Jack,

The Chem Table is sorted by the order you have the sample information fields shown.

If you want to sort by Location, simply drag and drop it before Field ID in the Sample Information menu.

More info is available in our knowledge base here: Chemistry Tables

Thanks,

Nick
Back to top
Nick Support  
#4 Posted : Friday, July 7, 2023 1:40:10 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 329
Canada

Was thanked: 29 time(s) in 29 post(s)

Hi Jack,

If you wanted to do custom sorting, you could utilize one of the sample details columns that you aren't using to add your own custom sort order by entering a number for each sample (such as Sampling Method, Matrix Description, Sample Comments).

Use this as the first column in your table layout, and then hide it when you export the table to Excel.

Doing this you can essentially sort in whatever way you choose.

Thanks,

Nick
Back to top
WWW
JackP  
#5 Posted : Friday, July 28, 2023 11:40:58 AM(UTC)
JackP
Rank: Newbie

Reputation:

Groups: Registered
Posts: 7
Australia

Thanks: 2 times

Thanks Nick.

Hiding the first column would also hide the criteria, though understood that I could just delete those cells and shift left.

These are all minor issues, but it would certainly be beneficial not to require workarounds for sorting.

Appreciate your help
Back to top
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET