Using Get(ActivePortalRowNumber)

[Tim Mann]

I have been using FileMaker since 4.0, but have not used portals. How can I find the active portal row and paste it into a global field on the local database?

[Ron Cates]

Set Field [YourGlobal; Get ( PortalRowNumber )]

[Tim Mann]

Thanks, that's what I thought but it doesn't work. The global field is always blank. I even tried writing a script to copy get portal to paste, no good. I tried a script if statement to check to see if the active row number was being acknowledged: when using the Script Debugger I could step throught and see the row show up in a dialogue box, but the script would not act upon it.

I am wondering if the portal is not active anymore once the script is running.

[bruceR]

I have been using FileMaker since 4.0, but have not used portals. How can I find the active portal row and paste it into a global field on the local database?

What is it that you are actually trying to do? And can you post a copy of your file? You cannot copy a portal row anyway, and getting the row number also does not really accomplish anything.

[Tim Mann]

It would be difficult to post my file because there are 6 related tables that affect the layout I'm working on.

The layout allows the user to select an item from a list displayed in a portal. I need to bring multiple fields from a row in the portal to the page. Copying the first field works okay, but when the active object is not the portal, the portal row is lost. When trying to copy the second field I need the portal row number of the first field.

[bcooney]

Sounds like you're trying to setup a Viewer:

http://www.fmforums.com/forum/showpost.php?post/289092/

[bruceR]

It would be difficult to post my file because there are 6 related tables that affect the layout I'm working on.

The layout allows the user to select an item from a list displayed in a portal. I need to bring multiple fields from a row in the portal to the page. Copying the first field works okay, but when the active object is not the portal, the portal row is lost. When trying to copy the second field I need the portal row number of the first field.

I don't know why you think related tables have anything to do with a problem in posting the file. And NOT having this information make this whole exercise nearly pointless and adds to the burden of trying to figure out what you are talking about.

All the more reason to post the file(s).

Sounds like a design in serious need of attention.