field is multivalue names
the formula is used in this context:
@if( condition ; @Set (“_variable”; @Name ([Abbreviate]; field) ; else )
is there a way to make @name grab all values form the field?
field is multivalue names
the formula is used in this context:
@if( condition ; @Set (“_variable”; @Name ([Abbreviate]; field) ; else )
is there a way to make @name grab all values form the field?
Subject: @name([abbreviate];field) picks only first value from field but should pick all
it works correct.
how did you check that it takes only 1 value?
btw, @set works only with local variables, so if you want to put the value into field = use @setfield
Subject: fixed
How I checked? This is used to bring together a lot of names from different field to send a mail to. @set was used only to put it all into a local variable.
From one field there was only the value taken. The field is set up as mutivalue names, when checking a document with the properties-box it appeared as
Field Name: Verantwortlicher
Data Type: Text List
Data Length: 67 bytes
Seq Num: 1
Dup Item ID: 0
Field Flags: SUMMARY NAMES
Thanks to the responses I ended up with
@Implode(@Name ([Abbreviate]; field);", ") which works fine.
Subject: fixed
How I checked? This is used to bring together names for email-addressing from different fields. @set is used to add the names from the field to a local variable.
From all field only the first value was picked when they contained more then one name. In designer the field is mutivalue names. When checking the document with the properties box, the field apperas as
Field Name: Verantwortlicher
Data Type: Text List
Data Length: 67 bytes
Seq Num: 1
Dup Item ID: 0
Field Flags: SUMMARY NAMES
Thanks to the respones I ended up with
@Set (“_variable”; @Implode(@Name ([Abbreviate]; Verantwortlicher);", "))
Subject: @name([abbreviate];field) picks only first value from field but should pick all
Olaf,
are you using @Set() function or @SetField() function. In this particular case, last one is the most appropriated as far as you setting a value for a form field, not a temporary variable.
FIELD := @If(condition; ; <else_value>)
is an alternative.
Also review, @Name([Abbreviate]; listvalue), check you are really working with a list, not an string concatenated by a list separator. If so, use @Explode(list_as_string; <string_separator>) to convert to a list.