script to enter info in portal

[mleiser]

Hi. I need to do the following. I have a portal with, say, three fields per line. I want to give the user a button so that it will go to a script and put info into one of the fields in the portal. How do I have a script that will know how to go to a field in a particular line in a portal, or rather a field in a particular record in a portal.

[bcooney]

I'd do this: See demo attached.

EditPortalRow.fp7.zip

[mr_vodka]

You can go to a specific portal row and then use go to field to get to the field that you want.

[mleiser]

That works. Thanks. Now I just wish they'd have portals within portals. It would simplify things tremendously.

[bcooney]

Would it? Maybe Excelisys' Hierchical Portals is worth a look. However, I really don't know what your need is.

[mleiser]

In short I have 3 tables. One is Family, one camper, one transportation. Each family has multiple campers, each camper can have separate transportation records, one for am and address and one for pm and address. I have a portal for campers within family. I would love a portal within the camper portal with the two transportation records.

Mike

[comment]

Well, you cannot have a portal within a portal, but you can get very close by using a portal to the transportation table, "grouped" by camper - see an example here:

http://fmforums.com/forum/showpost.php?post/266405/

[mleiser]

How about if I ask it this way. Can I have a layout that has family info on top, then a portal that has each campers record info (so far as I have it set it right now) and then if you click on a portal can I have fields on the right side of the portal (outside the portal) that give relevant information about the camper that's not in the portal. So if I click on Johns portal record, on the right side of the screen you see Johns info. Then I click on Susans portal record and on the right side I see all the info for Susan?

[comment]

Of course you can:

http://fmforums.com/forum/showpost.php?post/333539/

[mleiser]

This is incredible! Thank you so much. I just used this for my other portal within portal problem. I use the same temporary key for another portal that has the bus information. It seems to works like a charm. Needs more testing. In any event thanks alot!

[comment]

I use the same temporary key for another portal that has the bus information.

Of course.

[mleiser]

Ran into this issue. In your solution the name in the portal (the only field) is also a button that passes the key to the variable. That's great. However, the portal that I use has numerous fields. How do I get the user to push the right field in order to set up the variable? Do I have to make all the variables in the portal a button that does the same thing?

[comment]

You can place a button behind the fields in the portal.