How can I create a database of products in the form?

  • Profile Image
    Richardson_Kyle166
    Asked on February 10, 2021 at 05:51 PM

    How can I create a data base of products that the user can search for and click on to add to a order?

  • Profile Image
    Vick_W
    Answered on February 10, 2021 at 09:24 PM

    Hi Kyle,

    You can create a product database using our product list field. Your users will be able to search the products and order them as well. Please check the guide below to see how you can create products.

    https://www.jotform.com/blog/introducing-product-list-form-field/

    Here is how you can enable search within the product list.

    1613010229_60249535c359c_

    Please try it and let us know if you have any questions.

    Thanks


  • Profile Image
    Richardson_Kyle166
    Answered on February 11, 2021 at 04:39 PM

    Is there a way to do a product search without having a price field? I am looking to use this in the health care industry with medications.

  • Profile Image
    Vick_W
    Answered on February 11, 2021 at 08:56 PM

    Hi Kyle,

    We can provide CSS to remove the price from the product list. Unfortunately, there is no other field or widget available where you can list all your product and search them as well.

    Let us know if you have any other concerns.

    Thanks

  • Profile Image
    Richardson_Kyle166
    Answered on February 12, 2021 at 10:35 AM

    Ok, yes, how can I do this? Do I give yall my excel sheet with all the products or can I upload it myself? And how can I disable the price field on that feature?

  • Profile Image
    Welvin
    Answered on February 12, 2021 at 12:31 PM

    Unfortunately, there is no option that would allow you to upload a file and create/add the products in our Product List/Payment Field. You will have to add the product items one at a time.

    There is also no option to disable the prices. The workaround that was mentioned by my colleague is by hiding the price with custom CSS. It's only for the aesthetic, and that means you will still see the price through email and form reports.

    To hide the price, inject the following custom CSS codes:

    span.form-product-details {
      display: none;
    }

    Guide to inject: https://www.jotform.com/help/117-How-to-Inject-Custom-CSS-Codes.