Posts: 55
Threads: 25
Joined: May 2009
Reputation:
0
I have a client whom would like to have the ability in the backend to use fields that can auto caculate. They want a quote system for clients to fill out BUT only have the calculations done INSIDE Formtools.
Has anyone done anything like this before?
Posts: 2,456
Threads: 39
Joined: Dec 2008
Reputation:
6
Cool! No, I haven't heard of that exactly - or at least, not done to any great extent. I've heard of people using the Submission Pre-Parser module to execute code to do math on the data (count things up, etc) and update a separate field - but not within the Form Tools interface.
How extensive is the math they want to do? What kind of things?
- Ben
Posts: 55
Threads: 25
Joined: May 2009
Reputation:
0
They want to be able to the following.
Add a form to the website to collect QUOTE information for a wedding MINUS the cost (No Problems here).
They want the cost to be in the database for ONLY them to access (the whole competeror thing)
EXAMPLE:
Flower(s) cost X multiply by NUMBER = Total
Do this on multiple fields with a running total.
They also want a CLIENT owes X amount and be able to apply payments subtracting till 0.
I assume I can just pull all of the data out of FT and build an interface. As you know this will be no easier undertaking.
Posts: 30
Threads: 18
Joined: Mar 2014
Reputation:
0
Just curious if anything has changed since this was posted. I too would like to have some auto calculating done on the fields in my database.
Posts: 46
Threads: 16
Joined: Feb 2014
Reputation:
0
Hi
I have the same requirement for a 'quoting' form.... to replicate an existing Excel spreadsheet.
What I am doing is using the Hooks Manager (for ft_update_submission,start) to trap the incoming fields and to do calculations on them before they are stored. Early days but seems to work OK. Just watch out if you are using tabs and you want to alter a field on one tab based on changes in another. The UPDATE button only submits fields for that tab so you might have to do some jiggery pokery in SQL as well as the form's variables.
