I have 2 problems
1. I have a dropdown menu that gets the energy suppliers (developers) from a database which a corresponding price in another column (price). My problem is how can update a textbox with the corresponding price of the selected dropdown value?
Here's my input fields:
And here's the database where the values would be referred:
2. My second problem is, when a user inputs all the field, I want to calculate the user input into a text field that'll show how much a user has to pay he uses clean energy. Here's my calculation formula:
Kilowatt usage x price + admin fee (.01 x kilowatt usage) = total price
Here's sample screenshot of the input fields:
I am new to wix and have very minimal jquery skills, so any detailed would really be appreciated.