help with getting data from form

[Ben]

Hi bonkteam,

1.since i have a multiple choice of events i tried using an array,each cell of the array holds different event names - i figured the formtools will put it all under the same column at the spreadsheet i receive but the only thing i get under the column is the word "array". is there any way to receive data through an array and see it in the sheet?

When you say "array", do you mean group of checkboxes? If you ever need to group all the data in a single field in the database, make sure that the set of fields all have the same name attribute, e.g.

Code:

<input type="checkbox" name="event[]" value="event 1" /> Event 1
<input type="checkbox" name="event[]" value="event 2" /> Event 2
<input type="checkbox" name="event[]" value="event 3" /> Event 3
<input type="checkbox" name="event[]" value="event 4" /> Event 4

That will ensure all the selected events end up in the database. The double brackets "[]" at the end will ensure it's sent as an array and Form Tools will be able to understand it.

2.is there any way to collect a number of variables and place them under the same column in the sheet? (the way it work now is every variable gets a diffrent column)

Exactly. Every time you use a new form field with it's own name attribute, Form Tools will assign it to a new field. Try the above approach!

- Ben