I've got several tables scripted so users can add and remove rows depending on how many items they're adding. Now I have a situation where I'd like to do the same for columns...is that possible? Instead of an "Add Row" button, can I make something like an "Add Column" button work?
I have a table for Likert scale feedback data. For any given collection, I could have as many as 40 responses (completed feedback forms)...but I generally only have 15 - 25. If I have to, I'll simply set the table up to have 40 columns, but it would be so much slicker to start with 20 and let the user add the columns they need depending on the data they've got.
I suspect I could figure out how to create the entire table dynamically in response to user input...but this form is for an interim process and will probably only be used for a couple of months, so I can't spend a lot of time rooting around in the scripting reference, much as I'd love to.
(I've also thought of reversing the rows & columns, so that adding more responses would mean adding more rows, but it would be pretty clunky in this context.)
So...is it possible to add columns to a table in response to user input?
Thanks!
http://forms.stefcameron.com/2006/10/28/scripting-table-columns/