Building an order form with multiple SKUs and quantities

Hello,

I am trying to build an order form where end users (internal employees) can order multiple quantities of various SKUs but I'm having a hard time doing it without adding a ton of logic. Today we have the users fill out an excel spreadsheet and then attach that excel spreadsheet into a basic form that captures other contact and order information. By removing the step with the spreadsheet it would make life a whole lot easier for everyone. For example:

An employee wants to order 4 different types of laptops: (3) 15" HP, (2) 13" Macbooks, (7) Dell workstations and (2) Microsoft Surface.

I would probably have a list of 25+ SKUs to choose from.

Any ideas or help would be appreciated!

Find more posts tagged with

Forms

Accepted answers

All comments

Andrée Starå

Hi @bdotarena

I hope you're well and safe!

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 hope that helps!

Be safe, and have a fantastic weekend!

Best,

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

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

bdotarena

Hi @Andrée Starå

Thank you for the response. I'm not totally sure I follow the workflow you've laid out. Do you have an example?

Andrée Starå

@bdotarena

Happy to help!

I'd be happy to share an example.

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

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

Annalisa

I am also trying to use a FORM on Smartsheet as an order form with multiple SKus and qty pls help

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.