Hi,

I have a solution in which I need to put the value in a portal into a repeating field. I have a portal with 5 records. 3 of which have a number from 1-10. So record 1 have value 1. It need to go into a repeating field in the 1 slot. Related record 2 have a value of 3 so it need to go in the 3 slot of the repeating fields. Get the picture. I am trying different variations of getnthrecord, get(calcuationrepeatnumber) case and extend calcs, but I am not getting all the parts in the right place.

Seraph_nyc

I am not sure why you would want to do this as you will only be limited to the number of repetitions whereas the related records can be more.

Case ( IsValid ( GetNthRecord ( child_show::pkChildID; Get ( CalculationRepetitionNumber ) ) ); GetNthRecord ( Extend ( child_show::pkChildID ); Get ( CalculationRepetitionNumber ) ) )

Hi thanks,You idea works but the portal has two records. I want to get one of the numbers in the record to match the repeating fields. Look at the photo there is a portal in the top middle with a 10 and a 4. I want to put that date in the 10th and 4th repetition. I will take advantage of the is valid calc.

Kaostika

Edited March 15, 200817 yr by Guest

Please state your version. Your profile says FMP 7, yet you speak of GetNthRecord().

What is the purpose of doing this? Perhaps there is a better way to approach what you are trying to do.

Also as Michael stated earlier, please update your profile with your current version.

It is for a gannt type chart. I can use portal records to define a repeating field. In this way I think I can better control the look of the fields.

I use 9 on 10.5.2

Edited March 15, 200817 yr by Guest

This is not going to be simple, so perhaps you should revise your strategy. Unfortunately, your purpose is not clear enough for me to suggest an alternative (the fact that it is for a chart doesn't say much).

In order to get exactly what you said, each repetition needs to find the corresponding value among ALL related records. This is a recursive calculation, and it needs to be performed individually for each repetition. So we need a custom function here.

Other ways to do this would be (a) a lookup and (: a looping script - but both would have to be initiated by user, while the custom function is more or less automatic (a screen refresh might be required if you modify the portal values).

See the attached file. Note that if two or more related records share the same rank value, only the first one (in the sort order of the relationship) will be returned.

GetMatchingValueCF.fp7.zip

Hi Comment,

This worked! It is what I wanted exactly. There are a lot of times when a user has a form and I need to make it into a repeating field. Portals, are very flexible, but sometime it need to be a rock.

Kaostika

Here is what I was using repeating fields for. The ends of the fields will be mask so that the rounded edge end in the right places. A combination of repeating fields and portals to create a 2 week progress calendar.

Another option is a train of mergefields in the background color as well as the colors. The bars are created out of char "g" in the webdingsfont.

Perhaps you should take a look at the way it's done here:

http://www.seedcode.com/ccp51/cgi-bin/cp-app.cgi?usr=51F6635914&rnd=8943280&rrc=N&affl=&cip=83.73.255.170&act=&aff=&pg=cat&ref=CCGantt7

--sd

I finished it. I use case functions to turn of the container when the date runs out of range.

Kaostika

Hi, I am going to try the webdings as you suggested. They are better than the container since I can control the color better.

There are more benefits to it, say you network a solution, relying on the font's implementation on client-side instead of ushering containers over the protocol should be somewhat faster, unless you use a single pix in each of your master containers, and then use the local platform to stretch this single pix to cover the entire container field.

I can't tell if you might be abel to pull it off in a vector image graphic near, but maxing out the fonts seems less effordless??

--sd