E&P Form Builder costume price calculation?

[irfanabd]

I want to build form for party rental services, in this case i build this form for tent tools.

It’s posible to make form:

1. Add 1 product value price (ex: IDR 10,000 per meter).
2. I used weight x height for calculate the price. (ex: 10m x 10m = IDR 1,000,000, or 20m x 20m = IDR 4,000,000).
3. And the minimum transaction required is IDR 1,000,000 for each transaction form.

This how i’m stuck in this situation.

1.In E&P Form Builder Plugin Page, Edit Form >> Edit Step >> Add New Item >>
I give a name Width.
“Type of item”, i’m choose Number field.
“Minimun size”, i’m set to 1 qty value.
Activate “Use value as quantity ?” and set price to $ 1.

then i’m duplicate the item and rename it to Height, cause it’s have same value as i needed.

in this step i get what i want, (1 meter equal to IDR 10,000)

2.After create Width & Height items. I’m create Calculation item.
It’s name Calculation.
“Type” of item is “Checkbox”.
Activate “Use calculation ?” and i add a value width and height item with asterisk (*) in between. ex: [item-1_value] * [item-2_value]
“Is selected ?” and “Is hidden ?” option is active.

in this step, multiplication (x) calculation does’t work. Instead, it becomes a sum (+).

3.Also minimum of transaction that i want is IDR 1,000.000, does’t work at all. The value below can still pass without any warning.
I use “Is required ?” option. Add a condition: [item-1_value] * [item-2_value] if(([total] <1000000)) { }

For guide that i follow:

1. http://www.wordpress-estimation-payment-forms.com/documentation/

https://www.youtube.com/watch?v=xH8frpa7wL0

I know it’s hard to get what i wanted to say, but i hope you understand.

Thank you for attention.

[rad]

Hi @Irfan_Abdurrafi,

Thanks for reaching out.

It seems to be working just fine on my installation based on the video you have provided, but, what I’m not sure is how it’s implemented to your site. Would you mind providing your site’s URL and admin login credentials in a secure note? And please provide the page that has this form.

Thanks!

[irfanabd]

Yes, it’s just fine if we follow the video.
(WxH) 10x10 = $100 (without the custom base price for 1 item).

@Irfan_Abdurrafi

Activate “Use value as quantity ?” and set price to $ 1.

Sorry, I just notice, it’s not $ 1, and it should be IDR 10,000.
(today is USD 1 = IDR 15,000)

• But what i want to: 1pcs product set to IDR 10,000 (question 1).

• I use this formula [item-1_value] * [item-2_value] (question 2).
  It’s getting annoying after i’m adding base price for the item, each item Width and Height equal to IDR 10,000.
  It’s change, not multiplication (x) calculation what i want, it’s sum (+) calculation.

Summary:

• IDR 10,000 for based price (1 item value).
• 10 items x 10 items = 100 items = IDR 1,000,000 in total price, based from (100 items x IDR 10,000).

Do you understand what I ask, not what the video says?

[christian]

Hey Irfan,

I’ve exported your forms and imported it to my test site and I see that the Use value as quantity causes the multiplication to sum in the calculation so I’d recommend that you turn that option off and use manual calculation instead like [item-236_quantity] * [item-241_quantity] * 10000.

Not sure what you want to do or how you want to handle if the transaction is lower than a million but you could set the minimum width and/or height right out of the box so your customers won’t continue with the calculation.

If I’m not understanding your correctly, please would you mind providing more details?

Thanks.

[irfanabd]

Hey Christian,

Thank you for answering questions 1 and 2. It works like I want.

And go to question 3 that I haven’t given the details yet.

The minimum transaction is IDR 1,000,000.
This means that the user (buyer) cannot pass the product page / buy the product to continue ordering. This is required and not optional.

This means that the final cost listed is one million or more, and cannot be under it.
I want the user to not be able to pass the page because the quota is not fulfilled, and give a warning about the minimum order that must be met.

