SetRepeatigFieldToText(Repeating Field; Text)

[Raybaudi]

Hi to all,

Can anyone make this function ?

I'll pass a text field and each letter of the text will go into a position of the reapeting field...

It's possible to make this function?

I need it to center text into a form with some predefinited square !

Thanks

[comment]

You don't need a custom function for this. Simply make your repeating field a calculation (result is text) =

Middle ( Extend ( textfield ) ; Get ( CalculationRepetitionNumber ) ; 1 )

---

Woops - if you have version 6 as indicated, then this will not work for you (and neither will a custom function). You can still make it work by using another repeating number field as an index.

[Raybaudi]

Hi, Comment

very, very, very good

Thank you very much.

[Raybaudi]

Hi, Comment

as you supposed I serched for FM7, so your replay was very good for me.

Can you send an example for FM6, because I can't make it to work ?

I ask too much ?

[comment]

I only have FMP4, but it should convert fine.

repeaterLookup.fp3.zip

[Raybaudi]

Hi, comment

obvious !!

I still can't understand why I was't able to make it work without your precious help.

Many, many thanks

[Andy Mohan]

Can you give a similar solution for getting data from container field of multiple records in a different table/portal/layout into a global repeating field in another table/layout.

Thanks

Anand Mohan

[comment]

I am afraid this technique requires the target to be a calculation field.

You could use another repeating field as key field, and define the target as a lookup. Each repetition will lookup "its own" content from the related record to which the corresponding repetition of the key field points.

But why not simply display the data in a portal?

[cjaeger]

Caution - lookups with repeatung fields can sometime yield inconsistent results in different FileMaker versions. A simple calc field would do, though

[comment]

Could you elaborate, please? On both points.

1. I have used repeating fields to lookup information from different records over a single relationship in versions 3 and 4. I have skipped 5 and 6, and I find it works the same in 7.

2. If you have a simple calc that can do the same, please share.

[Ugo DI LUCA]

I wasn't aware of this lookup problems, but I would think yes a calc would just do fine here, specially now that a calculation can be a global.

[Ugo DI LUCA]

Hi,

Here's a quick example that allows to either set or reset a given value into a global repeating field.

SetRepGlobal.fp7.zip

[comment]

I am afraid we are not on the same page here. The question was how to get data from multiple records in one table into a global repeating field in another table.

[Raybaudi]

Also includes a tip to react based on the Active Field Name without a script...

beautiful !

[Ugo DI LUCA]

Hi,

The fact that the data resides in another Table shouldn't be a problem as long as you use a related calculation.

As for getting multiple records at once, it may be effectively difficult to achieve but surely not impossible I'd think

[comment]

I am careful before saying "impossible", so I'll just say I haven't got a clue. Here's a demo showing the difference between a real lookup and a calculated one.

If you have an idea how to make the calc field react in the same way, I'd love to hear it.

multiLookup.fp7.zip

[Ugo DI LUCA]

Hi,

Not sure this offers something more than your first approach though...and actually couldn't work with containers at all.

For containers, you should be using FM7 recursive way so that it gets filled progresively, but this might need some other fields indeed.

multiLookup_Calc.fp7.zip

[comment]

Ok, so not not impossible.

But... it is a dirty trick: instead of getting one, you are getting them all, then picking the one. I think that with a large amount of records the difference would really stick out.