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.

Create a Value List from data in a Repeating Field

Ja5en
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

Hey all,

I'm sure this has been answered a dozen times or more, but how do I create a Value List from data in a Repeating Field?

Scenario: Its a repeating field of up to 10 colours, I want to then be able choose 1 of those colours from a drop down list .. but only choose from the values of repeating field of the current record, not all of the records in the database.

Any tips would be most welcomed. Thanks J

You will need to create a self join keyed on your primary ID. Then reference the repeating field of the Self Join.

However, I must warn you that using repeating fields usually means that you probably have a relational structure issue. Why are you using repeating fields?

It's been answered hundreds of times. And the answer is...don't use repeating fields!

Edited by Guest

Create an account or sign in to comment

https://fmforums.com/topic/65231-create-a-value-list-from-data-in-a-repeating-field/
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.