troubleshooting Question

Math calculations in a table by row

Avatar of BBGC
BBGCFlag for United States of America asked on
Web DevelopmentNetworking
2 Comments1 Solution1441 ViewsLast Modified:
Hello. I'm looking for advice to a project.  I am not too sure how to approach the project so here are the details. What I want to do is to create an online form of products that:
- is easy to maintain and update
- can perform basic math calculations
- can suggest complementary products to items that the user adds
- users can submit the form and send it to me
- eventually (2-3 years) have online ordering

I can create a database, using those handy wizards, in m$ access to do the calculations. But my experience with actual code writing is basic and i have no experience with online databases or any type of scripting language. Looking ahead I will probably hire someone for online ordering so there are no security issues but I would be maintaining it so I prefer to learn how to create it.  From my criteria I am assuming that I should do it in a database and I can add functions as I go...?

For now I am just looking for a basic online form that performs basic math. I am using Dreamweaver creating the website and there is a addon that allows for math calculations but it would put a heavy load on the user and is extremely hard to maintain. What I would like to do is to perform calculations based upon numbers/values in cells under specific columns instead of using hidden input values. Here is an example table:

<form name="Cold_Appetizers" name="Cold_Appetizers">
 <table>
  <tr>
   <th>Amount</th>
   <th>Item</th>
   <th>Price</th>
   <th>Minimum Servings</th>
   <th>Maximum Servings</th>
   <th>Total</th>
   <th>Minimum Serves</th>
   <th>Maximum Serves</th>
  </tr>

  <tr>
   <td>  <input type="text" name="amount1" id="amount1" />  </td>
   <td>  Cheese Tray  </td>
   <td>  10.00  </td>
   <td>  5  </td>
   <td>  15  </td>
   <td>  <input type="text" name="total1" id="total1" readonly="true" />  </td>
   <td>  <input type="text" name="min1" id="min1" readonly="true" />  </td>
   <td>  <input type="text" name="max1" id="max1" readonly="true" />  </td>
  </tr>

  <tr>
   <td>  <input type="text" name="amount2" id="amount2" />  </td>
   <td>  Fruit Tray  </td>
   <td>  15.00  </td>
   <td>  10  </td>
   <td>  20  </td>
   <td>  <input type="text" name="total2" id="total2" readonly="true" />  </td>
   <td>  <input type="text" name="min2" id="min2" readonly="true" />  </td>
   <td>  <input type="text" name="max2" id="max2" readonly="true" />  </td>
  </tr>

 </table>
 <table>
  <tr>
   <th>  Grand Total  </th>
   <th>  Approx. Minimum Servings  </th>
   <th>  Approx. Maximum Servings  </th>
  </tr>

  <tr>
   <td>  <input type="text" name="grand_total" id="grand_total" readonly="true" />
   <td>  <input type="text" name="avg_min_serves" id="avg_min_serves" readonly="true" />
   <td>  <input type="text" name="avg_max_serves" id="avg_max_serves" readonly="true" />
  </tr>
 </table>
</form>

There are 200+ items and I already have all the items and descriptions in various types of formats. I have it in an access database, xml,  and in tables. I just don't know where to begin. Please advise.


Thanks in advance.
ASKER CERTIFIED SOLUTION
amir22651

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros