MacFileman Posted March 4, 2020 Posted March 4, 2020 Hey... thanks in advance for reading. I am using portals to display "Active" projects in my office. When you set up a portal, naturally, you set up a relationship and then you might set up a sort order, in my case, I am sorting by "Job Number." Unless, I am missing something or having a brain aneurism, which very well might be the case, I want to make a button to change the sort option on the fly. In my case, I would love to sort by "Due Date, Job Number or Customer" and perhaps with a button, but I just don't think that can be done...right? You set the portal up and the sort value is what you choose in the set up phase only. You might winding up telling me how to do this and it is so simple that I will be embarrassed and we can all laugh together. My back ups were to get creative with Tabs. Within each tab, each portal would be built with the sorting I predefine. Or I can do list views in an alternate layout, but truthfully, I love the way portals look work and feel and they work fantastically in web browsers. So, that's my evening! Thanks for reading, contributing and perhaps laughing with me. Mike
comment Posted March 4, 2020 Posted March 4, 2020 (edited) Basically, you have two options: 1. Use 3 portals, each defined to sort by a different field, and show only one of them based on the user's choice; 2. Sort the portal by an unstored calculation field, where the value is calculated according to the user's choice held in a global field/variable. Each approach has its own pros and cons. The two main problems with the 2nd approach are accommodating different data types and performance (these two are related: the more comprehensive the solution of the first problem is, the slower it gets). Edited March 4, 2020 by comment 1
MacFileman Posted March 4, 2020 Author Posted March 4, 2020 Thank you for the feedback. This is exactly what I thought, I just wanted to confirm that I was not missing anything before I altered course. Have great day!
Recommended Posts
This topic is 1794 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now