I ve been trying to come up with a formula in order to use portal

information. Said portal displays info just fine but now I need to use that info in the very table where that portal is located. In other words, I can copy and paste the portal info into the table field that contains a formula that returns a result ,manually with no problem. I just want instead of copy and paste that the field gets portal info automatically.

I hope i am explaining myself correctly. Thanks in advance!

Usually, the portal is a 'child' table related to the 'parent'. You create the layout based on the parent table, then draw the portal. If you've done this, then you can create a calculation field in the parent table that references child fields and place that calculation on the layout (outside the portal).

Are you looking to create a total of a portal field?

What you want is not clear to me.

Can you not just have the "result" field as a formula/calculation based on the field in the same table - without copy and pasting from one field to another in the same table?

Thank you for your prompt response and interest. I tried creating a formula in the parent table but was unsuccessful. The simplest I tried was field in portal = field in table. That makes it work, but only one result came out of other 10 rows in the same portal. These are names. More complex calcs, i couldn't come out with.

Try:

List ( Child::Somefield )

you guys move fast!. That worked, however, now all of the names that I wanted are in one field as a list. The field is a repeating field. Anyway to grab a row in the portal at a time, copy that row, and into field 1, then 2nd row into field 2 and so on?

I'm still confused as to what you want ...

(and I would avoid repeating fields)

Why don't you post a stripped down copy of your file so that we can see what exactly it is that you need rather than having to deal with abstractions

I am not sure what you want either. Which field is repeating? And, most importantly, what is the purpose of this?

Thank you guys, I believe I have figured my solution. I need to create a calc field with a get record function so that I can stripped the portal of each name in each row so that those rows are reflected in 7 or 10 fields. Those are the amount of names the portal will contain on each day of the week. I am sorry I can't explain it better but you all were a good inspiration anyway!

Thank you 4 y/ reply. I will try to be more graphic:

Table A contains a calculation field (actually 10 fields) that depend on dynamic data (changes all the time) that is contained within a portal from Table B. Intended it is that if the portal info changes, Table A's calculation fields do change too. In other words:

Table A's calculation field is as follows:

If(GetNthRecord (Mon::hrswkam BIS2; 1) < 7.5;GetNthRecord (Mon::hrswkam BIS2; 1);

If(GetNthRecord (Tues::hrswkam BIS3; 1)< 7.5;GetNthRecord (Tues::hrswkam BIS3; 1);

If(GetNthRecord (Wed::hrswkam BIS4; 1)< 7.5;GetNthRecord (Wed::hrswkam BIS4; 1);

If(GetNthRecord (thu::hrswkam BIS5; 1)<7.5;GetNthRecord (Thu::hrswkam BIS5; 1);

If(GetNthRecord (Fri::hrswkam BIS6; 1)<7.5;GetNthRecord(Fri::hrswkam BIS6; 1);

If(GetNthRecord (Sat::hrswkam BIS7; 1)<7.5;GetNthRecord (Sat::hrswkam BIS7; 1);""))))))

The above represents 1 field that will get portal info in line #1

for each day of the week ( each day of the week is a portal)

Simplifying the idea, the calculation is:

if(portalfield<7.5,portalfield,""). As simple as that. This action is repeated for each line into a each field for each day of the week.

You see, the calculation works but it doesn't get triggered by itself when the portal data changes leaving old data in table's A calculation field. That, I tried refreshing the window but it just doesn't work.

Any help or suggestions will be greatly appreciated.

Thanks in advance.

Nd

This seems to be a duplicate post:

http://fmforums.com/forum/showtopic.php?tid/212970/post/348748/#348748