How to create custom formula for shopping list

How to create custom formula for shopping list

Hi there - 

Here is what I am trying to do. I have a business that allows people to shop with us  I would like to create an application, that uses Zoho Creator, where users can click a check box and then get a report of the equivalent from our store.  

So for example
If the form had a section called Bathroom supplies and there were a series of checkbox like like
  • Soap
  • Shampoo
  • Mouthwash
  • Shower Cleaner
When the user chose a few products and submitted the form it would show our product and price based on those checkboxes. 
  • Acme Soap on a Rope  $6.00
  • Acme Shampoo  $4.00
I am very open to how to accomplish this.  I could create a spreadsheet that has a formula that simply said "if cell is checked then value = "

Hope that makes sense.  

Dale