order form with automatically calculation

Avatar

Avatar

madona33

Avatar

madona33

madona33

15-02-2021

Hi everyone,

 

I would need help to create a date and total calculation in an order form, I am really new in this field, I would appreciate any help, thanks

Basically, we are a small event organisation, we offer some products to our clients, the order form works brilliantly as it's but because we receive often  orders very late,we would like to add a script to do the following:

 

1- There is a field called "event start date " in DD/MM/YYYY format, so If the order has been filled in within 20 days prior to the event start date (event start date <= 20), then 20% surcharge will be added to the total (there is a field called "surcharge" before the total and will be added to the total charges) , if the event start date > 20 days then the form should work as it is

 

2- In case that the difference is <=20 then a notification should appear to notify the client that 20% surcharge will be added to the total due to the late order.

 

3- If possible, we don't prefer to add a field called " today's date" (we need only "event start date" ), so the script should compare the actual date with the event start date without entering the actual date.

 

4 - To stop the script from running , in case we receive and open the form within the 20 days (in case clients send it before the 20 days deadline), is it possible to lock the form after the client saved it , so the form doesn't pick up today's date and recalculate the total if we open it later  within the 20 days before the event.

 

Many thanks in advanced

 

date and time field date condition date range
View Entire Topic

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

23-02-2021

I would have to know the hierachy of your form to give a more suitable answer. Please provide some screenshots.