Jump to content
Salesforce and other SMB Solutions are coming soon. ×

List function pre 8.5


Recommended Posts

Is there an equivalent function as List(field) from 8.5 in 8 or earlier? I have 8.5 advanced but everyone else on the network has 8.





Link to comment
Share on other sites

Not exactly, but there are methods to get something similar, depending on the purpose. If you can say what you're trying to do, we might have a suggestion that fits.

Link to comment
Share on other sites

I am trying to populate a list of "delivery numbers" combined on a pallet. I have a selfjoin relationship based on a calculated value.

Shipment ID&"000"&Pallet ID.

The Shipment ID is a unique number assigned to particular load. The Pallet ID number is selected by the user to group delivery numbers together on one pallet. These numbers are recycled every delivery cycle( the first grouping starts at 1, 2nd is 2, and so on).

I added 3 zero for padding. They are not necessary.


If( PALLET ID > 0;"COMBINED DELIVERIES:" & ¶ & List ( SIDPALLET::Delivery num);"")

Link to comment
Share on other sites

In this case, define a value list based on a field, selecting the related Delivery Num field, showing "related values only", from the context of the parent TO.


Then use something like this to get the listing:

If( PALLET ID > 0;"COMBINED DELIVERIES:" & ¶ & valuelistitems(get(filename);"your new value list name"))

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use