PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Gravity Form with Pricing Table to select quantities

  1. I have a situation where the client has a massive list of products. She requires that the site visitor can see the list of products, like in a spreadsheet, on the website and then for the visitor to be able to tick next the product that he/she wants to order and also indicate next to the tick the quantity that he/she wants to order. Once the visitor submits the order the list/spreadsheet will then go to my client so that she can see which products has been selected and the quantity of each.

    I am busy with it here to give you an indication - http://herbandspicegirl.co.za/products/herbs-spices/

    I have thus far used Google Docs to create the tables but I really need the tables to be part of my gravity form so that the visitor can choose dynamically as indicated above.

    I know it sounds simple but I am really finding it difficult to find a solution for this. I sincerely hope that you can assist me with this.

    Posted 12 years ago on Tuesday July 17, 2012 | Permalink
  2. In addition to just selecting the spice and the quantity, will there be any commerce involved? Or will they just make their selections and submit that information to your client?

    Gravity Forms is not a shopping cart and we won't be able to make it one here. But if you're just looking to submit a list of products selected, and their quantities, we might be able to figure out how to do that.

    Also, there is no provision to import information into Gravity Forms, which may make maintenance burdensome as well.

    Posted 12 years ago on Tuesday July 17, 2012 | Permalink
  3. Hi Chris,

    Thanks for the prompt reply.

    The client only wants to create a shopping cart environment at a later stage so no, currently there is no commerce support needed. For that I will create a separate solution from Gravity Forms in the future.

    I am also aware that there is no provision to import a spreadsheet so yes I am going to have to copy/paste each product one by one.

    For clarification: The site visitor needs to see the full list of products and next to each product there needs to be a tick box to mark/select the product and then next to that there needs to be a field where the site visitor indicates the quantity of the product required. My client will then receive an email with the full list where she will be able to see which field relating to the product has been ticked and of course the quantity relating to that product.

    Obviously below this list there will also be fields for delivery address etc as per normal but that I don't have a problem with. It's only the part as indicated above.

    This seems like quite a simple request but I have been looking around the Internet to no avail. Thanks a mill and I await your response eagerly.

    Posted 12 years ago on Tuesday July 17, 2012 | Permalink
  4. I think you could use conditional logic to show a field where the quantity can be entered. So, a checkbox list of all your products, and when a checkbox is ticked, the quantity field is revealed and the quantity is entered.

    However, this seems overly complicated. Why not have your list of products with a quantity field next to it, pre-fill the quantity with 0, and allow them to enter a quantity. Then, your submission will contain a quantity greater than zero which indicates interest in a product.

    There may be other solutions as well, with some creative thinking.

    Posted 12 years ago on Tuesday July 17, 2012 | Permalink
  5. Hi Chris,

    I am pretty new to Gravity Forms.

    In your 1st suggestion, which field boxes do I use? A checkbox + another field for conditional logic?

    In your 2nd suggestion, which field boxes do I use? Perhaps a list field but how do I pre-populate list box content and can one dynamically create new list rows maybe with conditional logic? When I preview list boxes they are just empty boxes with the option to ad more and more rows.

    I will try either suggestions if you could please indicate which I should select on the right. Once I know that I could play with it a little more.

    I am sure once I am more confident with GF, creative thinking will fall in place;-)

    I actually can't believe that such a simple request can become so complicated with GF.

    Posted 12 years ago on Tuesday July 17, 2012 | Permalink
  6. Hi Chris,

    I have now set it up with a few items of products from "All purpose seasoning" to "BBQ – seasoning" using conditional formatting on this link - http://herbandspicegirl.co.za/products/herbs-spices/ and all works fine HOWEVER:

    When the email comes through with the order request it only contains the list of products and all the other fields in the form but none of the quantities for the products.

    Where am I going wrong???

    Posted 12 years ago on Tuesday July 17, 2012 | Permalink
  7. If I submit your form as a test, will I receive a copy of the notification showing the problem you describe? Can you export the form as XML and send it to me at chris@rocketgenius.com and I will take a look?

    Posted 12 years ago on Wednesday July 18, 2012 | Permalink
  8. Hi Chris,

    The above problem is strange and it's going to come back and haunt me some time in the future.

    I have therefore decided to follow a different approach. I have created a seperate section of the website just for the orders and I am using checkboxes with Conditional Logic and it seems to work a 100%. I am now busy working on the first batch and up to "BBQ - catering" all works well - http://herbandspicegirl.co.za/order-products/herbs-spices/

    Let's just hope and pray there isn't a limit to the conditional logic fields.

    Unfortunately I have already deleted the previous form so I don't have the XML for it anymore but I will keep your email for future use in case the problem appears again.

    Now that I have dug deeper into GF I am convinced that I am still going to do some powerful stuff with it in future. I am particularly interested in dynamic field population and think that it in combination with conditional logic has a lot of potential.

    Thanks for your help - Gravity Forms rock! and it's worth every cent I paid for it.

    Posted 12 years ago on Wednesday July 18, 2012 | Permalink
  9. Thank you for the update. I like your new approach. If you need any assistance, please let us know.

    Posted 12 years ago on Wednesday July 18, 2012 | Permalink
  10. Will do, thx.

    Posted 12 years ago on Wednesday July 18, 2012 | Permalink
  11. tmaculate1
    Member

    I hope you don't mind me cutting into this thread but I am needing a table setup similar to yours and wanted to ask how exactly you set up the columns with the titles above them?

    I appreciate any feedback you can provide for me. ;-)

    Posted 12 years ago on Wednesday August 8, 2012 | Permalink
  12. @tmaculate1 - please being a new topic for your question. Be sure to ask for exactly what you need help with, and provide a link to any form page you want help with. Thank you.

    Posted 12 years ago on Wednesday August 8, 2012 | Permalink

This topic has been resolved and has been closed to new replies.