Setting Repeating Field Number with a Calculation

[ECK]

Is there a way to have a calculation field set the result of the calculation in the specific repetition field number? I have not been able to determine if there is a function to do what I want done.

[Lee Smith]

Why not use a relationship, repeating fields are old school for a lot of things we do today? Look at Getting the contents of a repetition in a repeating field

Repeaters can really make your development harder as you are finding out.

[comment]

Is there a way to have a calculation field set the result of the calculation in the specific repetition field number?

 

Could you provide a better explanation of what exactly you want to do, perhaps with an example? Right now I don't have the beginning of a clue.

[ECK]

Hello Lee,

 

I totally agree. I do not like using repeating fields and typically don't, but I am try to construct a Gantt chart of sorts. I am surprised that Filemaker does not have Gantt charts as an option for the Graphs and charts they do include.

 

I am creating a chart that will change the color of the repeating field through conditional formatting. When the start position and end positions are calculated I want to change the color of those repetitions and change the color of each repeating field between the start and end positions; basically giving me a colored section from Start to End.

[Raybaudi]

Try with:

Formula is:

Let(
R = Get ( CalculationRepetitionNumber ) ;
YourTable::Start ≤ R and R ≤ YourTable::End
)