I am working with a multi value field in a form and all works great. The issue I am running into is my customer is exporting from a view into an Access database and they are have problems with Access sorting the values in the field. The values are separated by a “,” comma. I need to be able to get all the values and put then in to different fields i.e. value 1 insert into field 1, value 2 insert into field 2, value 3 insert into field 3 etc. I would like the code to be in the fields that will hold the new values if possible. Does any one have a suggestion? I need each value to be represented as a separate column hence the separate fields.
Subject: multi value field need to insert vales into separate fields
Well if the multivalue field is finite then all you need to do is use the following @Formula language in each of the new fields that you create for each item value:@Subset(mulitvaluefieldname;1)
@Right(@Subset(mulitvaluefieldname;2); 1)
@Right(@Subset(mulitvaluefieldname;3);1)
etc…
If the multivalue field is not finite you will have to write lotusscript to dynamically create new fieldvalues for each item in your list.
Subject: RE: multi value field need to insert vales into separate fields
This didn’t seem to work for I need to get the full values from the field into separate fields Multivalue field could equal [James wood, Stacy Lane, Guss Baker, Mark Martin]
Computed field
Field 1 [James wood]
Field 2 [Stacy Lane]
Field 3 [Guss Baker]
Field 4 [Mark Martin]