Options

Form: RunObject formXXXXX link question

jversusjjversusj 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:
kind of fell into this...

Answers

  • Options
    jspoppjspopp Member Posts: 54
    Hi, take a look on the properties of the form you want to open up. There's a property called SourceTablePlacement which can be changed to Last, First, Record, Saved. See if this works for you. Good Luck!
  • Options
    jversusjjversusj Member Posts: 489
    jspopp wrote:
    Hi, take a look on the properties of the form you want to open up. There's a property called SourceTablePlacement which can be changed to Last, First, Record, Saved. See if this works for you. Good Luck!

    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!
    kind of fell into this...
  • Options
    jspoppjspopp Member Posts: 54
    Great to hear! Glad I could help you on this one
Sign In or Register to comment.