Forms: add multiple orders in #1 form but allocate to 1 row

Laura G

Hello

I have created an order form with an approval process to order work uniform, designed for employees to complete when they require certain garments. The form is set up to allow 1 item to be ordered. How would i set this order form up so our staff can order multiple items in 1 form and all ordered items appear in 1 row?

I would like the manager to receive 1 email with multiple clothing items for their approval

Thanks very much

John_Foster

Hi @Laura G,

The only way I could see this working is if each of the different garments were in a a separate column with columns potentially for the quantity and size of the garment as well as any additional columns if there for example colour options

John.

Laura G

Hi John

Thank you for responding. Instead of it appearing in 1 row, would you know how i set up the order forms so staff could order multiple items?

Kind regards

Monique Odom-Stearn

Hello @Laura G,

A form within Smartsheet is essentially a more customizable, user-friendly way of adding a new row on a sheet. One form = one new row in a sheet. If you'd like multiple rows, you will need one form for each item being ordered. If you'd like multiple items to show on the same row and same form, you could take John's suggestion: Create a separate column for each item size, color, etc. and have them all on one form.

Laura G

Great thanks for confirming @Monique_Odom_Comcast . I created separate columns as described above. For the approval process i am trying to create it, i then need to show all the fields on the approval email as each order will be different so the approval email looks a little messy.

As i type this im thinking, i could have an approval workflow for each product type as the condition so it only shows the required fields on the approval email?

Do you know once a row has been approved through a workflow, on the notification email is the approval status hardcoded to show yellow? Is there a way to change this colour?

Cheers, LG

Genevieve P.

Hi @Laura G

I agree that you could use multiple workflows on your sheet that look at the Product Type to determine what fields to show / approve.

There currently isn't a way to customize approval email formatting or notifications - please feel free to add your vote to this Product Idea: Formatting emails using automation

Cheers,

Genevieve