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.

Placing a value list into a repeating field

Featured Replies

One database, one field called Project Name, 6 records:

2 of the records have the Project Name of ABC

1 records has the Project Name of EFG

3 records have the Project Name of HIJ

I created a value list that looks at the Project Name field, so the value list contains:

ABC

EFG

HIJ

Is it possible to take the contents of the value list, and place them in a repeating field so that the first repetition contains ABC, the second repetition contains EFG, and the third contains HIJ?

I want to create a calc that looks at the first repetition and tries to match it with the contents of of the Project Name field.

I really strongly advise that you don't use repeating fields. You can put data in them, but it's extremely difficult to do anything with it afterwards, like sorting, summarizing, reporting, appending, inserting, deleting. If you don't think you will need to do any of these things with the data in the repeating fields, then go ahead and use them, but you are almost always better off using a portal to a related file.

But, to answer your original question, you can make a looping script that gets the value list items using the ValueListItems() function, parses it into individual items by looking for the paragraph separator between each item and then insert them into the appropriate field (preferably new portal rows rather than repetitions of a repeating field).

Create an account or sign in to comment

Important Information

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

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.