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.

Go to ONE related record of several from a portal

Featured Replies

I feel I'm surely overlooking something obvious here, but I can't figure it out.

I'm uploading a sample file which is actually one of the starter solutions from FM12. I've added a layout "Popup - View Attachment", and a script "Popup - View Attachment". :)

I have a button on the Tasks Details layouts, Attachments tab to run my script.

I add two attachments, each a PDF file.

What I'm aiming for is to click that button and have ONLY the one record I'm selecting from appear in the new layout via my script.

What I'm getting is both related records opening. How can I narrow it to only the record that I click the button from? (Can I?)

Tasks.fmp12

It seems to be working as you describe on my Macintosh 

 

  • Author

I'm on PC - when I click the first PDF, it appears OK, because that's the record it shows in the popup layout.

If I click the second PDF, it still shows me the first PDF.

In either case, I can use the keyboard shortcuts to go to previous and next record to see all the related records.

Oh, I see what you are saying, both are going to attachment 1, and the second record is not seeing the second one? 

 Both attachments have the same number. shouldn’t the second one be 2?

  • Author

They aren't numbered in this file - you may be looking at the Task ID Match number which designates which task they are linked to.

Unfortunately, this example file does not put primary keys (ID fields) in every table.

There SHOULD be an attachment ID field in the Attachments table.

Then, your script could be set up to perform a find for the attachment ID of the record you clicked.

TasksMOD.fmp12

I placed the ids of task and attachments on both layouts to see what related record numbers were being shown.

  • Author

Thanks Bruce - that was the conclusion I was coming to as well. I just thought there might be a more simple way to "open this record I'm clicking on in the portal in its own window".

Create an account or sign in to comment

Important Information

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

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.