There are two forms, one from user type 1 and one from user type 2:
- User type 1 enters details in form 1
- User type 2 provider enters details in form 2 in response
The formula is as follows:
Calculation 1 for field in form 2
(([Form 2 field - form 1 field] x12) - [form 2 field2 - form 1 field2])) - [form 2 field 4]
Calculation 2 for field in form 2
((([Form 2 field - form 1 field] x12) - [form 2 field2 - form 1 field2])) x [form 2 field 3]) - [form 2 field 4]
I would like the calculation fields in form 2 to automatically calculate the fomula and autopopulate the field with the answer. These fields can be overwritten by typing if needed. I would also like a button which will allow the user type 2 to have the calculator pop up with the information prepopulated. They can then overwrite the information, recalculate and save which will overwrite whatever is in these fields.
Lastly, I would like a version of the calculator to be embedded into a page on the website so any type of user can access and use. This version would obviously be a blank version that the user types the fields into.
Preferrably I would like the calculator to show both calculations on the one screen.