Getting values from a table and concatenate them

Avatar

28-08-2008

Hi All,



I think somebody out there should be able to help me.



I have a list of contract numbers the user has to type in.



I've created a table where user can add as many rows as needed. Each row is a contract number.



Once completed, I have to concatenate all of the contract numbers, separated with commas, so that I can send them to a floating field within a text box.



It should look like this.

.....1234, 2345, 3456 and 5678 (assuming these four values were keyed in by the user in the table form)



Anybody can help me explaining how to concatenate the values and put them into the floating field?



Thanks in advance.



Rafael

Replies

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

28-08-2008

You can concatinate them easily but getting them into a floating field on the same form will be an issue. The floating field can only be filled when th eform is rendered and data is placed on the form. Floating fields are not interactive...so after the data load they are turned into text....they are not even fields anymore.