Second try: I am working with a multi value field in a form and all works great. 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. I need to get the full values from the field into separate fields
The 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]
Subject: Need help with multi value field !!!
In R6, you can address the values of a list as if the list were an array. So you can make the subsidiary fields computed fields with formulas like this:
@If(@Elements(list_field) > 0; list_field[1]; “”)
That’s appropriate for Field 1. Change the numbers as necessary for other fields.
Subject: RE: Need help with multi value field !!!
This worked great thanks a million!
Subject: RE: Need help with multi value field !!!
Actually I am running into a little issue I don’t know or can control how many values are in the multi value field but I am going to have five single fields and am getting a error “ERROR :Array index out of bounds” if there are not five values in the multi value field.
Subject: RE: Need help with multi value field !!!
Thanks I was able to figure it out by changing the >0 value in each field