Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Trouble with repeating fields

Beno
in Calculation Engine (Define Fields)

Featured Replies

Hi everybody !

I have troubles with repeating fields.

1. How is it possible to know how many repetitions of a repeating fiels are used ?

2. I would like to insert a value into the Xth repetition of a repeating field. How is that possible ?

3. I also want to know if a specific value is present in the repetitions of a repeating fields. How can I do that ?

Thanks a lot !!!

  • Author

Well, that's what I call a precious help.

I haven't tried everything yet, but it seems like my problem is solved.

Thanks a lot. These fields are a real pain in the *** ;o)

If you're having all these problems with repeating fields, then the best advice is to ditch them. Filemaker went relational with version 3, and that was quite some time ago.

  • Author

I would like some more precisions concerning question 2 ;o)

I'd like to insert a value in the Xth repetition of a repeating field, but the other value of that field are not enterred by a lookup. Is there a way to do it without defining a lookup. By the way, I didn't find the Sample section (sorry blush.gif/)

Thanks a lot

Version: Developer v6

Platform: Windows XP

  • Author

Ok, I found the sample section and the example of Ernst.

My problem is that the repeating field is again set by a lookup.

Isn't it another way :

blush.gif

Version: Developer v6

Platform: Windows XP

Well,

You may trigger a lookup when needed and still manually fill the field.

At wish, as in any other lookup defined field... confused.gif

  • Author

Ok. Even if the value I want to insert depends on the data I entered in the repetitions of the field ? In fact, I enter all the values in the field and then I would like to auto-enter a value at the end of the repetitions, depending on the current values of the repetitions. I'm afraid that a lookup will crush and replace all the values of the field. Tell me if I'm wrong blush.gif

  • Author

Well, thanks a lot for your time and your help, which were very useful !

I will try to implement this. see you next time ;o

  • 3 months later...

BruceR,

While it

Hi,

You don't give us too much information about the exact data you're dealing with, and why you'd need that many relationships, but...I agree repeating fields are very handy when it comes to reporting and statistics.

As a way of distilling or reporting on data that is already properly normalized, repeats can be extremely useful and I'm quite aware of that. That doesn't seem to be the case here, and most people who ask about repeats haven't mastered the important basic relational concepts. Repeats have become even more versatile in FM7 and that's good if properly understood.

Create an account or sign in to comment

https://fmforums.com/topic/20466-trouble-with-repeating-fields/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.