- davidvmAsked on May 12, 2017 at 04:00 AM
Hi, I'm creating a price quote form, where users select which services they would like to quote, and then we send the individual prices and total on email. Prices should not be visible on the form. I have been analyzing different ways to do this, and reading your documentation and forum posts, but haven't been able to reach a solution yet.
The Purchase Order seems like a good way to do this, by hiding the prices with custom CSS. But otherwise, how would I go about doing this with regular fields or form calculation? With hidden fields maybe? How can I display the calculation values in the email next to each selected service from a multiple choice list on the form? Right now I only get the total.
I want to show a table on the email with the detail of the services requested and their respective prices. See screenshot attached.
This is regarding the multiple choice field in page 3 of the form.
Thanks a lot in advance for your help!Page URL:
- JotForm SupportcandyAnswered on May 12, 2017 at 04:22 AM
To my understanding, your users will select the service they would like and you need to send them a price offer as an email.
As far as I see, you have a Purchase Order wizard on the form in order to receive orders. I recommend you to delete it from the form. You can use single or multiple selections instead of the Purchase Order. You can set calculation values to the single or multiple selection fields. Please check the following guide in order to see how to assign values to the selection fields: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value
You can calculate the prices with a Form Calculation widget and set it hidden on the form. Please check the following guide in order to see how to perform calculation: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget
You can edit the email content and set a table in it. You can also show the user's selection and calculated prices there. For further detailed information regarding autoresponders please check the following guide: https://www.jotform.com/help/26-Setting-Up-an-Autoresponder-Email
Please try and if you need further assistance, let us know. We will be glad to help.
- davidvmAnswered on May 12, 2017 at 05:16 AM
Hi Candy, thank you,
On the email, I also want to show each individual price next to each selected item, besides the total calculation. That's the part I'm not being able to do.
I had already added calculation values and the calculation widget. But I don't know how can I hide the prices on the form, but show them individually on the email, besides the total amount.
- JotForm SupportNik_CAnswered on May 12, 2017 at 05:46 AM
Could you please confirm, your issue is with this page and fields:
You want when your users select some of those to show the price in the submission email?
Is that what you need to do?
Please let us know so we can review the possibilities.
- davidvmAnswered on May 12, 2017 at 02:22 PM
Hi Nik, thanks, yes that is the right field and what I need to do.
- JotForm SupportNik_CAnswered on May 12, 2017 at 03:24 PM
What do you think about this solution:
1) We add the price for each option, but as a div tag and defined class:
-we call the class "pricecolor" or anything else:
2) Then we change the color of text for that class by adding the below CSS code to Custom CSS field:
And I set that color because that is the color of the background where those options are showing, so it will make them "invisible":
But it will still show in submissions:
Please check my test form: https://form.jotformpro.com/71315722792962
I added the price for first 9-10 options, so check and please let us know your thoughts.
- davidvmAnswered on May 13, 2017 at 02:35 AM
Thanks Nik! Great option, I wasn't aware html could be added in the Options field.
However, is it possible to separate product name and price into different table cells, in the email? Or at least in the same line. Like the example I posted.
Is it also possible to give the price an id or something, so that on the email template I could designate where it should show?
I'm thinking another solution could be using conditions to insert a hidden price field that will show on the email, and I can place it where I want it to appear. But I'm not sure if this could be done with a single multiple choice element, or if I would need several independent elements. Would the "copy multiple field values" option in Conditions maybe help me here?
- JotForm SupportNik_CAnswered on May 13, 2017 at 04:46 AM
We can use that method as well, I mean with conditions. We can create a table-like Notifier where the products will be shown, the issue is how to show the separate price for each product. And the only way to show all the prices, for each product separately and to look like your table above is to have a separate field for each product's price.
For example, you have this field Total in your form:
And condition to insert the price in the Total field. We can make that as a table in the email:
But, as you can see it is the total price, and as I said above, the only way would be to have a separate field, like Total field, for each product where we insert the price, and we insert that in the field, for example:
But there is another issue there. If we use one field for all those products, I mean one radio button field with all options, inserting the price in the text fields above will not work properly since it will insert all prices together. For example:
Those three selected will show the price like this:
So the complete solution I see at this time is to create all products as separate options with separate prices fields, only with that setup you will have control over all fields, I'll show you on few what I mean:
And this is how it can be shown in the email:
And you can hide the prices in the form, but it will be shown in the email.
Here is my test form: https://form.jotformpro.com/71321585292961 I left the old fields as well.
So please check.
- davidvmAnswered on May 13, 2017 at 05:23 AM
Thanks a lot for such great and elaborate answers. I'll give it a try tomorrow.
I had already done something similar with extra fields and conditions, check my form.
- davidvmAnswered on May 17, 2017 at 04:19 AM
Hi Nik, thanks a lot for your help, that option worked great! A lot of field configuration was obviously needed though, but also because I'm calculating discount and installments too.
Thanks Candy for you help as well.
- JotForm SupportcandyAnswered on May 17, 2017 at 04:48 AM
On behalf of my colleague and myself are glad that your form is working as you expected. You are welcome.
If you need any assistance, do not hesitate to contact us.
Have a good day!