I work for a company that specializes in replacement parts for ag implements. We distribute all around the country and sell to retail customers and wholesalers. Our retail customers are taken care of with our online store. I am trying to create an online order form for our wholesale customers, one that would be stored in Google Drive. This form would have five columns. Quantity of pieces ordered, Item Number, OEM Number, Description, Price, and total, and then a cell at the bottom of form for grand total. I need help in making a drop down list for the item column that will have auto complete, and have the next three columns fill with data specific to that item. The total column will be the quantity times the price. If anyone can help me with this I would be very appreciative and name my next child after you.
Why not just use a google form?
I'll try that. I'm obviously a novice when it comes to things like this. Thank you
InDesign is good for only the simplest of forms. If you want to use an Adobe workflow, you could design the background for the form using InDesign, then export as PDF. You could achieve the rest of what you want using Acrobat form fields. (or as BobLevine suggested, use a google form)