Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Trouble with script to get a found set

gaby78
in Script Workspace and Script Triggers

Featured Replies

Hello:

I have a standard Invoicing DB with Customers-Invoice-InvoiceDetails-Products tables

I am on Invoice layout with InvoiceDetail portal. What script do I need to get the following result: when I click on a line item (say, product P1255) in the portal I want FM to show all the instances where this customer purchased product P1255. I can manually go to InvoiceDetail enter find mode, type in customer Id and product Id and get the desired found set. But I am having trouble in a script getting the customer id and product id over to the InvDetail layout starting from the Invoice layout.

Any suggestion will be much appreciated.

Try this:

Go to Related Record [ Product ; Some Product Layout ]

Go to Related Record [ Show only related records ; Invoice ; Some Invoice Layout ]

  • Author

It works.

Thanks Ender, much appreciated.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.