Perform Find in portal

[ron G]

I have FM 11 Adv (and won't get FM12 until they speed it up)

I have a portal table that consists of:

MembershipType

MM Dues (Yes/No)

Assmt (Yes/No)

PM Dues (Yes/No)

This table is in a portal and it works. But, when a user adds a new row to the portal and after they exit the MembershipType field, the portal sorts itself so that my 'new' record that was at the top is now 6th (for example).

Question: "Is there a way to do a Perform Find in a portal and after a successful 'find, use get(activePortalRow) to get the portal row where the find was successful? (I want the user, after typing in a new MembershipType, to continue in the same portal row to answer the yes/no fields)

When I run my script with Perform Find it gets a as a get(foundcount). (Which makes sens because there is only 1 value for each MembershipType.)

If I open a 2nd window and put the portal table layout in it, I can 'find' successfully but it will only 'find' the one record it should have found. In this case, the foundcount =1 and I don't have a way to translate that found record into the correponding position in the portal. Ideas?

Thanks

Ron

[Vaughan]

What do you mean by "perform find in a portal"?

A portal sits on a "master" record and displays the related records. When a find is performed in a portal, the resulting found set is those *master* records that have one or more *related* records that match the find criteria that was entered into the related field. You could use conditional formatting to highlight the portals that match the criteria, but then you'll need a way to capture the criteria before performing the find. A LOT of work...

I am re-reading your post and I realise that I have no idea what you're talking about. :-(

Please describe what you want to achieve NOT what you're current doing to achieve it. Use real examples, don't try to simplify. There is a couple of hundred year's worth of FMP experience here on the Forums, nearly every problem people have has already been solved by somebody. :D

[Ocean West]

The portal row should not sort until you commit the record (Click out of the portal) if they type each value and tab to the next field in the same portal row. or click on a button it should keep it in focus.

i am doing this exact same thing.

http://screencast.com/t/ATAkBvbpVjhs

[ron G]

The portal row should not sort until you commit the record (Click out of the portal) if they type each value and tab to the next field in the same portal row. or click on a button it should keep it in focus.

i am doing this exact same thing.

http://screencast.com/t/ATAkBvbpVjhs

Nice video. Thank you.

My problem is that I can not rely on the users to NOT click out of the portal row before all the values have been selected. (Each item is a Yes/No field). As you noted, when they click out of the portal row, it sorts. In this case, the problem is to locate the portal row of the new MembershipType that is now alphabetized in in the portal. I don't think FIND works on a portal. I suspect I will have to resort to a Briandunning custom function. Any ideas?

[Ocean West]

Take the creation of the related record out of the portal all together...

members.fp7.zip

[ron G]

Take the creation of the related record out of the portal all together...

members.fp7.zip

Thanks for the .zip file. I will look it over tomorrow.

In the mean time I see that you are using FM 12 Advanced. i have read a *lot* of complaints about it being extremely slow; vis a vi FM 11. What is your experience?

[ron G]

I got it to work.

$$NewType = MembershipTypePopup::MemType (The newest membership type)

First I loop through the table the ViewList is based on with

set variable[$$MemTypes; Value:$$MemTypes&MembershipTypePopup::MbrTypes&P (P=paragraph symbols)

Goto Record/Request/Page [Next; Exit after last]

Then I used a Brian Dunning function $$Rank=GetItemRank to look into $$MemTypes and tell me where in the listing $$NewType is located.

Now it is just a matter to return to the portal and..

Goto the portal row by calculation ($$Rank)

The BD function is here: http://www.briandunning.com/cf/547

Thanks to all for the help. It *IS* appreciated. I hope this helps someone else.