understand & real world use of extend function

[imoree]

I am stuck with the extend function.

i have tried but no luck in getting anything to work.

Can someone take a look at my file & point me in right direction?

thanks,

extend.fp7.zip

[jdu98a]

It's not clear exactly what result you are trying to get in the example. Can you clarify?

Ouch, my reputation. Someone didn't like my reply.

Edited September 9, 2011 by jdu98a

[Raybaudi]

Can someone take a look at my file & point me in right direction?

Is it this ?

extend.zip

[imoree]

no. if someone clicks on the "ACTIVE REPETITION #" i would like to make sure and extend lets say a label underneath that with a regular field that i can put information in.

hope that makes sense.

[Raybaudi]

Not really. Which is in your mind the "ACTIVE REPETITION #" ?

[Tom Elliott]

I'm not sure what you're trying to achieve but I think all you need to do is change your script to the single step

Set Field [ NAME::labels; Get ( ActiveRepetitionNumber ) ]

[imoree]

I have concluded that using extend( ) function makes NO SENSE TO ME instead of just another repeating field , put some buttons behind the containers if you want graphics and call it a day.

WHY EVER should you use extend?

i dont see the need i guess until i have the need.. LOL

[Vaughan]

WHY EVER should you use extend?

If you're using repeating fields, to EXTEND the value of a single-repetition field across a field with multiple repetitions.

[imoree]

I have finally figured out extend .. OMG!!!

All it really does is :

1. if u r using it in a calculation

2. eg. (cost[5] * rate) { Where cost is a repeating field }

if you put rate as rate = 4. then your calculation will return cost[1] = 20 cost[2] = "" , cost[3] = ""; etc

if you use extend(rate) then ALL the repeating fields will use the rate number.

-i

[Vaughan]

Great.

But why are you using repeating fields? In 99% of cases a related table is better.

[imoree]

Learning all that i can while i can with Filemaker. { i am becoming an addict} Cant make art without knowing how to paint? At least that is what i say!!