Is it possible to duplicate columns in Web Forms?

Jamie Lovell

I need to collect data that I need to duplicate 10-15 times. Is it possible to use web forms to collect the information and have it move to seperate rows as the customer fills in on one web form? Is there an efficient way to do this without creating 30-40 extra columns?

Joel Johnson

Jamie,  can you explain it a bit more of what you are needing, or if you have an image of what you are looking to accomplish that may be helpful.

Travis

Not exactly - a web form can only be used to add data to a single row. You could build multiple web forms and set the "Submit" button to reload the web form or load a new web form. For example, the first web form contains questions 1-10, when they submit the web form, a second web form loads, which contains questions 5-15. 

Jamie Lovell

Thanks for the responses Joel and Travis. I'll proceed accordingly.

 

Alina Anderson

Hi Jamie,

 

One strategy I've used for repeating data and building custom reports is to use create additional hidden columns with formulas. The formulas will auto-populate the cells based on the initial web form data entry. Then the reports can pull from the additional columns based on your criteria.

 

Here is more formula info: http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas

 

Hope that helps!