And the total price that appears in the final cost must be IDR 1,000,000 or higher. It can’t be IDR 900,000 even though it only decreases 1 value.

This is the simple analogy:

There is a bus with a capacity of 100 seats.
The driver wants 50 seats to be fully filled before the trip go.
If the seat is only filled with 20 or 49 people, the trip cannot be carried out because it does not meet what the driver wants, 50 seats are filled.
But if there are already 51 seats or more filled, the bus can travel.

"We will not travel if the quota has not been fulfilled."

For question 3 I use the formula:
if(([total] <1000000)) { }

Let me know if that (minimum transaction) can be done or not, or tell me if the formula I use is wrong.

[irfanabd]

Hello, did i need to create another thread for this topic?

[ruenel]

Hello There,

Just for future topics, self responding or bumping your post pushes it back in our Queue system so it takes longer to respond to.

You must used this formula:

if(([total] <1000000)) {

}

And make sure that the total is the result of your computation which is [item-244_value] * [item-245_value] * 10000

Hope this helps.

[irfanabd]

Hello,

It’s okay if I keep getting attention, thanks for that.

And how to do that?

I try that way before:

if(([total] <1000000)) {

}

And the result is:

If you see it, the “minimum price limit” can still be less than one million.

Let me know if I make a mistake.

And let me repeat the question.
I want to set a minimum price value to IDR 1,000,000 (in the progress bar). Prices can go up to IDR 1,000,001 and so on, but can’t drop to IDR 999,999 and below.

It’s like a barrier or something like that, which makes the value not less than one million.

I have asked Loopus Dev, and they say it can be done, but of course without telling the way.

So the value at the final cost is equal to one million or higher.
No less than that, like IDR 800K or under one million like the following image.

I’m waiting for a future reply.

[christian]

To achieve that, set the Initial Price to 1000000 in the General tab. You also need to enable Hide initial price in the progress bar ? which is weird.

Set your number fields Min Size and Default Value to 10 so your users see the starting point and can’t set a value less than 10.

Also weird but, you need to deduct the Initial Price from your total because the total will be added to the Initial Price giving you an incorrect result. We’re only enabling the Initial Price to set the progress bar starting point.

([item-236_quantity] * [item-241_quantity] * 10000) - 1000000

Also add a message so it’s clear what your minimum is. I’ve recorded the final result of that setup. See https://youtu.be/XlfxZo62Rdo

Hope that helps.

[irfanabd]

Thank You Christian for answering my questions.

But it’s a little different from what I mean and more like “limit the price”, not limiting the quantity.

The price is frozen at one million. Or if more than that, a warning will appear about the order cannot be done.

But the quantity is not limited to below 10 (Width & Height).

10 x 10 = 100 (IDR 1,000,000)
5 x 20 = 100 (IDR 1,000,000)
7 x 15 = 105 (IDR 1,050,000)

And when the user enters a value of 9 x 9 = 81 the price remains at one million. Not 9 x 9 = 81 (IDR 810,000).

Did You get it? or its possible to do?
Let me know.

[rad]

Hi @Irfan_Abdurrafi,

I created a duplicate of your form named Online Reservation BY X

The working calculation is this

if( [item-248_value] * [item-249_value] > 100 ) {

( ( ( [item-248_value] * [item-249_value] ) - 100 ) * 1000 ) + 1000000

} else {

1000000

}

It’s based on these given values

10 x 10 = 100 (IDR 1,000,000)
5 x 20 = 100 (IDR 1,000,000)
7 x 15 = 105 (IDR 1,050,000)

And a limit of not smaller than 100 (WxL).

I also made the minimum value to 1 to make the calculation for 5 x 20 = 100 (IDR 1,000,000) possible.

Thanks!

[irfanabd]

Oh my, Thank You very much for not giving up answering my question.

Yes, this thread is solved.

I hope Themeco team provides a way to use this calculation in depth.

And again, thank you.

[friech]

We are delighted to assist you with this.

Cheers!