It's really cool how you can define a place to on the NAVIGATION tab of the Generic Inquiry (SM208000) screen for someone to navigate to. And having the option to open that place in a new tab, new window, etc. even even cooler. So thanks.
This idea is to make the Navigation functionality even better.
Currently, when you choose an option in the Navigate To field on the RESULTS GRID tab, it will always navigate you to that place for every row in the inquiry.
But what if you want to go to one place for some rows and another place for other rows. For example, maybe I create a list of all AR Invoices, but I want those from the Sales Orders module to navigate to the Invoices (SO303000) screen while those from the Accounts Receivable module to navigate to the Invoices and Memos (AR301000) screen.
What if the Navigate To field on the RESULTS GRID tab was a formula editor field like the existing Data Field? Then you could write a formula that dynamically determines which NAVIGATION option should be used. You might need to number the options on the NAVIGATION tab to make it simpler to write a formula that just returns a number for the navigation option that you want to use (it would make the formulas cleaner and easier to read).