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.

NumberListItems(listField)

TJ53
in Custom Functions Discussions

Featured Replies

Hi,

I wonder if there is already a custom function out there that does the following:

parameter: listField, that would be a field with a list of items, e.g.:B

oranges

apples

bananas

I would need the following result:

NumberListItems(listField) =

0001 oranges

0002 apples

0003 bananas

Any ideas? Thanks in advance!

Edited by Guest

The function itself could be rather trivial:

SerializeValues ( listOfValues )


Let ( [

countValues = ValueCount ( listOfValues ) 

] ;

Case ( countValues > 1 ; SerializeValues ( LeftValues ( listOfValues ; countValues - 1 ) )  & ¶ )

&

Case ( countValues ; SerialIncrement ( "0000" ; countValues ) & " " & GetValue ( listOfValues ; countValues ) )

)

See also:

http://www.briandunning.com/cf/677

However, if you need this you should probably keep the values in separate records of a related table, rather than in a single text field.

  • Author

Awesome, thanks a lot!

Create an account or sign in to comment

https://fmforums.com/topic/63919-numberlistitemslistfield/
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.