Howdy all:

I'm in Stupid mode today--I can't see how (in the attached solution) the Product portal is being filtered after choosing a category. I see that the layout has a script trigger assigned so that upon record load the script captures the record ID in Category and pushes it into a global field. Still, I can't see how the Product portal is being filtered--there's no filter assigned in the Portal Setup box, so...?

*sigh* This is giving me a brain hernia--time for a Tylenol.

Thanks in advance for your help.

Nested Portal.fmp12

Something is wrong with your upload (or with the forum?). The file cannot be downloaded and I get an error:

{
  "code": "unauthorized",
  "message": "b2ContentDisposition is prohibited for unauthenticated requests",
  "status": 401
}

I flagged your post for moderators attention. Meanwhile try to re-post the file.

 

21 minutes ago, 21st Century Man said:

there's no filter assigned in the Portal Setup

If no filter is specified in Portal Setup then the portal is not filtered. Possibly the filtering (if any filtering takes place) is done through the relationship itself. Or maybe there is another portal.

 

Thanks for the heads up. Here's the file again...but after trying to download it I'm getting an error message, too.

 

I don't know (about the relationship)--it's a simple primary to foreign key connection. : |

 

Nested Portal.fmp12.zip

Edited May 30, 2025May 30 by 21st Century Man

Please be aware we currently have a bug with our site with downloads. We recently moved to storing our files on BackBlaze B2 bucket, which took over a week to move files over, without realizing the bug. I don't have an ETA to resolve it. I would recommend uploading to https://wormhole.app and post the link until we can resolve this. 

My Apologies 

Stephen

Thanks again. Here ya go: https://wormhole.app/MbKQ1k#Y2JFXhf4x4rXuZkB_cCQ5A

This is a very simple arrangement.

The left-most portal, where you select the category, is a portal that shows records from the current table (Category) - a.k.a a list-detail layout:
https://help.claris.com/en/pro-help/content/creating-portals-list-detail.html

Selecting a category in this portal causes the corresponding record to become the current record. And the portal to the Product table shows only records that are related to current record.

 

Edited May 30, 2025May 30 by comment

Ah! Thank you VERY much for the education!