Payments / Price Range Issue - Post...

User 187934 Photo


Senior Advisor
20,187 posts

So tell me what you need again and can you post a link to your test form?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2701655 Photo


Registered User
25 posts

I need to be able to specify unit prices with 4 decimals, for each price range defined in the form e.g. : 0,0387 for example.

So far i've specified 0,05 / 0,04 & 0,03 depending on the quantity.

Here is the link : http://www.fidealiste.fr/Order_Test_exp … _Test.html

Thank you SO much !!!

User 187934 Photo


Senior Advisor
20,187 posts

So is the the number format 0,0387 or 0.0387?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2701655 Photo


Registered User
25 posts

In Europe we use the ',' to separate decimals, but i know that in the US you use '.'.
WFB uses '.' in the unit price field so you can keep it, it doesn't matter.
Best,
David
User 187934 Photo


Senior Advisor
20,187 posts

Ok, this should be doable as long as I'm understanding the need correctly. I'll take a look at this later today.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2701655 Photo


Registered User
25 posts

Thank you Eric that's awesome !!!!

Can you please also look into this issue i found out which is quite annoying : When i select a range within the form (e.g. : Range 1 from 100.000 to 500.000), the number of points requested appears and then I type 150.000, which goes through the price multiplier for the payment page. Good.

BUT If i made a mistake and decide to select another range just after typing the first range quantity (e.g. : let's say Range 2 from 500.001 to 2.000.000), and i type 550.000, the form keeps in memory the first 150.000 i've typed in the first range and sums up everything when it goes to the payment page.....

So my question is : How can i clear/delete/reset a field if the user changes range ??

Thank you for your help.
Best,
David
User 187934 Photo


Senior Advisor
20,187 posts

Yes this would be an issue that I have also had. There's workarounds but takes a while to code all the logic.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2701655 Photo


Registered User
25 posts

Damn !! This is crazy.....

I don't know anything about JQuery but can't we program something like an Excel Formula into JQuery within an HTML element :

B1 is the field in which the quantity has been typed. The result should appear in a Total Field following the following formula/logic :

=IF(AND(B1>=100000;B1<500000);B1*0,05;IF(AND(B1>500001;B1<2000000);B1*0,04;IF(B1>2000001;B1*0,03;)))

And the payment page should take this result for payments.

Is this possible or am i totally dreaming ?
User 187934 Photo


Senior Advisor
20,187 posts

You can do simple math in JQuery but it's not setup the same as Excel.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2701655 Photo


Registered User
25 posts

Thanks,
Do you know where i can quickly learn the syntax so i can modify the form myself ?

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.