Jump 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.

GTRR from a portal

Lizzy
in Relationships

Featured Replies

Hiya,

I've got three tables; Table 1 is Events & Table 2 is Participants. Table 3 which links them all is Registrations. Using the Missing Manual book, I created this database as a data tunneling interface...

Each have portals on the layout. Layout 1 for Events lists in a portal, the people attending the event. Layout 2 shows the Participant details and then lists all events they've been at.

On the Participants layout I go go to the related event, and the script is working fine. On the Event layout, I can't go to the related participant record. It comes up with an error saying it's can't run script as the target is not part of a related table.

Can anyone help!

Thanking you ;)

General troubleshooting guide for GTRR:

Note the table occurrence (TO) of your layout.

Note the TO of your portal.

Note the TO of your GTRR target.

Now look at your relationship graph. Do you have a line from your layout TO to your portal TO to your target TO? You may need to add another Participants TO to your graph that is linked to the portal's TO.

General Troubleshooting for Related Records.

Oh, I had never realised this was the true meaning for GTRR :)

Haha, must have been a subconscious wording choice (although you didn't quote me exactly -- my original wording was more of a recursive acronym).

Create an account or sign in to comment

https://fmforums.com/topic/51430-gtrr-from-a-portal/
Go to topic listing

Important Information

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

I accept

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.