Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Form: RunObject formXXXXX link question
jversusj
Member Posts: 489
Good day, all.
I have what i hope is a simple question with an apprpriately simple newb answer (7 year newb?).
Our users often link from the customer card to the sales quote form. By default, the MenuItem has a RunObject Form push action. When a user clicks this, they are taken to the first record in the recordset of related quotes. We have modified our system to never delete quotes automatically (only manual deletion, batch deletion allowed), so this often means a user is taken to a quote from 2007. They then have to make another click to go to the end of the record set (most recent quote).
Assume I have two quotes, 1 and 20. The current navigation always brings up 1. I have been asked to have the system automatically take the user to the most recent quote (20 in this example) when clicking the link, doing away with the extra click.
I initially tried to alter the sort order on the pushaction. I tried Ascending and Descending, and both take me to the same first record (1, although it is either first or last in the record set, depending on sort order). I wondered if there was a way to specify FINDLAST using a push action, such that I get to 20?
I already tested code written behind the OnPush trigger (do not use RunObject) and was easily able to get it to behave as desired, but I would prefer managing this with properties, not code. Am I doing something wrong, or is it not possible? Suggestions?
EDIT: Turns out my code behind OnPush is not working either. :oops:
I have what i hope is a simple question with an apprpriately simple newb answer (7 year newb?).
Our users often link from the customer card to the sales quote form. By default, the MenuItem has a RunObject Form push action. When a user clicks this, they are taken to the first record in the recordset of related quotes. We have modified our system to never delete quotes automatically (only manual deletion, batch deletion allowed), so this often means a user is taken to a quote from 2007. They then have to make another click to go to the end of the record set (most recent quote).
Assume I have two quotes, 1 and 20. The current navigation always brings up 1. I have been asked to have the system automatically take the user to the most recent quote (20 in this example) when clicking the link, doing away with the extra click.
I initially tried to alter the sort order on the pushaction. I tried Ascending and Descending, and both take me to the same first record (1, although it is either first or last in the record set, depending on sort order). I wondered if there was a way to specify FINDLAST using a push action, such that I get to 20?
I already tested code written behind the OnPush trigger (do not use RunObject) and was easily able to get it to behave as desired, but I would prefer managing this with properties, not code. Am I doing something wrong, or is it not possible? Suggestions?
EDIT: Turns out my code behind OnPush is not working either. :oops:
kind of fell into this...
0
Answers
d'oh!
fantastic. I had never used that property before, but it does exactly what I hoped. The only downside is that it applies to the form itself, so regardless of where the document is opened (from main menu, from customer card quote link), it will go to the last record. I don't think that would be a problem as 99% of quote access is done through the customer card, but I suppose that 1% could be a deal breaker. I will have to get sales department approval for that, but otherwise this does what they wanted. Thanks again!