I have an invoicing file with several fields (item number, description, unit price, extended price) in a portal. It can be automatically sorted by setting the "sort related records" in the portal relationship. But I want to set buttons above each heading, so that I can click on whichever heading, and the fields in the portal will be sorted by that heading, just like in table view. For example, clicking on the button for "item number" will cause the fields in the portal to be sorted according to item number. Likewise, clicking on the "description" button will cause the fields in the portal to be sorted by description.

Does anyone know of a non-complicated way to do this?

Hi, shellas !

Here is attachment!

The idea is by Getfield function you send yor values of column(sorting field) to one calulated field, by which you sort your portal.

Sort_In_Portal.zip

Thank you. I am currently looking over your file and will try to incorporate this method into my present solution.

Keep in mind that number, date, and time fields will need a little work to get them to sort correctly (rather than alphabetically.)

I have successfully incorporated this method into my work, but I realized that it doesn't quite do what I intended. The item number and description fields are set in a portal, with a script to pull up the correct price for each item based on the unique item number. When I sorted each field, the prices invariably got all mixed up. Therefore, I am actually looking for a way to sort each portal row based on the item number field or the description field. Anybody knows how to do this? Thanks.

Here is one of ways! In attachment

Sort_In_Portal.zip

Thank you aaa. I have downloaded your file and am still analyzing it. It got sorted fine at first (meaning the item number along with the description) but for some reason afterwards it wouldn't sort properly (meaning the item number got sorted separately from the description). I'm also trying to get the fields (price, quantity, extended price) which are included in the same portal to sort along with the portal row.

I think I'm missing something somewhere and I'm still analyzing it. But you've been very helpful. Thank you so much. Of couse if you or anyone else can give me some more tips or guidance I would really appreciate it.

Can you attach wrong part of your file?

Hello aaa,

Thank you very much for your willingness to help. I've tried retrieving just the "wrong" part, but the file is linked to 3 other files. Since all types of calculations are embedded within I have not been able to extract just the part pertinent to my query. I will keep trying and update you when I am successful. I mean no offense and hope that you understand.