Forms - ability to add multiple fields

CassAnne

Hi,

I've looked everywhere but cannot see if this is possible - or a work-around.

I want to use the forms to collect information from site. One of the most import pieces of information is deliveries. So I have it set up so that "Materials" is a field/column, and then multiselect, and a second column for the quantity. This works if there is only one delivery - they can select the material type and then enter the quantity. The problem is I need them to be able to choose a lot of different material options and allocate a quantity to each of them.

I ideally, if the form user could just add additional material and quant fields within the form that would be great.

Any other ideas? Adding multiple fiel

David Joyeuse

HI @CassAnne

Forms are a way to enter data on a new line of a grid in Smartsheet.

Thus entering multiple fields is not exactly the best way to do it.

Depending on the number of fields you need to enter at a time, and where you grab the info to put in the field, I would advice different solutions.

• First would be to only have two fields on your form: Materials and Number. Change form parameters to reload the page each time you click submit, allowing you to enter more rows. That can make the process quite tedious if you have hundreds of materials to enter at once and have to do this daily.
• Second, if you enter lots of this at once, would be to have a specific grid with two columns being materials/number. Have an automation to copy modified rows to the grid where you want to use it. Simply copy/paste your base data directly into the grid. then save. It's faster, but not really user-friendly.

Best ways I have found so far.

Hope it helped!