Comma separated values to new record in table

[NikkiC]

Hi there,

I've built a page that has a grid of images, allowing users to click on these images to make a selection ... and then I want these selections to all be saved to a table as separate entries along with their user information.

So far, I can get only 1 selection to pass to the table.  If they click on one of the images, that is sent to the table, fine.  I've set it up so that each selection is added to the string, separated by a comma, but then this passes to the table as a single entry with the comma separated string.

This is my code:

function SelDatasource1() {
    document.getElementById("Datasource1").className = "SELECTED";
    document.getElementById("InsertRecordDatasource").value += "Datasource1,";
    document.getElementById("InsertRecordProject").value += "[@authfield:User_info_Project],";
    document.getElementById("InsertRecordDatasource").multiple = true;
}

function SelDatasource2() {
    document.getElementById("Datasource2").className = "SELECTED";
    document.getElementById("InsertRecordDatasource").value += "Datasource2,";
    document.getElementById("InsertRecordProject").value += "[@authfield:User_info_Project],";
    document.getElementById("InsertRecordDatasource").multiple = true;
}

...etc etc ... there are over 30 of these.

If somebody selects Datasource1, Datasource5, Datasource12, it shows up in the table like this:

PROJECT                                         DATASOURCE

Project1,Project1,Project1          Datasource1,Datasource5,Datasource12

I am using a Submission form datapage at present, and have added my code using html blocks and footer.

2 things I need help on:

1. I know there is a better way to add a comma to the string, other than putting it in like this (i.e. value +="Datasource1,").  This way, a comma is added for a single entry and at the end of a long string, which I don't want to do - can anybody help me with this?

2. Can I pass this comma separated string so that it shows up in my table like this:

PROJECT                                         DATASOURCE

Project1                                          Datasource1

Project1                                          Datasource5

Project1                                          Datasource12

Any help would be greatly appreciated!

Many thanks

Nikki