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