Jump to content

Go to Related Record Issue


Recommended Posts

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

Link to post
Share on other sites

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. 

Link to post
Share on other sites

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

This is my OnLayoutEnter script:

1115312704_ScreenShot2020-09-07at9_14_32AM.png.5c5bf8e1143fa7ce22c832c72f4e08b0.png

and this is my customer layout:

1317000333_ScreenShot2020-09-07at9_22_01AM.thumb.png.eb26fbb975b939eebbaf8b13d4857e8e.png

This is my GTRR:

659828893_ScreenShot2020-09-07at9_26_17AM.thumb.png.9db5de6dcafc430dbf71a89f9979c1b0.png

 

Thank you!

 

Link to post
Share on other sites

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.

Link to post
Share on other sites

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.

 

Link to post
Share on other sites
  • 2 weeks later...

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.

Link to post
Share on other sites

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.

 

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Spidey
      Hi,
      I have two table: Invoice and Customer.  I like to have the total of all the invoice for a customer between certain date in the Customer portal that show all the customers, but I got a error when I try to debug..
      ExecuteSQL("SELECT SUM(I.TotalAmount) FROM Invoice I JOIN Customer C ON I._kf_CustomerID = C.__kp_CustomerID WHERE date(I.InvoiceDate) between date(C.SearchFromDate ) and   date(C.SearchToDate )" ; "" ; "" )
      I have an error and couldn't figure it out.  Thanks...
      KC


    • By Todd Dignan
      I have a client that has been using a send email script step  that brings up the outlook email client on the desktop.  This as worked for years no problem.  It has stopped work on 3 of 35 computers within the last two weeks.  I talked with there IT personal and they have assured me that no updates have happened.  The actual error is -
      Microsoft Office Outlook
      Either there is no default mail client or the current mail client cannot
      fulfill the messaging request.  Please run Microsoft Outlook and set it as
      the default mail client.
       
      I have double checked with system default  and Outlook's settings.  Both are set to default.
      The client is using the latest version of office 360's and the latest version of FileMaker 18 advance. Both 64bit.
      Any suggestions are welcome.


    • By tbcomputerguy
      I have an excel sheet that controls bills of ladings for a forestry company.  In the example you can see that there is lots going on with this Bill.  It has a payperiod, mill, truck that delivered it, etc.
      I would like setup a database to monitor this.  The fields CT1, CT2, Skid1, Skid2. PROC1, PROC2 are all contractor numbers.  There are 6 contactors.  The percentages in each line are the amount of the volume they performed  In the third line there is a value in CT1 only...they get 100% of the volume.  I can figure out most of this, but am stumped on how I can monitor when a contractor does multiple jobs..ie in line one, contractor 5, cuts and skids.  All 6 contractors could be involved in one BOL. Each one of these jobs, cutting, skidding and processing each has their own respective rate of pay as well.   I think i need a way to break down each line so that I can produce pay summaries for each of the contractors.  I had started this years ago, and thought I asked in a forum, but can't remember where.  Nonetheless, they stopped using multiple contractors per load...Now they have returned, so I am back at it.  So if this is a repost from years ago I apologize.  
      Thanks in Advance
      tbcomputerguy
       
       

    • By dancer5678
      I am using Filemaker Server 18 on Windows Server 2012 R2
      Been using it for years with no issues
      Currently when I log in to the console it is very sluggish.
      When I get to the Dashboard it shows No databases, then it auto refreshes and the database list appears.
      Within 15 seconds of scrolling the database list to open files the screen refreshes. This situations is happening over and over in a loop.
      Any Thoughts on what is causing this issue?
       
       
       
       
    • By stevaroni
      I get an error 3 when using a script to Export Records via WebDirect. Using FileMaker Server 18 and have tried both Safari and Chrome both with same results. I have tried using the temporary path, desktop path, and documents path. I have tried using with the automatically open and not. I have tried writing a tab delimited and comma delimited file. Does anyone have ideas I haven't yet tried?

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.