Go to Related Record Issue

[Pio Soto]

Hi,

My issue is that my customer layout has a script trigger on LayOutEnter that sorts my customers portal list by "Active" customers,

but when I do a go to related record from another table say from quotes or any other the customer layout does not load that customer

or show my related customer because the OnLayoutEnter script trigger changes it, I would like it to go to the related customer and also sort it by "Active"

on the list.

Hope someone can help me with this.

Thanks,

Pio

[bcooney]

If your customer list has an OnLayoutEnter sort, that should not affect the found set. When you say “sort,“ do you instead mean find active?
 

also, gtrr from quote to customer would typically end on a customer form view. The trigger for active wouldn’t make sense on a form layout. 

[Pio Soto]

Hi, sorry, yes meant find active customers and the sorts by name

This is my OnLayoutEnter script:

and this is my customer layout:

This is my GTRR:

 

Thank you!

 

[Steve Martino]

In your script, after entering find mode, you shouldn't use both  'Set Field' and Perform Find [Restore].

I'm also confused as to what you want, and what it is doing/not doing.

[Pio Soto]

What I need is that when I go to related record it shows active customers only and it goes to the related record on my customer layout, but if I go into my customer layout from the navigation bar I wanted to have my customer list show only active customers and scroll to the first record.

 

[Pio Soto]

Sorry, I was not making myself clear, what i need is that

my Go to Related Record script cancels or overrules my On Layout Enter Script.

Thank you.

[comment]

If you like, you could make your Go to Related Record script do something like:

Set Variable [ $$disableTriggers; Value: 1 ]
Go to Related Record [ ... ]
Set Variable [ $$disableTriggers; Value: "" ]

and then wrap your OnLayoutEnter script in an If statement:

If [ not $$disableTriggers ]
# DO THE ACTION
End If

Personally, I would prefer to script the navigation so that a script trigger would not be required.

 

[Pio Soto]

Thank you! that works great.