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!

Andrée Starå

Hi @CassAnne

Double post? Posting here as well.

I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

Would that work/help?

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

T.Shuya

How then do you get approvals with the two form approach when all the items would appear on different rows?