need help to to log multiple field with format

[tofuzion]

Hi, Could someone please help me on this..

I have 3 field with a repetitions 1-10, and i want to create a botton that will copy the texts of that 3 field into an other layer/field with a proper format

I tried

Set Field [textbox2; textbox2 & ", " & textbox1]

but the result really messy and and it not work with repetitons 1-10

[Raybaudi]

Hi

too bad that you haven't the List ( ) function !

The script would be as simple as:

Set Field [ yourDB::field1; Subtitute ( List ( yourDB::rep1 ) ; ¶ ; ", " )

for each repeating field (rep)

[tofuzion]

Hi raybaudi

I tried your way but i don't understand it

what i tried to do is save 3 fields into field1 on a different table. and everytime i press the button new data from that 3 fields keep on saving into field1

log.zip

[mr_vodka]

Try this.

Create a repeating calc field (as many reps as your other repeating fields)

Case ( not IsEmpty ( description ); Extend ( datefield ) & ", " ) & description

Then create a value list zUtilField and reference the calc field.

Finally set the script to be

Set Field [ save::log; ValueListItems ( Get ( FileName ) ; "zUtilField" ) ]