Find on specific cell of repeating field

[David Mars]

I am using a repeating field “Shopping Cart” to let customers note down whether they want to add a particular film shoot location photo to their ‘album’. This is not a full fledged Shopping Cart solution but does the job well except for one problem.

I have a script put a “Yes” in the Shopping Cart repeating field to put the photo in the customer’s Shopping Cart, where the repeating field is 1 if the account name is 314001, 2 if the account name is 314002, etc., as follows:

Set Field [Locations::Shopping Cart[Get (AccountName) - 314000]; “Yes”],

and another Script puts a “No” in the repeating field (it is a radio button), using the same approach:

Set Field [Locations::Shopping Cart[Get (AccountName) - 314000]; “No”]

The problem is that when I do a Show All, my Find is returning not just the “Yes” in the first repeating field (for the active Account Name 314001, who uses repetition 1 to store his information) but is also returning the “Yes” in the second repeating field (customer Account Name 314002’s Shopping Cart).

The Script step “Set Field” allows me to specify a calculation so that I can address a specific repetition to insert a Yes or No, as above. However, the Edit Find Request dialog for the Script step Perform Find lets me name the field “Locations::Shopping Cart”, and Criteria “=Yes”, but it only appears to allow me to enter a Repetition number such as “1” or “65”, rather than a calculation such as “[Get (AccountName) - 314000]”. I need to have a dynamically calculated repetition as I will have 4-5 customers on at one time (I’m just using the standard FMP Internet Web Publishing which supports a max of 5 customers at once.)

Does the Edit Find Request dialog box support a Find on a specific repetition of a repeating field, and if so, how can I do that?

Many thanks.

David Mars

[email protected]

[Raybaudi]

Hi David

the Set Field script step that allows to set a repeatition by a calculation isn't inside FMP 6.

So I'm assuming that you have 8 ( at least ).

What you ask for is possible by using the 3 steps:

Enter Find Mode

Set field [ ] <-- now you can enter a specific rep

Perform Find

...but searching a string in a repeating field shows all the records that have that string [color:red]inside one whichever rep

So, stop to use repeating fields ( in such cases ) and create a relationship !

[Lee Smith]

the Set Field script step that allows to set a repeatition by a calculation isn't inside FMP 6.

Do you mean?

Edited January 19, 2007 by Guest

[Raybaudi]

Hi Lee

exactly what I said: there isn't a way to set the rep by calculation, only a fixed number !

Look carefully: "Define Fields..." NOT "Specify..." :)

[Lee Smith]

Sorry Daniel, I'm not used to variables yet, and that was why I asked my question.

Now I see what you mean, all I had to do was to go to the next level and my question would have been answered. DUH,

Thanks,

Lee

[David Mars]

Thanks for the advice, I was hoping there was some trick to do a Find on a specific repeating field, I'll change my approach for that information.

David