Order Form - Item Cost Total

Anthony DAmbrosio

Hello Smartsheets Community,

I have created a simple order form for our smaller customers to use to submit their orders. Based on the screen shot below, when a dealers chooses the 1961 Totes to order, the individual item numbers will be visible as check boxes. If a dealer clicks on an item number to order, it will open up an order qty field and a total field.

Does anyone know if there is a way to have the total field automatically populate based on the order qty inputted into that field? For example, if someone clicks on GRN_1961_01 and inputs an order qty of 3, and that item costs $1.00, then $3.00 will automatically populate into the total field? I hope that makes sense.

Any help or ideas would be greatly appreciated and looking forward to the responses.

Hope everyone is doing well and having a great week so far!

Paul McGuinness

Hi @Anthony DAmbrosio

Unfortunately webforms are one way and cant complete a active calculation to work out a total as you require and then represent that back into the webform as an output.

You could possibly use logic, i.e. if box x is ticked and quantity is 5 then show a field with 15 in but that would require a huge set of multiple logics that would exceed the limitations for logics within the webform.

Sorry, not the answer you were hoping for.

Thanks

Paul

Andrée Starå

Hi @Anthony DAmbrosio

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• Depending on how many options you have you could maybe use conditional form logic.
• Another option could be that they select the item and quantity and it also lists the total and then the calculations would be done on the sheet.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

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!