I'm looking for help with a Gravity Form which calculates the membership dues based on a few questions.
First thing, I need the form to be able to work like this - by itself with just the few questions. Here's an example of the form: http://idahoea.org/estimator/ - (this example just shows fields, doesn't do anything). In this case I want you to make the form just calculate and displays the amounts - no submission/notification takes place on backend (meaning results aren't sent to admin or recorded in gravity form entries). Basically we want a tool for people to quickly calculate the dues amount, like a calculator, but we don’t need to record the submission.
Secondly, I need the form fields (and calculations you’ll build for me) to be able to work in a longer form with additional questions. Here’s an example (idahoea.org/join). In this case the form would still need to calculate the amounts BUT it needs to be able to submit everything (including amounts) so that results can be sent back to an admin and also entry would be recorded in Gravity forms section in WordPress admin. Make sense? Ultimately I want to be able to use this calculated amount for use with a gravity forms plugin that works with paypal or authorize.net to actually bill the customer.
I've also attached the exported gravity forms for you to use for development.
The datasource is currently an excel spreadsheet (attached) with 164 entries. Each entry consists of a key field (District Name) and corresponding dollar amounts. I need you to add/import this as a custom MySQL table. I’m leaving it up to you to decide if this data is better off in one table or multiple tables.
After user fills out the questions, the form must look up the row that contains the District Name and corresponding dollar amounts.
For each District Name, the query will pull 3 different values (an NEA value, an IEA value, and a LOCAL value) from that row and display these results on form.
The NEA, IEA, and LOCAL values will be determined by how the user answers the questions on the form.
The form will display the correct NEA, IEA, and LOCAL value as well as add up these amounts and show a TOTAL amount.
I have included a ZIP file with the full job description (including examples and answers explained, an exported Gravity Form for you to use in development, and the Excel spreadsheet containing all the data).