Hi there

I have portal which has a field with a text description. I am wanting to combine all these descriptions in another table. Which will be a summary description for my quote

I presume there is some sort function/script I have to set up to make this work

Cheers

D

ps/ I don't think I explaining my self very well

What wonting to do get some text from a number field in portal and combine them in other field

hope this helps

Cheers

D

Edited June 1, 200718 yr by Guest

Hi,

For FM7

Create a dynamic value list (from field) to show values from related quote items. Then create calculation field in Quotes table using the ValueListItems(filename,valuelist) function.

attached is example file for FM 7.

For FM 8.5

Create calculation field in Quotes using List(field) function.

Quotes_M.zip

Hi There

thanks for suggestions, I under stand what you are saying with using the "ValueListItems" function. It sounds what I am wanting to do but when I try implement it does not seem to work. please see attached the FH 8.0 file you make may be able to see where I am going wrong

thanks

D

BD_job_tracking_v3.fp7.zip

You put the name (as a string) of the table occurrence in the ValueListItems() function. It's not the name of the TO you want, it's the name of the Value List itself.

The TO relationship is used to filter the value list, values from a field, related values only, starting from Quotes. But it is the name of the value list that goes in the function. It is a text value, so do NOT rename the value list later, or it will break.

The results of ValueListItems will be alphabetically sorted. If you need otherwise, then say.

(P.S. I wrapped the result with Substitute ( result; ¶; ", ") to convert returns to commas; in case that's what you want.)

BD_job_tracking_v3.fp7.zip

Hi there

Fantastic, the light bulb finally when on for me when I set up the "value list"

Thanks Guys, really appreciate you help

thanks D